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 E-R model in case of DBMS? | 
|
|
|
Use the add_group_column function to add a column to record group that was created at a design time? |
|
|
|
Difference between SGA and PGA ? | 
|
|
|
What does coalescing a tablespace do? |
|
|
|
What are the responsibilities of a Database Administrator? |
|
|
|
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace? |
|
|
|
What are advantages of using SPFILE over PFILE ? |
|
|
|
What are the built-ins that are used for setting the LOV properties at runtime? |
|
|
|
What is lexical reference? |
|
|
|
What is the proper method for disabling and re-enabling a primary key constraint? |
|
|
|
What is the effect of setting the value ?ALL_ROWS? for OPTIMIZER_GOAL parameter of the ALTER SESSION command? |
|
|
|
What are the system resources that can be controlled through Profile? |
|
|
|
What is database Auditing? |
|
|
|
What is a View? How it is related to Data Independence? |
|
|
|
What are Cursors give different types of Cursors in case of DBMS? |
|
|
|
If you have an example table, what is the best way to get sizing data for the production table implementation? |
|
|
|
How is the data structure of System R different from the Relational Structure? |
|
|
|
What is difference between UNIQUE constraint and PRIMARY KEY constraint? |
|
|
|
What is Object Oriented model? |
|
|
|
How can you enable automatic archiving? |
|
India News Network |
