Welcome,  Guest  |  Sign In |  New User? 

List of DATABASE Administrator (DBA) Interview Questions & Answers

Page 1 of 4: 1 2 3 4 Next>>

What is the main roll of database administrator         [ 78 ]



Choose your rating:    Post Ans.    View More Ans.

How would you determine who has added a row to a table?         [ 40 ]

Turn on fine grain auditing for the table.

Choose your rating:    Post Ans.    View More Ans.

What does coalescing a tablespace do?         [ 46 ]

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Choose your rating:    Post Ans.    View More Ans.

What are the different Parameter types?         [ 47 ]

Text ParametersData Parameters



Choose your rating:    Post Ans.    View More Ans.

How would you force a log switch?         [ 35 ]

ALTER SYSTEM SWITCH LOGFILE;

Choose your rating:    Post Ans.    View More Ans.

Describe what redo logs are.         [ 39 ]

Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.



Choose your rating:    Post Ans.    View More Ans.

What is the effect of setting the value ALL_ROWS for OPTIMIZER_GOAL parameter of the ALTER SESSION command?         [ 47 ]

What are the factors that affect OPTIMIZER in choosing an Optimization approach? - Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

Choose your rating:    Post Ans.    View More Ans.

What is difference between UNIQUE constraint and PRIMARY KEY constraint?         [ 41 ]

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can’t contain Nulls.

Choose your rating:    Post Ans.    View More Ans.

What does a Control file Contain?         [ 42 ]

A Control file records the physical structure of the database. It contains the following information. Database Name Names and locations of a database’s files and redolog files. Time stamp of database creation.

Choose your rating:    Post Ans.    View More Ans.

Where in the Oracle directory tree structure are audit traces placed?         [ 34 ]

In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer

Choose your rating:    Post Ans.    View More Ans.

Page 1 of 4: 1 2 3 4 Next>>



© 2007 -2009 a2z Interview Questions    Valid XHTML | CSS        Home | Site Map | RSS Feed