Computer Quiz : DBMS Set – 6

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. DBMS is an intermediate between the user and the _________
   A. Information
   B. Meta Data
   C. Database
   D. None of the Above
   
   Answer

   C. Database
   
   
2. What is the relationship between programs and data in the database approach?
   A. Data abstraction
   B. Data Model
   C. Meta Data
   D. None of the Above
   
   Answer

   A. Data abstraction
   
   
3. Which describes physical storage structure of the database?
   A. External or View level
   B. Conceptual Level
   C. Internal Level
   D. None of the Above
   
   Answer

   C. Internal Level
   
   
4. Which describes structure of the whole database for a community of users?
   A. External or View level
   B. Conceptual Level
   C. Internal Level
   D. None of the Above
   
   Answer

   B. Conceptual Level
   
   
5. A(n) _________ backup produces a complete copy of the entire database.
   A. Entire
   B. Full
   C. Half
   D. None of the Above
   
   Answer

   B. Full
   
   
6. A(n) ____ is a uniquely identifiable object that allows a given person to log on to the database.
   A. user
   B. client
   C. server
   D. None of the Above
   
   Answer

   A. user
   
   
7. ________ backups take place while the user is working on the database.
   A. Specialization
   B. Concurrent
   C. server
   D. None of the Above
   
   Answer

   B. Concurrent
   
   
8. A(n) ____ data dictionary is automatically updated by the DBMS with every database access.
   A. Active
   B. Passive
   C. In Active
   D. None of the Above
   
   Answer

   A. Active
   
   
9. In which architecture, multiple distributed database servers are used and the database schema is partitioned?
   A. Single database server architecture
   B. Replicated database server architecture
   C. Partitioned database server architecture
   D. Cloud-based database server architecture
   
   Answer

   C. Partitioned database server architecture
   
   
10. In which architecture, cloud computing service provider is used to provide some or all database services?
    A. Single database server architecture
    B. Replicated database server architecture
    C. Partitioned database server architecture
    D. Cloud-based database server architecture
    
    Answer

    D. Cloud-based database server architecture