Test: Quiz: Controlling User Access

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

	Section 1
		1.	What system privilege must be held in order to login to an Oracle database?		Mark for Review (1) Points
			CREATE LOGIN
			CREATE SESSION (*)
			CREATE LOGON
			No special privilege is needed, if your username exists in the database, you can login.
				Correct
		2.	Which Object Privilege apart from Alter can be granted to a Sequence?		Mark for Review (1) Points
			SELECT (*)
			UPDATE
			INSERT
			DELETE
				Correct
		3.	By Controlling User Access with Oracle Database Security you can give access to specific Objects in the Database. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		4.	The following table shows some of the output from one of the data dictionary views. Which view is being queried? USERNAME PRIVILEGE ADMIN_OPTION USCA_ORACLE_SQL01_S08 CREATE VIEW NO USCA_ORACLE_SQL01_S08 CREATE TABLE NO USCA_ORACLE_SQL01_S08 CREATE SYNONYM NO USCA_ORACLE_SQL01_S08 CREATE TRIGGER NO USCA_ORACLE_SQL01_S08 CREATE SEQUENCE NO USCA_ORACLE_SQL01_S08 CREATE DATABASE NO		Mark for Review (1) Points
			user_sys_privs (lists system privileges granted to the user) (*)
			user_tab_privs_recd (lists object privileges granted to the user)
			role_tab_privs (lists table privileges granted to roles)
			role_sys_privs (lists system privileges granted to roles)
				Correct
		5.	Which of the following Object Privileges can be granted on an individual column on a table? (Choose two)		Mark for Review (1) Points
			(Choose all correct answers)
			Update (*)
			References (*)
			Insert
			Delete
				Correct
		6.	Which of these is not a System Privilege granted by the DBA?		Mark for Review (1) Points
			Create Sequence
			Create Index (*)
			Create Procedure
			Create Session
				Correct
		7.	System privileges are:		Mark for Review (1) Points
			Required to gain access to the database. (*)
			Required to manipulate the content of objects in the database.
			Named groups of related privileges given to a user.
			A collection of objects, such as tables, views, and sequences.
				Correct
		8.	A Schema is a collection of Objects such as Tables, Views and Sequences. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		9.	A schema is:		Mark for Review (1) Points
			Required to gain access to the database.
			Required to manipulate the content of objects in the database.
			A named group of related privileges given to a user.
			A collection of objects, such as tables, views, and sequences. (*)
				Correct
		10.	Which of the following is not a database object?		Mark for Review (1) Points
			View
			Subquery (*)
			Table
			Sequence
				Correct
		11.	Object privileges are:		Mark for Review (1) Points
			Required to gain access to the database.
			Required to manipulate the content of objects in the database. (*)
			Named groups of related privileges given to a user.
			A collection of objects, such as tables, views, and sequences.
				Correct

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