Computer Quiz : DBMS Set – 8

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. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
   A. Data modeling
   B. Metadata
   C. Database design
   D. All of the Above
   
   Answer

   C. Database design
   
   
2. SQL stands for ________
   A. Structured Question Language
   B. Sequential Question Language
   C. Structured Query Language
   D. Sequential Query Language
   
   Answer

   C. Structured Query Language
   
   
3. A DBMS that combines a DBMS and an application generator is ________
   A. DB2
   B. SQL Server
   C. Microsoft Access
   D. Oracle
   
   Answer

   C. Microsoft Access
   
   
4. The following are components of a database except__________
   A. reports
   B. index
   C. metadata
   D. user data
   
   Answer

   A. reports
   
   
5. DBMS acts as an interface between what two components of an enterprise-class database system?
   A. The user and the database application
   B. Database application and the database
   C. Database application and SQL
   D. Data and the database
   
   Answer

   B. Database application and the database
   
   
6. The following are functions of a DBMS except ________ 
   A. creating databases
   B. creating and processing forms
   C. administrating databases
   D. processing data
   
   Answer

   B. creating and processing forms
   
   
7. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
   A. Rollback
   B. Reprocess transactions
   C. Switch to duplicate database
   D. Rollforward
   
   Answer

   A. Rollback
   
   
8. The tuples of the relations can be of ________ order.
   A. Any
   B. Same
   C. Sorted
   D. Constant
   
   Answer

   A. Any
   
   
9. An application where only one user accesses the database at a given time is an example of a(n) ________ 
   A. single-user database application
   B. multiuser database application
   C. e-commerce database application
   D. data mining database application
   
   Answer

   A. single-user database application
   
   
10. A ________ in a table represents a relationship among a set of values.
    A. Column
    B. Key
    C. Row
    D. Entry
    
    Answer

    C. Row