Online Access Free Oracle.1z0-063.v2021-12-27.q100 Practice Test (Page 12)

1z0-063 Exam Question 51

Examine the commands executed in the root container of your multitenant container database (CDB) that
has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

A.It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root
database and all the PDBs.

B.It fails and reports an error because the container=all clause is not used.

C.It fails and reports an error because the container=current clause is not used.

D.It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root
container.

1z0-063 Exam Question 52

In which three situations must you use a recovery catalog? (Choose three.)

A.when you want to store RMAN global scripts that can be used across multiple databases

B.when you want to restrict the amount of space used by backups

C.when you want to perform incremental backups by using a block change tracking file

D.when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

E.when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

1z0-063 Exam Question 53

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

A.capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on thetest system

B.capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

C.capturing the workload on the production systemand using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

D.capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

1z0-063 Exam Question 54

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

A.All data files belonging to pdb2_1 are backed up along with the archive log files.

B.Only the data files belonging to pdb2_ are backed up.

C.This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

D.All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

1z0-063 Exam Question 55

Which two statements are true abouta multitenant architecture?

A.A PDB can have a private undo tablespace.

B.Each PDB has a private control file.

C.A PDB can have a private temporary tablespace.

D.Log switches occur only at the container database level.

E.Each pluggable database (PDB) has its own initialization parameter file.

Other Version: 58Oracle.Briandumpsprep.1z0-063.v2022-03-17.by.arthur.218q.pdf; 4733Oracle.1z0-063.v2022-02-06.q218; 66Oracle.Examcollectionpass.1z0-063.v2021-09-28.by.kelly.255q.pdf

Latest Upload: 143SAP.C_ABAPD_2507.v2025-09-12.q56; 122SAP.C_TS452_2022.v2025-09-12.q83; 191ACSM.020-222.v2025-09-11.q48; 158VMware.5V0-31.23.v2025-09-10.q73; 132Oracle.1z0-915-1.v2025-09-10.q24; 162Citrix.1Y0-231.v2025-09-10.q87; 146SAP.C-THR85-2505.v2025-09-09.q29; 178Adobe.AD0-E727.v2025-09-09.q76; 136Oracle.1Z0-1123-25.v2025-09-09.q20; 137SAP.C_SIGPM_2403.v2025-09-08.q20

1z0-063 Exam Question 51

1z0-063 Exam Question 52

1z0-063 Exam Question 53

1z0-063 Exam Question 54

1z0-063 Exam Question 55

Download PDF File