Computer Quiz : DBMS Set – 4

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. The ________ manages interaction between the end user and the database.
   A. DP
   B. DBMS
   C. DM query engine
   D. None of the Above
   
   Answer

   B. DBMS
   
   
2. A database that supports data distributed across several different sites is called a(n) ________ database.
   A. desktop
   B. distributed
   C. workgroup
   D. enterprise
   
   Answer

   B. distributed
   
   
3. Data ________is defined as “the condition in which all of the data in the database are consistent with the real-world events and conditions.”
   A. verification
   B. redundancy
   C. inconsistency
   D. integrity
   
   Answer

   D. integrity
   
   
4. _________ are the instructions and rules that govern the design and use of the database system.
   A. Procedures
   B. Hardware
   C. Software
   D. Data
   
   Answer

   A. Procedures
   
   
5. Activities that make the database perform more efficiently in terms of storage and access speed are known as performance _________
   A. development
   B. upgrades
   C. enhancements
   D. tuning
   
   Answer

   D. tuning
   
   
6. __________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
   A. DBMS
   B. Access Query Language
   C. 4GL
   D. Structured Query Language
   
   Answer

   D. Structured Query Language
   
   
7. Where does the DBMS store the definitions of data elements and their relationships?
   A. data map
   B. data file
   C. index
   D. data dictionary
   
   Answer

   D. data dictionary
   
   
8. The term ____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
   A. people
   B. DBMS
   C. database system
   D. hardware
   
   Answer

   C. database system
   
   
9. Data ____ exists when the same data are stored unnecessarily at different places.
   A. fragmentation
   B. dependency
   C. redundancy
   D. inconsistency
   
   Answer

   C. redundancy
   
   
10. Data ____ exists when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.
    A. mining
    B. integrity
    C. independence
    D. inconsistency
    
    Answer

    C. independence