As far as the database administration is concerned, this is definitely one of the very important positions in any company. Some of the responsibility which you will possess as a DBA is data modeling, design, data warehousing and business intelligence software. You will also have to build the database schemes, tables, permissions and procedures. The data sharing as well as the data participation is also to be handled.
Some of the interview questions which can be asked from you are as follows:
1. What is data redundancy?
Redundancy is done when same data is stored in the database more than once. For example there can be two children with same name in a class. However they need to be differentiated. You can do that with the help of ID. However two same rows are very harmful for the database. It is called database redundancy.
2. Is data redundancy helpful or harmful for the database?
It is quite risky for the database. In fact it is the first thing which is being reduced during normalization.
3. Name two kinds of keys?
Primary key and unique key are two examples of key.
4. What is first normal form?
When the database is free from the data redundancy then the database is said to be in first normal form.
5. Name one other normal form other than the 3 normal forms.
Boyce Codd normal form is that normal form.
6. What do you know about the Boyce Codd Normal Form?
It is the key heavy derivation of the third normal form. A relation is in Boyce Codd normal form if and only if all the determinants are a candidate key.
7. What do you know about the third normal form?
A relation is in third normal form if it is in second normal form and every non key attribute is Non-transitively dependent upon the primary key.
8. Define database normalization.
Data base normalization is a series of step with the help of which efficient access and storage of database is made possible. There are four types of normal form.
9. What is SQL stands for?
SQL stands for structured query language.
10. What does DDL and DML stands for?
DDL stands for Data definition language as well as DML stands for data manipulation language.
11. Name two or three database software.
Some of the database software’s are Oracle 9i, oracle 10g, SQL server and so on.
These are some of the questions which can be asked from you when you will give the interview of the database administrator. You will definitely have to prepare hard and keep your mind cool because lots of tricks are involved in this field.
