Computer Quiz : DBMS Set – 1

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 _________
   A. Collection of Data
   B. Set of programs to access data
   C. Set of programs to update data
   D. All of the Above
   
   Answer

   D. All of the Above
   
   
2. The Database stores information in _______
   A. Blocks
   B. Rows and Columns
   C. Tracks and Sectors
   D. None of the Above
   
   Answer

   B. Rows and Columns
   
   
3. ____________ is a structured database in which data is stored in the form of tables
   A. Network Database
   B. Hierarchical Database
   C. Relational Database
   D. None of the Above
   
   Answer

   C. Relational Database
   
   
4. ________ is the logical structure of the database.
   A. Schema
   B. Instances
   C. Key
   D. None of the Above
   
   Answer

   A. Schema
   
   
5. Which of the following places the common data elements in order from smallest to largest?
   A. character, file, record, field, database
   B. character, record, field, database, file
   C. character, field, record, file, database
   D. Bit, byte, character, record, field, file, database
   
   Answer

   C. character, field, record, file, database
   
   
6. A program that generally has more user- friendly interface than a DBMS is called a ________
   A. Front end
   B. Repository
   C. Back end
   D. None of the Above
   
   Answer

   A. Front end
   
   
7. ____________ means that the data contained in a database is accurate and reliable.
   A. Data redundancy
   B. Data integrity
   C. Data reliability
   D. Data consistency
   
   Answer

   B. Data integrity
   
   
8. Dr. E.F. Codd represented _____ rules that a database must obey if it has to be considered truly relational
   A. 10
   B. 8
   C. 12
   D. 5
   
   Answer

   C. 12
   
   
9. ____________ is a database in which data is organized in the form of trees with nodes.
   A. Network Database
   B. Hierarchical Database
   C. Relational Database
   D. None of the Above
   
   Answer

   B. Hierarchical Database
   
   
10. The smallest unit of information about a record in a database is called a _______
    A. Field
    B. Query
    C. Cell
    D. None of the Above
    
    Answer

    A. Field