Home / CSE / Database Systems :: Section 4

CSE :: Database Systems

  1. In SQL, which command(s) is(are) used to change a table's storage characteristics?

  2. A.
    ALTER TABLE
    B.
    MODIFY TABLE
    C.
    CHANGE TABLE
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  4. A.
    RENAME
    B.
    REVOKE
    C.
    GRANT
    D.
    UPDATE
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Subschema can be used to

  6. A.
    create very different, personalized views of the same data
    B.
    present information in different formats
    C.
    hide sensitive information by omitting fields from the sub¬schema's description
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Database management systems are intended to:

  8. A.
    eliminate data redundancy
    B.
    establish relationships among records in different files
    C.
    manage file access
    D.
    maintain data integrity
    E.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

  10. A.
    CREATE PACKAGE
    B.
    CREATE SCHEMA
    C.
    CREATE CLUSTER
    D.
    All of the above
    E.
    None of the above ;

    View Answer

    Workspace

    Discuss Discuss in Forum