Menu
Home / CSE / Database Systems :: Section 3

CSE :: Database Systems

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

  1. Related fields in a data base are grouped to form

    2. A.
    data file
    B.
    data record
    C.
    menu
    D.
    bank
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

    3. A.
    One-to-one relationship
    B.
    One-to-many relationship
    C.
    Many-to-one relationship
    D.
    Many-to-many relationship
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. In SQL, the _____ command is used to recompile a view

    4. A.
    COMPILE VIEW
    B.
    DEFINE VIEW
    C.
    CREATE VIEW
    D.
    ALTER VIEW
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. A list in alphabetical order

    5. A.
    is in descending order
    B.
    is in ascending order
    C.
    is the result of a sort operation
    D.
    both (b) and (c)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. If a piece of data is stored in two places in the database, then

    6. A.
    storage space is wasted
    B.
    changing the data is one spot will cause data inconsistency
    C.
    it can be more easily accessed
    D.
    both (a) and (b)
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. A data dictionary is a special file that contains

    7. A.
    the names of all fields in all files
    B.
    the data types of all fields in all files
    C.
    the widths of all fields in all files
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. A file that is organized in uniform format is formally referred to as a _____ or a database file.

    8. A.
    Document
    B.
    Database
    C.
    Record
    D.
    Structured data file
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. A form can be used to

    9. A.
    modify records
    B.
    delete records
    C.
    format printed output
    D.
    All of the above
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Which language has recently become the de-facto standard for interfacing application programs with relational database system?

    10. A.
    Oracle
    B.
    SQL
    C.
    dBASE
    D.
    4GL
    E.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. In SQL, the CREATE TABLE is used

    11. A.
    to create a table, defining its columns, integrity constrains, and storage allocation
    B.
    to add a column/integrity constraint to a table
    C.
    to redefine a column
    D.
    to change a table's storage characteristics
    E.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers