1. Which of the following statements are true? (Choose all correct answers.) A.

Question

1.   Which of the following statements are true? (Choose all correct answers.)

A. You can create more than one UNDO tablespace

B. UNDO_MANAGEMENT=Yes will let Oracle automatically manage UNDO tablespace

C. You can change the value of UNDO_MANAGEMENT dynamically after the database starts.

D. You can use ALTER SYSTEM SET to switch between undo tablespaces     

2. You have been asked to provide additional information to your manager on how system privileges can be assigned and behave. Which of the following statements about system privileges are true? (Choose all correct answers.)

A. System privileges can be granted to others if you use the WITH ADMIN OPTION.

B. System privileges can be granted to others if you use the WITH GRANT OPTION.

C. Only the DBA can grant system privileges, since the DBA owns the database.

D. When revoked for a user, system privileges will not be revoked for any user to whom that user granted

E. System privileges can be granted only by the owner of the database.

3. Assume Redo log group 1 is the current active one. According to this diagram, which of the following statements are true? (Choose all correct answers.)

A. LGWR fills Redo3.log before writing to Redo2.log.

B. A log switch changes from Drive E to Drive F.

C. LGWR fills Redo1.log before writing to Redo3.log.

D. A log switch changes from Group 1 to Group 2.

Explanation / Answer

1. A. You can create more than one UNDO tablespace - True

Undo tablespaces are relevant only in the SMU mode. You can create multiple undo tablespaces in Oracle9i by using the CREATE UNDO TABLESPACE command. However, at any given time only one undo tablespace can be active in the database. The value of the parameter UNDO_TABLESPACEdetermines the undo tablespace that's active.

B. UNDO_MANAGEMENT=Yes will let Oracle automatically manage UNDO tablespace - True

The CREATE UNDO TABLESPACE statement is the same as the CREATE TABLESPACE statement, but the UNDO keyword is specified. The database determines most of the attributes of the undo tablespace, but you can specify the DATAFILE clause.

C. You can change the value of UNDO_MANAGEMENT dynamically after the database starts. - False

D. You can use ALTER SYSTEM SET to switch between undo tablespaces - False

2. A. System privileges can be granted to others if you use the WITH ADMIN OPTION - True

Any 'global' privileges like roles and system privileges (e.g. CREATE TABLE) are granted using the WITH ADMIN OPTION. For table-specific privileges (e.g. GRANT select on emp) we use WITH GRANT OPTION syntax. Also, revoking any grant WITH GRANT will cascade and revoke any and all privileges assigned by the privileged user. On the other hand, revoking someone with the WITH ADMIN OPTION will only revoke their personal privileges, leaving intact all granted users.When system privileges are passed to others using the WITH ADMIN OPTION, revoking the system privileges from the original user will not cascade. The system privileges granted to others must be revoked directly. In contrast, when object privileges are passed on to others using the WITH GRANT OPTION, the object privileges are revoked when the grantor's privileges are revoked.

It is important to note that only object privileges will cascade when revoked; system privileges will not.
When the WITH ADMIN OPTION or WITH GRANT OPTION has been included in a grant to another user, the privilege cannot be revoked directly. You must revoke the privilege and then issue another grant without the WITH ADMIN OPTION or WITH GRANT OPTION.

B. System privileges can be granted to others if you use the WITH GRANT OPTION. - True

SQL GRANT REVOKE Commands

DCL commands are used to enforce database security in a multiple user database environment. Two types of DCL commands are GRANT and REVOKE. Only Database Administrator's or owner's of the database object can provide/remove privileges on a database object.

SQL GRANT Command

SQL GRANT is a command used to provide access or privileges on the database objects to the users.

C. Only the DBA can grant system privileges, since the DBA owns the database. - False

D. When revoked for a user, system privileges will not be revoked for any user to whom that user granted - True

E. When revoked for a user, system privileges will not be revoked for any user to whom that user granted - True

3.A.  LGWR fills Redo3.log before writing to Redo2.log - False

B. A log switch changes from Drive E to Drive F.- True

C. LGWR fills Redo1.log before writing to Redo3.log.- True

D. A log switch changes from Group 1 to Group 2.- False

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.