Test: Final Exam Semester 2 - Part II (41-50)

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

Part II of the Semester 2 Final Exam covers Sections 10-14 of Database Programming with SQL.

	Section 12
		41.	You want to grant user BOB the ability to change other users' passwords. Which privilege should you grant to BOB?		Mark for Review (1) Points
			The ALTER USER privilege (*)
			The CREATE USER privilege
			The DROP USER privilege
			The CREATE PROFILE privilege
				Correct
		42.	The database administrator wants to allow user Marco to create new tables in his own schema. Which privilege should be granted to Marco?		Mark for Review (1) Points
			CREATE ANY TABLE
			SELECT
			CREATE TABLE (*)
			CREATE OBJECT
				Correct
		43.	Which statement would you use to remove an object privilege granted to a user?		Mark for Review (1) Points
			ALTER USER
			REVOKE (*)
			REMOVE
			DROP
				Correct
		44.	When granting an object privilege, which option would you include to allow the grantee to grant the privilege to another user?		Mark for Review (1) Points
			WITH GRANT OPTION (*)
			WITH ADMIN OPTION
			PUBLIC
			FORCE
				Correct
		45.	Which statement would you use to grant a role to users?		Mark for Review (1) Points
			GRANT (*)
			ALTER USER
			CREATE USER
			ASSIGN
				Correct
		46.	Which statement would you use to add privileges to a role?		Mark for Review (1) Points
			CREATE ROLE
			ALTER ROLE
			GRANT (*)
			ASSIGN
				Correct
		47.	Which of the following simplifies the administration of privileges?		Mark for Review (1) Points
			An index
			A view
			A trigger
			A role (*)
				Correct
		48.	To join a table in your database to a table on a second (remote) Oracle database, you need to use:		Mark for Review (1) Points
			A remote procedure call
			An Oracle gateway product
			An ODBC driver
			A database link (*)
				Correct
	Section 14
		49.	Which SQL statement is used to remove all the changes made by an uncommitted transaction?		Mark for Review (1) Points
			UNDO;
			ROLLBACK; (*)
			ROLLBACK TO SAVEPOINT;
			REVOKE ...;
				Correct
		50.	If a database crashes, all uncommitted changes are automatically rolled back. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct