In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

• A.The C # # ROLE1 role is created in the root database and all the PDBs.
• B.The C # # ROLE1 role is created only in the root database because the container clause is not used.
• C.Privileges are granted to the C##A_ADMIN user only in the root database.
• D.Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E.The statement for granting a role to a user fails because the CONTAINER clause is not used.

Comment: *

Name: *

Email: *

Verification: *

Which three activities are supported by the Data Recovery Advisor?

• A.Advising on block checksum failures
• B.Advising on inaccessible control files
• C.Advising on inaccessible blockchange tracking files
• D.Advising on empty password files
• E.Advising on invalid block header field values

Comment: *

Name: *

Email: *

Verification: *

When is the UNDO_RETENTION parameter value ignored by a transaction?

• A.when there are multiple undo tablespaces available in a database
• B.when the data file of the undo tablespace is autoextensible
• C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
• D.when Flashback Database is enabled

Comment: *

Name: *

Email: *

Verification: *

The HRuser owns the BONUSEStable. HRgrants privileges to the user TOMby using the command:
SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
TOMthen executes this command to grant privileges to the user JIM:
SQL> GRANT SELECT ON hr.bonuses TO jim;
Which statement is true?

• A.HRcan revoke the SELECT ON HR.BONUSESprivilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.
• B.TOMcannot revoke the SELECT ON HR.BONUSESprivilege from JIM.
• C.JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.
• D.HRcan revoke the SELECT ON HR.BONUSES privilege from JIM.

Comment: *

Name: *

Email: *

Verification: *

Your database is open and the listener LISTNENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of reload on sessions that were originally established by listener?

• A.All the sessions are terminated and active transactions are rolled back.
• B.The sessions are not affected and continue to function normally.
• C.Only sessions based on static listener registrations are disconnected.
• D.Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

Comment: *

Name: *

Email: *

Verification: *