DBA Interview Questions
- Do View contain Data?
- What is an object group?
- What are visual attributes?
- What is a database schema?
- What is an Integrity Constrains?
- What is the advantage of the library?
- When do you use data parameter type?
- What is WHEN-Database-record trigger?
- What is the use of ANALYZE command?
- What are the Characteristics of Data Files?
- What use of command line parameter cmd file?
- How can you tell if a database object is invalid?
- What are the trigger associated with image items?
- What are the steps involved in Instance Recovery?
- Explain materialized views and how they are used?
- What are the steps involved in Database Shutdown?
- How would you go about generating an EXPLAIN plan?
- Can Full Backup be performed when the database is open?
- What are the built-ins used for Creating and deleting groups?
- What are the different windows events activated at runtimes?
- Give the sequence of execution of the various report triggers?
- How can a square be drawn in the layout editor of the report writer?
- How can you determine if an index needs to be dropped and rebuilt?
- What happens if the constraint name is left out of a constraint clause?
- Give one method for transferring a table from one schema to another?
- What are the built-ins that are used for setting the LOV properties at runtime?
- Do you consider yourself a development DBA or a production DBA and why?
- What are some of the Oracle provided packages that DBAs should be aware of?
- What is the purpose of the IMPORT option IGNORE? What is its default setting?
- What happens if a table space clause is left off of a primary key constraint clause?
- What is the proper method for disabling and re-enabling a primary key constraint?
- What causes the “snapshot too old” error? How can this be prevented or mitigated?
- When should more than one DB writer process be used? How many should be used?
- What are the different approaches used by Optimizer in choosing an execution plan?
- What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
- You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
- You are using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
- How can you find out how many users are currently logged into the database? How can you find their operating system id?
- A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
- A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?