MCQs
Total Questions : 40
| Page 1 of 4 pages
Answer: Option D. -> Sequences guarantee valid surrogate key values.
Answer: Option C. -> Indexes are created with the ALTER TABLE command.
Answer: Option C. -> Both :new and :old
Answer: Option B. -> To see the errors, enter SHOW ERRORS in SQL*Plus.
Answer: Option C. -> Instance Failure
Answer: Option C. -> You cannot increase or decrease the number of decimal places.
Answer: Option D. -> A semicolon ( ; ) followed by [Enter].
Answer: Option C. -> Oracle views cannot use the ORDER BY clause in view definitions.
Answer: Option D. -> DURING
Answer: Option B. -> ALTER TABLE [TableName].