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

Question 1

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A.If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.

B.To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

C.If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.

D.If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.

E.If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Question 2

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A.A PDB must be in closed state before it can be unplugged.

B.A PDB must have been opened at least once after creation.

C.A PDB must be in MOUNT state before it can be unplugged.

D.PDB data file are automatically removed from disk.

E.An unplugged PDB can be plugged into the same or another container database (CDB).

Question 3

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA I00M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

A.The command succeeds only if all the PDBs have the users and temp tablespaces.

B.The commandsucceeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.

C.The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

D.The command gives an error because the container=all clause is missing.

Question 4

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup
(OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

A.1, 3, 6, 7, 4

B.2, 1, 6, 4, 7

C.1, 3, 5, 7, 4

D.1, 3, 6, 4, 7

Question 5

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

A.Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

B.All the constraints defined on the table, except the referential integrity constraints, are flashed back.

C.All the triggers associated with the table are flashed back but are disabled.

D.Materialized views that use the CUSTOMERS table are flashed back.

E.LOB segments associated with the CUSTOMERS table are flashed back.

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

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

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File