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 are Subqueries or Nested Queries in case of DBMS? | 
|
|
|
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? |
|
|
|
Explain the use of setting GLOBAL_NAMES equal to TRUE. |
|
|
|
What are some of the Oracle provided packages that DBAs should be aware of? | 
|
|
|
What are Stand-Alone Procedures in case of DBMS? |
|
|
|
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause? |
|
|
|
How can you determine if an index needs to be dropped and rebuilt? |
|
|
|
What do you mean by Atomicity and Aggregation in case of DBMS? |
|
|
|
What does coalescing a tablespace do? |
|
|
|
Explain the difference between $ORACLE_HOME and $ORACLE_BASE. |
|
|
|
What are the different Parameter types in case of RDBMS? |
|
|
|
What is BCNF (Boyce-Codd Normal Form) in case of DBMS? |
|
|
|
List out some major environment variable used in installation ? |
|
|
|
Where is the external query executed at the client or the server? |
|
|
|
What is Distributed database? |
|
|
|
What are the Large object types sported by Oracle? |
|
|
|
Describe the three levels of Data Abstraction? |
|
|
|
What is an Index? How it is implemented in Oracle Database? |
|
|
|
What is Record-at-a-time in case of DBMS? |
|
India News Network |
