Q.7: Which of the following is not considered as a basic element of an enterprise class database system? Options – User, Databse apps, DBMS, COBOL Programs.
The answer is COBOL programs.
The answer is COBOL programs.
Q.8: How can one recover the database via reprocessing?
Reprocessing is not very feasible. If we process the transaction, it is possible that the database is safe and accessible and so reprocessing can be done. It is not preferred by many for a simple reason that it is a costly process and it requires a lot of re-work, again and again. With many transactions calling for a rollback, it becomes tedious and involves loads of re-work.
Reprocessing is not very feasible. If we process the transaction, it is possible that the database is safe and accessible and so reprocessing can be done. It is not preferred by many for a simple reason that it is a costly process and it requires a lot of re-work, again and again. With many transactions calling for a rollback, it becomes tedious and involves loads of re-work.
Q.9: What is normalization?
It is the way of organizing data in a database by removing unneeded and not consistent data. The database normalization has some rules to be followed while creating databases-
First Normal form is to – remove duplicate column first and identify each set of resembling and related data with a primary key.
Second Normal from is to – create a relationship between master and master detail tablets by using a foreign key.
Third Normal form is to – remove the fields that are not dependent on the primary key. They are independent.
Q.10: What is de-normalization?
De-normalization is a process of optimizing the performance of a database. It is a process of combining and organizing data in a single table. It is then used to access specific data needs according to the users.
Q.11: What is the meaning of flat file database?
It is a type of database where in there are no programs or languages which can be accessed by a user. There are no cross file capabilities but it is still user friendly and provides pretty good user friendly management.
For more Database Interview Questions and answers DOWNLOAD PDF from here.
0 comments:
Post a Comment