Current Affairs PDF

DBMS Questions – Set 20

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    D. Star Schema
    Explanation:
    Star Schema: The simplest form of a dimensional model, in which data is organized into facts and dimensions.