Database Management Systems Quiz#4, MCQs

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

The Timer has started 10:00

  1. 1)

    While recovering data, which of the following files does a recovery manager examines at first?

    • A) A system file
    • B) Log file
    • C) Data dictionary
    • D) Metadata

  2. 2)

    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

  3. 3)

    ALTER TABLE exams
    RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID.
    Syntax of ALTER TABLE is NOT correct.

    • A) True
    • B) False

  4. 4)

    Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

    • A) DELETE FROM person WHERE employee_id = ‘12345’
    • B) DELETE WHERE person FROM employee_id = 12345
    • C) DROP FROM person WHERE employee_id = 12345
    • D) DELETE WHERE person WHERE employee_id = 12345

  5. 5)

    Which of the following is NOT a component of a DFD? Select correct option:

    • A) Dataflow
    • B) Datastore
    • C) External entities
    • D) Relationship between external entities

  6. 6)

    Laser records data by burning microscopic holes in the surface of the disk with a

    • A) Hard disk
    • B) RAM
    • C) Optical disk
    • D) Floppy disk

  7. 7)

    Which of the following concepts is applicable with respect to 3NF?

    • A) Full functional dependency
    • B) Any kind of dependency
    • C) Transitive dependency
    • D) Partial functional dependency

  8. 8)

    Which of the following is NOT a feature of a good interface?

    • A) Consistency
    • B) Process based
    • C) Data structure based
    • D) User friendly

  9. 9)

    Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

    • A) Physical data independence.
    • B) Concurrency control
    • C) Logical data independence.
    • D) Functional dependency

  10. 10)

    GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;
    What does this SQL statement do?

    • A) Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.

    • B) Grant permission to Hiruni in order to grant, select and update permission to Amali.
    • C) Grant permission to Amali & Hiruni to update designation of employees in the Employee table
    • D) Grant permission to Amali and Hiruni to update all data except designation in Employee table