Discussion
Home ‣ Database ‣ Database Redesign Comments
- Question
The SQL-92 command to change a table name is RENAME TABLE.
Options- A. True
- B. False
- Correct Answer
- False
- 1. A correlated subquery is processed as a nested subquery.
Options- A. True
- B. False Discuss
- 2. The data model produced from the reverse engineering process is a true logical model.
Options- A. True
- B. False Discuss
- 3. Database redesign is especially difficult if the database has no data.
Options- A. True
- B. False Discuss
- 4. If a database is built correctly the first time, it will not have to be redesigned.
Options- A. True
- B. False Discuss
- 5. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Options- A. True
- B. False Discuss
- 6. 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
- 7. 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
- 8. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Options- A. True
- B. False Discuss
- 9. 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
- 10. Money is defined in Oracle with the Currency data type.
Options- A. True
- B. False Discuss
Database Redesign problems
Search Results
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.