1z0-063 Exam Question 56
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
1z0-063 Exam Question 57
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs? (Choose two.)
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs? (Choose two.)
1z0-063 Exam Question 58
The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:
What is the outcome of the import?
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:
What is the outcome of the import?
1z0-063 Exam Question 59
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
1z0-063 Exam Question 60
NAMETYPEVALUE
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?