When did you know you wanted to be a Database Administrator?
When I started my career with cgi.
What information is stored in the control file?
Database information, location of data files . Redo log files.
The information of data files and redolog files.
What is a checkpoint?
What is normalization? Explain different levels of normalization?
Because there is no redundant, neglected data and normalized
tables produce rapid, efficient joins and 5 different normalizations.
Database normalization is the process of organizing the columns and tables of a relational database to minimize data redundancy. Normalization involves decomposing a table into less redundant tables without losing information; defining foreign keys in the old table referencing the primary keys of the new ones. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys.
Are you a development DBA or a production DBA?
The role would probably be a mix of both.
What is the job of SMON, PMON processes?
PMON and SMON are two required background processes. PMON is the Process Monitor which is responsible for recovering processes when the user process fails. PMON does the process cleanup. SMON is the System Monitor which is responsible for recovering the system after a failure.
SMON - Performs critical tasks such as instance recovery and dead transaction recovery, and maintenance tasks such as temporary space reclamation, data dictionary cleanup, and undo tablespace management.
PMON - Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally.
Explain the difference between explicit and implicit lock?
Explicit Lock: - Lock is explicitly requested for a record or table.
Implicit Lock: - Lock is implied but is not acquired.
Explicit Lock is explicitly requested for a record or table.
Implicit Lock is implied but is not acquired.
What excites you about this position?
The prospects of learning and developing a new understanding regarding scripts. Scripts are straightforward. You can tell a computer to do something and it will respond. You can see the progress. That is something I like.
Focus on data flow. Data integration, data quality and data accuracy.
What about data fascinates you?
Tell me about your education relating to database management?
What are different modes of mounting a database with a parallel server?
How do you implement one to one, one to many, and many to many relationships while designing tables?
Tell me your most successful program, project, or whatever you worked on that you were most proud of at your last job?
Why are you here?
Explain the difference between a database manager and a data manager?
View All 22 Database Administrator Questions and Answers
Sign up to access our library of 50,000+ Q&As, plus coaches for one-on-one support, so you can interview more confidently.
Our interview questions and answers are created by experienced recruiters and interviewers. These questions and answers do not represent any organization, school, or company on our site. Interview questions and answer examples and any other content may be used else where on the site. We do not claim our questions will be asked in any interview you may have. Our goal is to create interview questions and answers that will best prepare you for your interview, and that means we do not want you to memorize our answers. You must create your own answers, and be prepared for any interview question in any interview.