MCQ of DBMS fundamental question

MCQ Data Base Management System on Basic  Fundamental

Q1.A Specific example where physical data independence would not hold is

1. When data file is changed from unordered file to sorted file 
2. When additional access  structure (Example an index ) is created for relation
3. When DBA decides to store the data in B+ tree
4. When the user writes an application program to join tables 

Q2.Integrity means________

1. Protecting the data against unauthorized users
2. Protecting data against authorized users
3. Making sure users are allowed to do the thing they are trying to do
4. None of These

Q3.Controlling redundancy in database management system help to 

1. Avoid duplication of effort
2. Avoid unnecessary wastage of storage space 
3. Avoid Inconsistence among data 
4. All of the above

Q4. Which of the following function not performed by DBA?

1. Planning ,designing ,and implementation of database system
2. Allocation of storage locations and data structures
3. Establishing standards and procedures system
4. Communicating with data base users

Q5.Which of the following is not an advantages of database approach ?

1. Elimination of the data redundancy 
2. Ability to associate related data 
3. increased security 
4. All of the above

Q.6 A data Dictionary doesn't provides information about 

1. Where data is located 
2. The size of the disk storage
3. Who owns or responsible for the data 
4. How data is stored 

Q7.The data base administrator is ,in effects ,the coordinator between the _____and the ____

1. DBMS ; database
2. Application program ; Database
3. Database ;Users
4. Application programs ;Users

Q.8 Which of the following is not usually part of the responsibilities of a DBA?

1. Approving Structure changes to the database
2. Designing data  entry screens 
3. Ensuring that an adequate backup regime is in place
4. Issuing Accounts to users and monitoring the performance of the system

Q9. Network Models are Complicated by

1. Physical keys ,but the relation model is faster because it uses logical keys.
2. Logical keys ,