Menu
Home / CSE / Database Systems :: Section 4

CSE :: Database Systems

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

  1. In SQL, the command(s) is(are) used to create an index for a table or cluster

    2. A.
    CREATE INDEX
    B.
    MODIFY INDEX
    C.
    SET INDEX TO FILE
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

    3. A.
    Data storage system
    B.
    Database management system (DBMS)
    C.
    Batch processing system
    D.
    Data communication package
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. A _____ DBMS distributes data processing tasks between the workstation and a network server.

    4. A.
    Network
    B.
    Relational
    C.
    Client Server
    D.
    Hierarchical
    E.
    None of the above.

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Information can be transferred between the DBMS and a

    5. A.
    spreadsheet program
    B.
    word processor program
    C.
    graphics program
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Data integrity control

    6. A.
    is used to set upper and lower limits on numeric data
    B.
    requires the use of passwords to prohibit unauthorized access to the file
    C.
    has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. In order to use a DBMS, it is important to understand

    7. A.
    the physical schema
    B.
    all sub-schemas that the system supports
    C.
    one subschema
    D.
    both (a) and (b)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. In SQL, which command(s) is(are) used to recompile a stored function?

    8. A.
    SET FUNCTION
    B.
    SET STORED FUNCTION
    C.
    ALTER FUNCTION
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Report generators are used to

    9. A.
    store data input by a user
    B.
    retrieve information from files
    C.
    answer queries
    D.
    both (b) and (c)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Administrate supervision of database activities is the responsibility of the

    10. A.
    Database administrator
    B.
    DP Manager
    C.
    DB Manager
    D.
    DP administration
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. Goals for the design of the logical schema include

    11. A.
    avoiding data inconsistency
    B.
    being able to construct queries easily
    C.
    being able to access data efficiently
    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