1z0-063 Exam Question 61
user_data is a non-encrypted tablespace containing tables with data.
You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)
You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)
1z0-063 Exam Question 62
You are administering a database that supports a data warehousing workload and is running in
noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental
backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?
noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental
backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?
1z0-063 Exam Question 63
Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?
1z0-063 Exam Question 64
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.)
(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.)
1z0-063 Exam Question 65
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
Examine the commands to change the value of the PDB modifiable initialization parameter:
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?