Home / CSE / Database Systems :: Section 2

CSE :: Database Systems

  1. In SQL, which command(s) is(are) used to create a synonym for a schema object?

  2. A.
    CREATE SCHEMA
    B.
    CREATE SYNONYM
    C.
    CREATE SAME
    D.
    All of the above
    E.
    None of the above

  3. If you want your database to include methods, you should use a _____ database.

  4. A.
    Network
    B.
    Distributed
    C.
    Hierarchical
    D.
    Object-Oriented
    E.
    None of the above

  5. In SQL, which of the following is not a data Manipulation Language Commands?

  6. A.
    DELETE
    B.
    SELECT
    C.
    UPDATE
    D.
    CREATE
    E.
    None of the above

  7. Which of the following is not characteristic of a relational database model?

  8. A.
    tables
    B.
    treelike structure
    C.
    complex logical relationships
    D.
    records
    E.
    None of the above

  9. A computer file contains several records. What does each record contain?

  10. A.
    Bytes
    B.
    Words
    C.
    Fields
    D.
    Database
    E.
    None of the above

  11. In SQL, the CREATE VIEW command is used

  12. A.
    to recompile view
    B.
    to define a view of one or more tables or views
    C.
    to recompile a table
    D.
    to create a trigger
    E.
    None of the above

  13. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

  14. A.
    File structure
    B.
    Records
    C.
    Fields
    D.
    Database
    E.
    None of the above

  15. In the DBM approach, application programs perform the

  16. A.
    storage function
    B.
    processing functions
    C.
    access control
    D.
    All of the above
    E.
    None of the above

  17. In SQL, which command is used to create a database user?

  18. A.
    ADD USER TO DATABASE
    B.
    MK USER
    C.
    CREATE USER
    D.
    All of the above
    E.
    None of the above

  19. When performing a look-up operation using a form

  20. A.
    you enter the search value into the form
    B.
    you look at each form sequentially until you see the one you want
    C.
    you type the key in an entry line, and the correct form is displayed
    D.
    All of the above
    E.
    None of the above