Test: Quiz: Managing Views

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 (*)
				Correct
		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
				Correct
		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
				Correct
		4.	Which of these Keywords is typically used with a Top-N Analysis?		Mark for Review (1) Points
			Rowid
			Rownum (*)
			Sequence
			Number
				Correct
		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 (*)
				Correct
		6.	Which of these is not a valid type of View?		Mark for Review (1) Points
			INLINE
			ONLINE (*)
			SIMPLE
			COMPLEX
				Correct
		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
				Correct

( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )