Menu
Home / CSE / Database System 2 - CS :: The Relational Model and Normalization

CSE :: Database System 2 - CS

Database System 2 - CS - Advanced SQL
Database System 2 - CS - SQL Server 2000
Database System 2 - CS - Data Warehousing
Database System 2 - CS - XML and ADO.NET
Database System 2 - CS - Database Redesign
Database System 2 - CS - Introduction to SQL
Database System 2 - CS - Distributed Databases
Database System 2 - CS - Client Server Database
Database System 2 - CS - Data Modeling with ER
Database System 2 - CS - Logical Database Design
Database System 2 - CS - Introduction to Database
Database System 2 - CS - Object Oriented Database
Database System 2 - CS - Physical Database Design
Database System 2 - CS - The Database Environment
Database System 2 - CS - ODBC, OLE DB, ADO, and ASP
Database System 2 - CS - ER Model and Business Rules
Database System 2 - CS - Database Processing for BIS
Database System 2 - CS - Managing Multiuser Databases
Database System 2 - CS - Object Oriented Data Modeling
Database System 2 - CS - Managing Databases with Oracle
Database System 2 - CS - SQL for Database Construction
Database System 2 - CS - Data and Database Administration
Database System 2 - CS - Data Models into Database Designs
Database System 2 - CS - Modeling Data in the Organization
Database System 2 - CS - The Database Development Process
Database System 2 - CS - The Internet Database Environment
Database System 2 - CS - JDBC, Java Server Pages, and MySQL
Database System 2 - CS - Database Design Using Normalization
Database System 2 - CS - The Relational Model and Normalization
  1. Table is synonymous with the term:

    2. A.

     record.
    B.

     relation.
    C.

     column.
    D.

     field.

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following is not a restriction for a table to be a relation?

    3. A.

     The cells of the table must contain a single value.
    B.

     All of the entries in any column must be of the same kind.
    C.

     The columns must be ordered.
    D.

     No two rows in a table may be identical.

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. For some relations, changing the data can have undesirable consequences called:

    4. A.

     referential integrity constraints.
    B.

     modification anomalies.
    C.

     normal forms.
    D.

     transitive dependencies.

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. A key:

    5. A.

     must always be composed of two or more columns.
    B.

     can only be one column.
    C.

     identifies a row.
    D.

     identifies a column.

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. An attribute is a(n):

    6. A.

     column of a table.
    B.

     two dimensional table.
    C.

     row of a table.
    D.

     key of a table.

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. A relation in this form is free of all modification anomalies.

    7. A.

     First normal form
    B.

     Second normal form
    C.

     Third normal form
    D.

     Domain/key normal form

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. If attributes A and B determine attribute C, then it is also true that:

    8. A.

     A → C.
    B.

     B → C.
    C.

     (A,B) is a composite determinant.
    D.

     C is a determinant.

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. A tuple is a(n):

    9. A.

     column of a table.
    B.

     two dimensional table.
    C.

     row of a table.
    D.

     key of a table.

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. If attribute A determines both attributes B and C, then it is also true that:

    10. A.

     A → B.
    B.

     B → A.
    C.

     C → A.
    D.

     (B,C) → A.

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. One solution to the multivalued dependency constraint problem is to:

    11. A.

     split the relation into two relations, each with a single theme.
    B.

     change the theme.
    C.

     create a new theme.
    D.

     add a composite key.

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers