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