Below we have listed all the DBA Interview Questions and answers. Feel free to comment on any DBA Interview Questions or answer by the comment feature available on the page.
To buy an eBook containing 30,000 Interview Questions, with Answers, Click Here.
View All DBA Interview Questions & Answers - Exam Mode /
Learning Mode
DBA is also an abbreviation for doing business as - a term sometimes used in business and legal writing. dBA is an abbreviation for A-weighted decibels. A database administrator, frequently known just by the acronym DBA, is a role usually within the Information Technology department, charged with the creation, maintenance, backups, querying, tuning, user rights assignment and security of an organization's databases.
| Highly Recommended, Hand Picked DBA Books | |||
|
|
|||
 
|
 
|
 
|
 
|
|
|
|||
Previous 1 2 3 4 5 6 7 8 9 10 Next
Sort By : Latest First | Oldest First | By Rating |
What is a Sequence? | 
|
|
|
Do you consider yourself a development DBA or a production DBA and why? |
|
|
|
What are the basic element of Base configuration of an oracle Database? |
|
|
|
What is Storage Manager in case of DBMS? |
|
|
|
What happens if the constraint name is left out of a constraint clause? |
|
|
|
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace? |
|
|
|
List out some major environment variable used in installation ? |
|
|
|
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause? | 
|
|
|
Name the architectural components of RMAN ? |
|
|
|
What are the components of SGA? |
|
|
|
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not? |
|
|
|
What causes the "snapshot too old" error? How can this be prevented or mitigated? |
|
|
|
What is Distributed database? | 
|
|
|
What are the built-ins that are used for setting the LOV properties at runtime? |
|
|
|
What is Two-Phase Commit? |
|
|
|
What is a trace file and how is it created? |
|
|
|
How can values be passed between precompiler exits & Oracle call interface? |
|
|
|
What are the different modes of mounting a Database with the Parallel Server? |
|
|
|
What are the Referential actions supported by FOREIGN KEY integrity constraint? |
|
|
|
What is an Index? How it is implemented in Oracle Database? |
|
India News Network |
