Test: Quiz: Indexes and Synonyms

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

	Section 1
		1.	Which of the following SQL statments shows a correct syntax example of creating a synonym accessible to all users of a database?		Mark for Review (1) Points
			CREATE SYNONYM emp FOR EMPLOYEES
			CREATE PUBLIC SYNONYM emp FOR EMPLOYEES (*)
			CREATE UNRESTRICTED SYNONYM emp FOR EMPLOYEES
			CREATE SHARED SYNONYM emp FOR EMPLOYEES
				Correct
		2.	All tables must have indexes on them otherwise they cannot be queried. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		3.	It is possible to have an indexed column in a table where a value in the table column does not exist in the index. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		4.	In SQL what is a synonym?		Mark for Review (1) Points
			A table with the same number of columns as another table.
			A table with the same name as another view.
			A different name for a table, view or other database object. (*)
			A table with that must be qualified with a username.
				Correct
		5.	You must use a synonym to access another users table. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		6.	What kind of INDEX is created by Oracle when you create a primary key?		Mark for Review (1) Points
			UNIQUE INDEX. (*)
			NONUNIQUE INDEX.
			INDEX.
			Oracle cannot create indexes automatically.
				Correct
		7.	Indexes can be used to speed up queries. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		8.	Which of the following statements best describes indexes and their use?		Mark for Review (1) Points
			They are just random copies of data in no particular order.
			They contain the column value and pointers to the data in the table, but the data is sorted. (*)
			They contain all the rows and columns from the table.
			None of the above.
				Correct

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