Discussion
Home ‣ Database ‣ Database Redesign Comments
- Question
A correlated subquery is processed as a nested subquery.
Options- A. True
- B. False
- Correct Answer
- True
- 1. The data model produced from the reverse engineering process is a true logical model.
Options- A. True
- B. False Discuss
- 2. Database redesign is especially difficult if the database has no data.
Options- A. True
- B. False Discuss
- 3. If a database is built correctly the first time, it will not have to be redesigned.
Options- A. True
- B. False Discuss
- 4. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Options- A. True
- B. False Discuss
- 5. Correlated subqueries are similar to a regular subquery.
Options- A. True
- B. False Discuss
- 6. The SQL-92 command to change a table name is RENAME TABLE.
Options- A. True
- B. False Discuss
- 7. The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Options- A. True
- B. False Discuss
- 8. Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
Options- A. True
- B. False Discuss
- 9. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Options- A. True
- B. False Discuss
- 10. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
Options- A. True
- B. False Discuss
Database Redesign problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.