Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. When you drop a view, the data it contains is also deleted. True or False?Mark for Review
(1) Points
True
False (*)
2. Which of the following is true about ROWNUM?Mark for Review
(1) Points
It is the number assigned to each row returned from a query after they are ordered.
It is the number assigned to each row returned from a query as they are read from disk. (*)
It is the number of rows in a table.
None of the above
3. How do you remove a view?Mark for Review
(1) Points
DELETE VIEW view_name
REMOVE VIEW view_name
DROP VIEW view_name (*)
You cannot remove a view
4. Which of these Keywords is typically used with a Top-N Analysis?Mark for Review
(1) Points
Rowid
Rownum (*)
Sequence
Number
5. When you drop a table referenced by a view, the view is automatically dropped as well. True or False? Mark for Review
(1) Points
True
False (*)
6. Which of these is not a valid type of View?Mark for Review
(1) Points
INLINE
ONLINE (*)
SIMPLE
COMPLEX
7. A Top-N Analysis is capable of ranking a top or bottom set of results. True or False?Mark for Review
(1) Points
True (*)
False