Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
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
- Correct Answer
- True
- 1. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Options- A. True
- B. False Discuss
- 2. 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
- 3. 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
- 4. The SQL-92 command to change a table name is RENAME TABLE.
Options- A. True
- B. False Discuss
- 5. A correlated subquery is processed as a nested subquery.
Options- A. True
- B. False Discuss
- 6. Money is defined in Oracle with the Currency data type.
Options- A. True
- B. False Discuss
- 7. Oracle commands, column names, table names, view names and all other database elements are case sensitive.
Options- A. True
- B. False Discuss
- 8. When you type Start FILENAME, the statement in your file will be executed automatically.
Options- A. True
- B. False Discuss
- 9. If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
Options- A. True
- B. False Discuss
- 10. The only time that case matters is inside quotation marks of strings.
Options- A. True
- B. False Discuss
Managing Databases with Oracle problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.