DBMS Questions – Set 20

Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the upcoming SBI Assistant Manager(System) and IBPS SO(IT Officer) examinations. We have also included some important questions that are repeatedly asked in previous exams.

1. Which of the following refers to the ability of several servers to connect to a single database?
   A. Table
   B. Object
   C. Index
   D. Cluster
   E. None of these
   
   Answer & Explanation

   D. Cluster
   Explanation:
   Cluster refers to the ability of several servers to connect to a single database
   
   
2. Which is the smallest unit of Input/Output used by a database?
   A. Extent
   B. Data File
   C. Segment
   D. Data Block
   E. None of the Above
   
   Answer & Explanation

   D. Data Block
   Explanation:
   A data block is the smallest unit of I/O used by a database
   
   
3. Which of the following is a set of memory structures that manage database files?
   A. Database Instance
   B. Data Migration
   C. Data Abstraction
   D. Data Isolation
   E. Database Schema
   
   Answer & Explanation

   A. Database Instance
   Explanation:
   Database Instance is a set of memory structures that manage database files
   
   
4. Which of the following represents the logical view of the entire database?
   A. Data Isolation
   B. Data Migration
   C. Database Abstraction
   D. Database Instance
   E. Database Schema
   
   Answer & Explanation

   E. Database Schema
   Explanation:
   Database Schema represents the logical view of the entire database.
   
   
5. _________ is the reduction of a particular body of data to a simplified representation of the whole.
   A. Data Isolation
   B. Data Migration
   C. Database Abstraction
   D. Database Instance
   E. Database Schema
   
   Answer & Explanation

   C. Database Abstraction
   Explanation:
   Data abstraction is the reduction of a particular body of data to a simplified representation of the whole
   
   
6. Which of the following is the process of transferring data between data storage systems, data formats or computer systems?
   A. Data Cleaning
   B. Data Migration
   C. Data Integration
   D. Data consolidations
   E. None of these
   
   Answer & Explanation

   B. Data Migration
   Explanation:
   Data Migration is the process of transferring data between data storage systems, data formats or computer systems.
   
   
7. In database systems, _____ is the ACID property which guarantees that transactions that have committed will survive permanently.
   A. Cleaning
   B. Migration
   C. Integration
   D. Consolidations
   E. Durability
   
   Answer & Explanation

   E. Durability
   Explanation:
   In database systems, Durability is the ACID property which guarantees that transactions that have committed will survive permanently
   
   
8. A _______ backup is the one where the database has been shut down
   A. Consistent
   B. Migration
   C. Abstraction
   D. Schema
   E. None of these
   
   Answer & Explanation

   A. Consistent
   Explanation:
   A Consistent backup is the one where the database has been shut down.
   
   
   
9. Which of the following is a variation of the star schema. ?
   A. Physical Schema
   B. Concept Schema
   C. Logical Schema
   D. Snowflaking Schema
   E. All of these
   
   Answer & Explanation

   D. Snowflaking Schema
   Explanation:
   A snowflake schema is a variation of the star schema.
   
   
10. The simplest form of a dimensional model, in which data is organized into facts and dimensions is known as?
    A. Physical Schema
    B. Concept Schema
    C. Logical Schema
    D. Star Schema
    E. Snowflaking Schema
    
    Answer & Explanation

    D. Star Schema
    Explanation:
    Star Schema: The simplest form of a dimensional model, in which data is organized into facts and dimensions.