Menu
Home / CSE / Database Systems :: Section 1

CSE :: Database Systems

Database Systems - Section 1
Database Systems - Section 2
Database Systems - Section 3
Database Systems - Section 4

  1. Which command is used to remove a table from the database in SQL?

    2. A.
    DELETE TABLE
    B.
    DROP TABLE
    C.
    ERASE TABLE
    D.
    UNATTACH TABLE
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

    3. A.
    Specialized file
    B.
    Log file
    C.
    Master file
    D.
    Update file
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. A file produced by a spreadsheet

    4. A.
    is generally stored on disk in an ASCII text format
    B.
    can be used as it by the DBMS
    C.
    can be used for graphic
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. A form defines

    5. A.
    where data is placed on the screen
    B.
    the width of each field
    C.
    both (a) and (b)
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which of the following is true of a network structure?

    6. A.
    It is a physical representation of the data
    B.
    It allows a many-to-many relationship
    C.
    It is conceptually simple
    D.
    It will be the dominant data base of the future
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. In SQL, GRANT command is used to

    7. A.
    allow user to access databases
    B.
    allow user to create databases
    C.
    grant system privileges, roles, and object privileges to uses and roles
    D.
    choose auditing for specific SQL commands
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. The highest level in the hierarchy of data organization is called

    8. A.
    data bank
    B.
    database
    C.
    data file
    D.
    data record
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. The logical data structure with a one-to-many relationship is a :

    9. A.
    network
    B.
    tree
    C.
    chain
    D.
    relational
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Updating a database means

    10. A.
    revising the file structure
    B.
    reorganizing the database
    C.
    modifying or adding record occurrences
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

    11. A.
    ALTER TRIGGERS
    B.
    ALTER TABLE
    C.
    MODIFY TRIGGERS IN TABLE
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers