Database Redesign - Database MCQ Questions and answers- Technical Aptitude

Home / Database / Database Redesign

21.
A correlated subquery is processed as a nested subquery.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

22.
A regular subquery is processed from the bottom up.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

23.
Correlated subqueries are similar to a regular subquery.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.
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 & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4