logo

CuriousTab

CuriousTab

Discussion


Home Database Database Redesign Comments

  • Question
  • The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Database Redesign problems


    Search Results


    • 1. The SQL-92 command to change a table name is RENAME TABLE.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. A correlated subquery is processed as a nested subquery.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The data model produced from the reverse engineering process is a true logical model.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Database redesign is especially difficult if the database has no data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. If a database is built correctly the first time, it will not have to be redesigned.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. Money is defined in Oracle with the Currency data type.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. Oracle commands, column names, table names, view names and all other database elements are case sensitive.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment