True Or False

Question 1 :

A correlated subquery is processed as a nested subquery.


A). True
B). False
Answer : Option A

Question 2 :

A regular subquery is processed from the bottom up.


A). True
B). False
Answer : Option A

Question 3 :

Correlated subqueries are similar to a regular subquery.


A). True
B). False
Answer : Option B

Question 4 :

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


A). True
B). False
Answer : Option B

Question 5 :

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


A). True
B). False
Answer : Option A

Question 6 :

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


A). True
B). False
Answer : Option A

Question 7 :

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.


A). True
B). False
Answer : Option B

Question 8 :

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


A). True
B). False
Answer : Option B

Question 9 :

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


A). True
B). False
Answer : Option B

Question 10 :

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


A). True
B). False
Answer : Option B

Question 11 :

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


A). True
B). False
Answer : Option B

Question 12 :

Reverse engineering is the process of reading a database schema and producing a data model from that schema.


A). True
B). False
Answer : Option A

Question 13 :

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


A). True
B). False
Answer : Option B

Question 14 :

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


A). True
B). False
Answer : Option A

Question 15 :

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


A). True
B). False
Answer : Option B

Question 16 :

Information systems and organizations do not just influence each other; they create each other.


A). True
B). False
Answer : Option A

Question 17 :

Adding null columns to a table is straightforward.


A). True
B). False
Answer : Option A

Question 18 :

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


A). True
B). False
Answer : Option B

Question 19 :

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


A). True
B). False
Answer : Option A

Question 20 :

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


A). True
B). False
Answer : Option A