Question 1 of 25
Hints left: 3
Q1
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Q2
If a database is built correctly the first time, it will not have to be redesigned.
Q3
The SQL-92 command to change a table name is RENAME TABLE.
Q4
Which statement about sequences is not true?
Q5
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Q6
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Q7
Some organizations take the stand that no application should ever employ the true name of a table.
Q8
The data model produced from the reverse engineering process does not include intersection table data.
Q9
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Q10
Database redesign is especially difficult if the database has no data.
Q11
Adding null columns to a table is straightforward.
Q12
Information systems and organizations do not just influence each other; they create each other.
Q13
It is not easy to build a database correctly the first time.
Q14
A correlated subquery is processed as a nested subquery.
Q15
Which of the following is not true about indexes?
Q16
Correlated subqueries are similar to a regular subquery.
Q17
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Q18
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Q19
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Q20
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Q21
The EXISTS keyword will be true if any row in the subquery meets the condition.
Q22
The data model produced from the reverse engineering process is a true logical model.
Q23
A regular subquery is processed from the bottom up.
Q24
Which prefixes are available to Oracle triggers?
Q25
Typically, there should be at least two different copies of the database schema used in the redesign process.