Q.1

A regular subquery is processed from the bottom up.

  • True
  • False
Q.2

Correlated subqueries are similar to a regular subquery.

  • True
  • False
Q.3

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

  • RENAME TABLE
  • CHANGE TABLE
  • ALTER TABLE
  • None of the above is correct.
Q.4

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

  • True
  • False
Q.5

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

  • True
  • False
Q.6

The data model produced from the reverse engineering process is a true logical model.

  • True
  • False
Q.7

It is not easy to build a database correctly the first time.

  • True
  • False
Q.8

Database redesign is especially difficult if the database has no data.

  • True
  • False
Q.9

Some organizations take the stand that no application should ever employ the true name of a table.

  • True
  • False
Q.10

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

  • data modeling.
  • database design.
  • reverse engineering.
  • None of the above is correct.
Q.11

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

  • True
  • False
Q.12

The EXISTS keyword will be true if any row in the subquery meets the condition.

  • True
  • False
Q.13

The data model produced from the reverse engineering process does not include intersection table data.

  • True
  • False
Q.14

If a database is built correctly the first time, it will not have to be redesigned.

  • True
  • False
Q.15

Typically, there should be at least two different copies of the database schema used in the redesign process.

  • True
  • False
0 h : 0 m : 1 s