Online Tests 2017

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
  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
  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
  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
  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
  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
  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
  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
  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
  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