Computer Quiz : DBMS Set – 5

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

1. A database component that stores the raw bits and bytes of data is called ________
   A. DBMS
   B. schema
   C. Physical Data Store
   D. None of the Above
   
   Answer

   C. Physical Data Store
   
   
2. A database component that contains descriptive information about the data stored in the physical data store is called _________
   A. Schema
   B. Attribute
   C. Table
   D. None of the Above
   
   Answer

   A. Schema
   
   
3. A consistent state among foreign key and primary key values is called _________
   A. Schema
   B. Attribute
   C. Referential Integrity
   D. None of the Above
   
   Answer

   C. Referential Integrity
   
   
4. A formal technique for evaluating and improving the quality of a relational database schema is known as ________
   A. Integration
   B. Normalization
   C. Dependency
   D. None of the Above
   
   Answer

   B. Normalization
   
   
5. One or more databases are hosted by a single DBMS running on a single server is called __________
   A. Single database server architecture
   B. Replicated database server architecture
   C. Partitioned database server architecture
   D. Cloud-based database server architecture
   
   Answer

   A. Single database server architecture
   
   
6. Complete database copies are hosted by cooperating DBMSs running on multiple servers is called __________
   A. Single database server architecture
   B. Replicated database server architecture
   C. Partitioned database server architecture
   D. Cloud-based database server architecture
   
   Answer

   B. Replicated database server architecture
   
   
7. Potential problems in the design of a relational database are known as ___________
   A. update anomalies
   B. ​relational anomalies
   C. ​modification anomalies
   D. ​select anomalies
   
   Answer

   A. update anomalies
   
   
8. The conversion of an unnormalized table to first normal form requires the removal of _________
   A. interrelation constraints
   B. repeating groups
   C. determinants
   D. None of the Above
   
   Answer

   B. repeating groups
   
   
9. _________ normal form has an additional condition that the only determinants the table contains are candidate keys.​
   A. ​Fourth
   B. ​Second
   C. Third
   D. First
   
   Answer

   C. Third
   
   
10. A set of requirements that is necessary to support the operations of a particular database user is known as a(n) _________
    A. user view
    B. user attribute
    C. user table
    D. user field
    
    Answer

    A. user view