Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

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

  2. A.
    SELECT DISTINCT
    B.
    SELECT UNIQUE
    C.
    SELECT DIFFERENT
    D.
    All of the above
    E.
    None of the above

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

  4. A.
    a tree file
    B.
    an indexed file
    C.
    a hashed file
    D.
    a sequential file
    E.
    None of the above

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

  6. A.
    SELECT ALL FROM BOOK
    B.
    SELECT DISTINCT SUB FROM BOOK
    C.
    SELECT SUB FROM BOOK
    D.
    All of the above
    E.
    None of the above

  7. The master list of an indexed file

  8. A.
    is sorted in ascending order
    B.
    contains only a list of keys and record numbers
    C.
    has a number assigned to each record
    D.
    both (b) and (c)
    E.
    None of the above

  9. Which of the following is not the responsibility of the utilities component of DBMS software?

  10. A.
    creating the physical and logical designs
    B.
    removing flagged records for deletion
    C.
    creating and maintaining the data dictionary
    D.
    monitoring performance
    E.
    None of the above

  11. In SQL, the CREATE TABLESPACE is used

  12. 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
    E.
    None of the above

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

  14. A.
    REMOVE FUNCTION
    B.
    DELETE FUNCTION
    C.
    DROP FUNCTION
    D.
    ERASE FUNCTION
    E.
    None of the above

  15. The database administration function includes

  16. A.
    application programming
    B.
    computer operations management
    C.
    database access planning
    D.
    All of the above
    E.
    None of the above

  17. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

  18. A.
    tables
    B.
    relations
    C.
    tuple
    D.
    both (a) and (b)
    E.
    None of the above

  19. A command that lets you change one or more fields in a record is

  20. A.
    Insert
    B.
    Modify
    C.
    Look-up
    D.
    All of the above
    E.
    None of the above