Examine this query:
SELECT cust_name, amt_due
FROM customers
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE cust_no = 'AYR2011';
Which two requirements guarantee that the query will execute successfully? (Choose two.)

• A.Row movement must be enabled for CUSTOMERS.
• B.Automatic Undo Management must be configured.
• C.FLASHBACKmust be ONfor the database.
• D.Undo retention guarantee must be enabled.
• E.The database must be in ARCHIVELOGmode.
• F.Supplemental logging must be enabled.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about a job chain? (Choose three.)

• A.It can contain a nested chain of jobs.
• B.It can be used to implement dependency-based scheduling.
• C.It cannot invoke the same program or nested chain in multiple steps in the chain.
• D.It cannot have more than one dependency.
• E.It can be executed using event-based or time-based schedules.

Comment: *

Name: *

Email: *

Verification: *

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

• A.password-mode encryption
• B.dual-mode encryption
• C.transparent encryption
• D.default encryption

Comment: *

Name: *

Email: *

Verification: *

Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

• A.The command fails because container is not set to current.
• B.The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt.
• C.The command succeeds and the common user cmadnxn can create a session and query the D3A_users view incdbssoo? and all the PDBs.
• D.The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.
• E.The command fails and gives an error because object privileges cannot be granted to a common user.

Comment: *

Name: *

Email: *

Verification: *

Your database is running in archivelog mode and a nightly backup of the database, along with an
autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the
control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the startup force nomount command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in nomount state.
Identify the required steps in the correct order.

• A.1, 2, 3, 5, 6, 4
• B.2, 1, 5, 7, 3, 4
• C.2, 1, 5, 6, 7, 4, 3
• D.1, 2, 5, 3, 6, 4

Comment: *

Name: *

Email: *

Verification: *