Menu
Home / CSE / Database System 2 - CS :: Database Redesign

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. Which of the following SQL statements are helpful in database redesign?

    2. A.

     Correlated subqueries only
    B.

     EXISTS/NOT EXISTS expressions only
    C.

     Both of the above are helpful
    D.

     None of the above are helpful

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. What SQL command can be used to delete columns from a table?

    3. A.

     MODIFY TABLE TableName DROP COLUMN ColumnName
    B.

     MODIFY TABLE TableName DROP ColumnName
    C.

     ALTER TABLE TableName DROP COLUMN ColumnName
    D.

     ALTER TABLE TableName DROP ColumnName

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Database redesign is not terribly difficult if the:

    4. A.

     database is structured.
    B.

     database is well-designed.
    C.

     database has no data.
    D.

     database is relatively small.

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which SQL-92 standard SQL command can be used to change a table name?

    5. A.

     RENAME TABLE
    B.

     CHANGE TABLE
    C.

     ALTER TABLE
    D.

     None of the above is correct

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. The process of reading a database schema and producing a data model from that schema is known as:

    6. A.

     data modeling.
    B.

     database design.
    C.

     reverse engineering.
    D.

     None of the above is correct.

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Before any changes to database structure are attempted one should first:

    7. A.

     clearly understand the current structure and contents of the database only.
    B.

     test any changes on a test database only.
    C.

     create a complete backup of the operational database only.
    D.

     All of the above should be done.

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following modifications may not succeed?

    8. A.

     Changing a column data type from char to date
    B.

     Changing a column data type from numeric to char
    C.

     Both of the above actions should succeed
    D.

     Neither of the above actions will succeed

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. How can you find rows that do not match some specified condition?

    9. A.

     EXISTS
    B.

     Double use of NOT EXISTS
    C.

     NOT EXISTS
    D.

     None of the above is correct

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. A regular subquery can be processed:

    10. A.

     from the top down.
    B.

     from the bottom up.
    C.

     by nesting.
    D.

     None of the above is correct.

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. What SQL command can be used to add columns to a table?

    11. A.

     MODIFY TABLE TableName ADD COLUMN ColumnName
    B.

     MODIFY TABLE TableName ADD ColumnName
    C.

     ALTER TABLE TableName ADD COLUMN ColumnName
    D.

     ALTER TABLE TableName ADD ColumnName

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers