1z1-063 무료 덤프문제 온라인 액세스

You execute the command to recover your database:

Which statement is true?

• A.It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
• B.It restores all data files from the specified time, and then applies the redo logs.
• C.It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.
• D.It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".

One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which three are true? (Choose three.)

• A.The C##CONNECT role is a local role defined only in CDB$ROOT.
• B.CREATE SESSION is granted to the C##ADMIN user in all PDBs.
• C.C##ADMIN has the orcl123 password in all PDBs.
• D.The C##CONNECT role can be granted different roles and privileges in each PDB.
• E.The C##CONNECT role is granted to the C##ADMIN user in all PDBs.

You plan to create a new PDB by copying PDB$SEED.
Which two requirements ensure a successful creation? (Choose two.)

• A.The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.
• B.The CDB, which will contain the PDB, must be in READ WRITE mode.
• C.A PDB local administrative user must be granted the DBA role when creating the PDB.
• D.A PDB local administrative user must be specified when creating the PDB.
• E.A default service for the new PDB name must already exist.
• F.The CDB must use Oracle Managed Files.

You want to move your existing recovery catalog to another database.
Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOG command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.
6) Connect to the destination database.
7) Connect as CATALOG to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

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

Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?

• A.Data older than two years, if any, is purged from the flashback archive FDA1.
• B.An error is returned because the retention period cannot be reduced.
• C.Flashback archive FDA1 retains all data and the retention period is increased by 2 years.
• D.Data from the first and third years is purged from the flashback archive FDA1.
• E.Data from the third year is purged from the flashback archive FDA1.