Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 5)

Question 16

One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOTas SYSand 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##CONNECTrole can be granted different roles and privileges in each PDB.

B.C##ADMINhas the orcl123password in all PDBs.

C.The C##CONNECTrole is granted to the C##ADMINuser in all PDBs.

D.CREATE SESSIONis granted to the C##ADMINuser in all PDBs.

E.The C##CONNECTrole is a local role defined only in CDB$ROOT.

Question 17

You execute the command to recover your database:

Which statement is true?

A.It restores all data files from the specified time, and then applies the redo logs.

B.It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.

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".

Question 18

Which three statements are true about the keystore storage framework for transparent data encryption?
(Choose three.)

A.It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

B.It facilitates and helps to enforce keystore backup requirements.

C.It enables a keystore to be stored only in a file on a file system.

D.It handles encrypted data without modifying applications.

E.It enables separation of duties between the database administrator and the security administrator.

F.It transparently decrypts data for the database users and applications that access this data.

Question 19

You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Createthe same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.

A.2, 1, 3, 5, 7, 6, and 8

B.2, 1, 3, 7, 6, and 8

C.2, 1, 4, 5, 3, 7, 6, 9, and 8

D.2, 1, 3, 7, 6, 9, and 8

Question 20

Which two statements are true about scheduling operations in a pluggable database (PDB)?

A.Scheduler objects created by users can be exported or imported using Data Pump.

B.Scheduler attribute setting is performed only at the CDB level.

C.A job defined in a PDB runs only if that PDB is open.

D.Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

E.Scheduler jobs for a PDB can becreated only by common users.

Other Version: 2134Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 204CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File