Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
An Oracle System Change Number (SCN):
Options- A. is a value that is incremented whenever a dirty read occurs.
- B. is incremented whenever a deadlock occurs.
- C. is a value that keeps track of explicit locks.
- D. is a value that is incremented whenever database changes are made.
- Correct Answer
- is a value that is incremented whenever database changes are made.
- 1. Which of the following is NOT an Oracle-supported trigger?
Options- A. BEFORE
- B. DURING
- C. AFTER
- D. INSTEAD OF Discuss
- 2. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options- A. The line numbers reported match the line numbers you see in your text editor.
- B. SQL*Plus will automatically show the errors to you.
- C. To see the errors, enter SHOW ERRORS in SQL*Plus.
- D. If there are no syntax errors, you will receive the message "NO ERRORS." Discuss
- 3. Which prefixes are available to Oracle triggers?
Options- A. :new only
- B. :old only
- C. Both :new and :old
- D. Neither :new nor :old Discuss
- 4. The default extension for an Oracle SQL*Plus file is:
Options- A. .txt.
- B. .pls.
- C. .ora.
- D. .sql. Discuss
- 5. Which of the following is not true about modifying table columns?
Options- A. You can drop a column at any time.
- B. You can add a column at any time as long as it is a NULL column.
- C. You can increase the number of characters in character columns or the number of digits in numeric columns
- D. You cannot increase or decrease the number of decimal places. Discuss
- 6. Which of the following is not true of SQL views?
Options- A. Oracle views cannot use the ORDER BY clause in view definitions.
- B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
- C. Oracle views can by queried.
- D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Discuss
- 7. To obtain the structure of an Oracle table, the command to use is:
Options- A. STRUCTURE [TableName].
- B. DESCRIBE [TableName].
- C. DESCRIBE STRUCTURE [TableName].
- D. DESC TABLE [TableName]. Discuss
- 8. SQL*Plus will finish the statement and execute it when the user types in this:
Options- A. A left slash ( \ ) followed by [Enter].
- B. A colon ( : ) followed by [Enter].
- C. A semicolon ( ; ) followed by [Enter].
- D. A period ( . ) followed by [Enter]. Discuss
- 9. Which SQL phrase is not supported by Oracle?
Options- A. ON DELETE CASCADE
- B. ON UPDATE CASCADE
- C. CREATE SEQUENCE [SequenceName]
- D. DROP SEQUENCE [SequenceName] Discuss
- 10. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Options- A. Application failure
- B. Instance Failure
- C. Media Failure
- D. Rollback failure Discuss
Managing Databases with Oracle problems
Search Results
Correct Answer: DURING
Correct Answer: To see the errors, enter SHOW ERRORS in SQL*Plus.
Correct Answer: Both :new and :old
Correct Answer: .sql.
Correct Answer: You cannot increase or decrease the number of decimal places.
Correct Answer: Oracle views cannot use the ORDER BY clause in view definitions.
Correct Answer: DESCRIBE [TableName].
Correct Answer: A semicolon ( ; ) followed by [Enter].
Correct Answer: ON UPDATE CASCADE
Correct Answer: Instance Failure
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.