Database Management Systems Quiz#2, MCQs

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

The Timer has started 10:00

  1. 1)

    Which of the following is NOT a feature of Indexed sequential files?

    • A) Records are stored in sequence and index is maintained.
    • B) Dense and nondense types of indexes are maintained.
    • C) Track overflows and file overflow areas can not be ensured.
    • D) Cylinder index increases the efficiency

  2. 2)

    Which of the following serves as a milestone or reference point in the log file?

    • A) Constraints
    • B) Relations
    • C) Check points
    • D) Transactions identities

  3. 3)

    Which of the following is not true regarding DB transactions?

    • A) A set of database operations that are processed partly
    • B) A database transaction is a logical unit of database operations
    • C) A database transaction must be atomic
    • D) A database transaction must contains the ACID property

  4. 4)

    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

  5. 5)

    Browser based forms are developed in the following tools EXCEPT

    • A) HTML
    • B) Scripting language
    • C) Front Page
    • D) Web-based Forms

  6. 6)

    Which of the following is not a form of optical disk?

    • A) CD ROM
    • B) WORM
    • C) Erasable Optical
    • D) EEPROM

  7. 7)

    Which of the following is the correct description of cache hit?

    • A) When data is found in the cache
    • B) When data is removed in the cache
    • C) The number of times the cache is accessed directly by the processor
    • D) When data is lost from the cache

  8. 8)

    In which of the following situations, Clustering is suitable:

    • A) Frequently updating
    • B) Relatively static
    • C) Relatively deletion
    • D) Relatively dynamic

  9. 9)

    Only one type of constraint can be enforced in any table by CREATE command

    • A) True
    • B) False

  10. 10)

    Which of the following is disadvantage of chaining technique to handle the collisions?

    • A) Unlimited Number of elements
    • B) Fast re-hashing
    • C) Overhead of multiple linked lists
    • D) Maximum number of elements must be known