Database Management Systems Quiz#3, MCQs

NOTE: Attempt all Questions to see the Result at the bottom of this page.

The Timer has started 10:00

  1. 1)

    An entity type is

    • A) defined when the database is actually constructed
    • B) a specific type such as an integer, text, date, logical etc
    • C) a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
    • D) defined by the database designer

  2. 2)

    An entity can be logically connected to another by defining a ____.

    • A) hyperlink
    • B) common attribute
    • C) primary key
    • D) superkey

  3. 3)

    You can’t modify more than one table at a time through a view.

    • A) True
    • B) False

  4. 4)

    Which of the following is one of the purposes of using DML commands?

    • A) Creating databases
    • B) Destroying databases
    • C) Inserting data in tables
    • D) Non of the above

  5. 5)

    Which of the following statements is true about the views?

    • A) view is always a complete set of all the tables in a database
    • B) View can not be used for retrieving data
    • C) The results of using a view are not permanently stored in the database.
    • D) Rows can not be updated or deleted in the view

  6. 6)

    What is the alternate name of Data Dictionary?

    • A) Index
    • B) Metadata
    • C) Data
    • D) System Catalog

  7. 7)

    IN function helps reduce the need to use multiple AND conditions.

    • A) True
    • B) False

  8. 8)

    Which of the following are the general activities, which are performed during the development of application programs?

    • A) Data input programs
    • B) Editing
    • C) Display
    • D) All of given

  9. 9)

    Which of the following is not true about De-normalization?

    • A) It is the process of attempting to optimize the performance of a database
    • B) De-normalization is a technique to move from lower to higher normal forms of database modeling
    • C) It enhances the performance of DB
    • D) In de-normalization it is required to add redundant data.

  10. 10)

    Which of the following types of partitioning reduces the chances of unbalanced partitions?

    • A) Vertical
    • B) List
    • C) Hash
    • D) Range