Database Management System

10 Questions | Attempts: 518
Share

SettingsSettingsSettings
Database Management System Quizzes & Trivia

Questions and Answers
  • 1. 

    In SQL, which of the following is not a data definition language commands?

    • A.

      RENAME

    • B.

      REVOKE

    • C.

      GRANT

    • D.

      UPDATE

    Correct Answer
    D. UPDATE
  • 2. 

    Database management systems are intended to:

    • A.

      Eliminate data redundancy

    • B.

      Establish relationships among records in different files

    • C.

      Manage file access

    • D.

      All of the above

    Correct Answer
    D. All of the above
  • 3. 

    In SQL, which command is used to select only one copy of each set                                                                                                              of duplicable rows

    • A.

      SELECT DISTINCT

    • B.

      SELECT UNIQUE

    • C.

      SELECT DIFFERENT

    • D.

      All of the above

    Correct Answer
    A. SELECT DISTINCT
  • 4. 

    The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

    • A.

      Tree file

    • B.

      An indexed file

    • C.

      A hashed file

    • D.

      None of the above

    Correct Answer
    C. A hashed file
  • 5. 

    Which command is used to select distinct subject (SUB) from the table (BOOK)?

    • A.

      SELECT ALL FROM BOOK

    • B.

      SELECT DISTINCT SUB FROM BOOK

    • C.

      SELECT SUB FROM BOOK

    • D.

      All of the above

    Correct Answer
    B. SELECT DISTINCT SUB FROM BOOK
  • 6. 

    In SQL, the CREATE TABLESPACE is used

    • A.

      To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

    • B.

      To create a database trigger

    • C.

      To add/rename data files, to change storage

    • D.

      All of the above

    Correct Answer
    A. To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
  • 7. 

    In SQL, which command is used to remove a stored function from the database?

    • A.

      REMOVE FUNCTION

    • B.

      DELETE FUNCTION

    • C.

      DROP FUNCTION

    • D.

      ERASE FUNCTION

    Correct Answer
    C. DROP FUNCTION
  • 8. 

    ODBC stands for

    • A.

      Object Database Connectivity.

    • B.

      Oral Database Connectivity.

    • C.

      Oracle Database Connectivity

    • D.

      Open Database Connectivity.

    Correct Answer
    D. Open Database Connectivity.
  • 9. 

    The statement in SQL which allows to change the definition of a table is

    • A.

      Alter.

    • B.

      Update

    • C.

      Create

    • D.

      Select.

    Correct Answer
    A. Alter.
  • 10. 

    Which of the following is a valid SQL type?

    • A.

      CHARACTER

    • B.

      NUMERIC

    • C.

      FLOAT

    • D.

      All of the above

    Correct Answer
    D. All of the above

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 19, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 26, 2012
    Quiz Created by
    Ashishdoorwar96
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.