Home 
Oracle Tutorials Oracle Administration DBA Interview Questions
Oracle Tutorials Oracle Administration DBA Interview Questions
| 
| 
- What is automatic shared memory management in Oracle 10g?
- What is automatic memory management in Oracle 11g?
- How will you perform a cold backup of the database?
- What is RMAN? Explain a type of backup that can be performed using RMAN?
- What is a database trigger?
- If you had to restrict access to a table, you want a user to only see specific columns in the table, what would you do?
- When will you use a recovery catalog database for RMAN?
- What is fine-grained auditing?
- If you had a problem in the database, to which you did not the solution. What are the steps you would follow to find a solution.
- Where are the diagnostic files of the database located, such as the Alert File. How often would you see the alert log file.
- If there were 3 or 4 very important tables in the database, what would be the method you would use to ensure that if you accidentally lose them, you still have a backup.
- How does Flashback Database differ from Point –In-Time Incomplete Recovery?
- If you were the DBA, what would you do if a user came to you and said that all of a sudden the report that normally took 10 minutes to run is now taking more than 30 minutes.
- What is the function of the ADDM (automatic database diagnostic monitor)? How will it help you as a DBA?
- If you were having a problem with the listener process, which log file would you look at to try and isolate the problem?
- What are the mandatory background processes in the Oracle database?
- What is the function of the SQL Result Cache, do you think it serves any useful purpose?
- Why is archiving important in the database? When will you choose not to enable archiving?
- What is Automatic Storage Management (ASM)? How do you think it will help you as a DBA, when managing database files.
- What is the Flash Recovery Area? Is it automatically enabled? How would you know whether or not it is enabled? If it not enabled, how will you enable it?
- Explain the process you would use to recover, if a file belonging to the SYSTEM tablespace is damaged.
- If you are faced this situation: A user began a transaction, and left his ongoing transaction active and went for lunch. Another user begins a transaction on the same row but is unable to proceed because the rows are locked by the first user, what would you do as a DBA to handle this situation?
- Have you worked on SQL Developer? What are some of the features that find useful in SQL Developer over SQL Plus?
- Have you administered your database using Enterprise Manager? Is it possible to perform all administrative tasks using Enterprise Manager.
- What do you call the constraint that defines relationships between tables?
