Q.1
Typically, there should be at least two different copies of the database schema used in the redesign process.
Q.2
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Q.3
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Q.4
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Q.5
The data model produced from the reverse engineering process does not include intersection table data.
Q.6
If a database is built correctly the first time, it will not have to be redesigned.
Q.7
A correlated subquery is processed as a nested subquery.
Q.8
A regular subquery is processed from the bottom up.
Q.9
Correlated subqueries are similar to a regular subquery.
Q.10
The data model produced from the reverse engineering process is a true logical model.
Q.11
It is not easy to build a database correctly the first time.
Q.12
Information systems and organizations do not just influence each other; they create each other.
Q.13
Adding null columns to a table is straightforward.
Q.14
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Q.15
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Q.16
The EXISTS keyword will be true if any row in the subquery meets the condition.
Q.17
The SQL-92 command to change a table name is RENAME TABLE.
Q.18
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Q.19
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Q.20
Which is not true of a correlated subquery?
0 h : 0 m : 1 s