Top 10 Administrative Assistant Skills
- Organization
- Time management
- Interpersonal skills
- Written communication
- Verbal communication
- Attention to detail
- Microsoft Word, PowerPoint, and Excel
- Adaptability
Then, How do I prepare for an admin interview? How to prepare for an Administrative Assistant interview
- Research the company
- Understand the job description
- Run through your job application
- Prepare your elevator pitch
- Familiarise yourself with how you will respond to the more common interview questions
What are the 7 administrative roles?
Seven excellent administrative skills to include in a resume
- Microsoft Office
- Communication skills
- The ability to work autonomously
- Database management
- Enterprise Resource Planning
- Social media management
- A strong results focus
furthermore, What are 4 administrative activities? What does an administrator do?
- Preparing, organising and storing information in paper and digital form
- Dealing with queries on the phone and by email
- Greeting visitors at reception
- Managing diaries, scheduling meetings and booking rooms
- Arranging travel and accommodation
- Arranging post and deliveries
What is the most important skill of an admin? Problem-solving and critical thinking skills are important for any administrative position Administrators are often the go-to person that staff and clients seek out for help with questions or problems They must be able to hear a variety of problems and solve them using critical thinking
What is your weakness best answer?
Answer “what is your greatest weakness” by choosing a skill that is not essential to the job you’re applying to and by stressing exactly how you’re practically addressing your weakness Some skills that you can use as weaknesses include impatience, multitasking, self-criticism, and procrastination
How do you handle stress?
Healthy Ways to Cope with Stress
- Take breaks from watching, reading, or listening to news stories, including those on social media
- Take care of yourself
- Take care of your body
- Make time to unwind
- Talk to others
- Connect with your community- or faith-based organizations
- Avoid drugs and alcohol
Why should we hire you as an administrator?
Example 1: Office administrator “You should hire me for my passion and proven abilities in organization for office efficiency I pride myself on my time management, coordination and interpersonal skills
What is DCL in DBMS?
Data Control Language (or DCL) consists of statements that control security and concurrent access to table data COMMIT Instructs the XDB Server to make permanent all data changes resulting from DML statements executed by a transaction CONNECT
What is DBCC in SQL?
Microsoft SQL Server Database Console Commands (DBCC) are used for checking database integrity; performing maintenance operations on databases, tables, indexes, and filegroups; and collecting and displaying information during troubleshooting issues
What are the 5 basic SQL commands?
Some of The Most Important SQL Commands
- SELECT – extracts data from a database
- UPDATE – updates data in a database
- DELETE – deletes data from a database
- INSERT INTO – inserts new data into a database
- CREATE DATABASE – creates a new database
- ALTER DATABASE – modifies a database
- CREATE TABLE – creates a new table
What is 1NF 2NF 3NF and BCNF?
A relation is in 1NF if it contains an atomic value 2NF A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key 3NF A relation will be in 3NF if it is in 2NF and no transition dependency exists
What is trigger in SQL?
A trigger is a special type of stored procedure that automatically runs when an event occurs in the database server DML triggers run when a user tries to modify data through a data manipulation language (DML) event DML events are INSERT, UPDATE, or DELETE statements on a table or view
How do I repair a corrupt SQL database?
How To Repair a Corrupted SQL Database
- Step 1 – Attempt Repair with SQL Server Management Studio (Optional)
- Step 2 – Choose a Good Database Repair Tool (Recommended)
- Step 3 – Download Your SQL Repair Tool
- Step 4 – Run Your SQL Database Repair Tool
- Step 5 – Scan the Corrupted SQL Database
What is DBCC DB check?
DBCC CHECKDB is the T-SQL command that checks the logical and physical integrity of all the objects in a specified database Most DBAs probably don’t think twice about running DBCC CHECKDB regularly—until their databases start to get very large
How do I check SQL database for errors?
Run the “DBCC CHECKTABLE” query in Microsoft SQL Server Management Studio
- Click on the New Query option
- Type DBCC CHECKTABLE(‘TableName’) example DBCC CHECKTABLE(‘dboVideoFile’) – Execute query
- If allocation errors or consistency errors are found, run below commands
Which DBA is best?
Top 5 database certifications
- IBM Certified Database Administrator – DB2
- Microsoft SQL Server database certifications
- Oracle Certified Professional, MySQL 57 Database Administrator
- Oracle Database 12c Administrator
- SAP HANA: SAP Certified Technology Associate – SAP HANA (Edition 2016)
What are the four 4 types of database normalization?
First Normal Form (1 NF) Second Normal Form (2 NF) Third Normal Form (3 NF) Boyce Codd Normal Form or Fourth Normal Form ( BCNF or 4 NF)
What is Normalisation in SQL?
Normalization is the process of organizing data in a database This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency
What is a primary key in DBMS?
A primary key is the column or columns that contain values that uniquely identify each row in a table A database table must have a primary key for Optim to insert, update, restore, or delete data from a database table
Is DBA job stressful?
“A Database Administrator has a special responsibility for a component that is critical to the success or failure of a business: its DATA This makes being a DBA very challenging and stressful given its many responsibilities
Which DBA has highest salary?
The top 5 highest paying jobs who knows DBA with reported salaries are:
- associate director – ₹45lakhs per year
- senior manager – ₹34lakhs per year
- technical solutions consultant – ₹30lakhs per year
- senior oracle dba – ₹21lakhs per year
- postgresql dba – ₹20lakhs per year
Is DBA high paying job?
The average DBA salary in India is around ₹ 5 Lakh Per Annum Their salary starts from nearly ₹ 3 Lakh Per Annum and goes up to ₹ 15 Lakh Per Annum It’s one of the most sought-after roles, and there’s a massive demand for database administrators in the country as well
What is DBA role?
Short for database administrator, a DBA designs, implements, administers, and monitors data management systems and ensures design, consistency, quality, and security
What is DBA in SQL?
A database administrator (DBA) is the information technician responsible for directing and performing all activities related to maintaining a successful database environment
How many types of DBA are there?
For a more comprehensive look at the skills and abilities required for these eight types of DBAs, download our white paper, The Many Different Types of DBAs