Free Access Oracle.1Z1-060.v2022-03-23.q171 Practice Test (Page 4)

Question 11

Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB?

A.SQL Developer

B.Oracle Universal Installer (OUI)

C.Enterprise Manager Cloud Control

D.Database Configuration Assistant (DBCA)

E.Database Upgrade Assistant (DBUA)

Question 12

The current system change number (SCN) for a live database is 663571.
You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERStable to SCN 662116.
After flashing back the CUSTOMERStable, you query it and decide to undo the effects of the FLASHBACK TABLE command.
Which is the fastest way to do this?

A.Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

B.Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.

C.Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

D.Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

Question 13

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)

A.ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B.ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array

C.ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files

D.Database files stored in ZFS and accessed using conventional NFS mounts.

E.Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F.Database files stored in any file system and accessed using the Oracle Direct NFS feature

G.ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Question 14

A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A.SYSsessions, regardless of the roles that are set in the session

B.SYSTEMsessions, regardless of the roles that are set in the session

C.SCOTTsessions, only if the MGRrole is set in the session

D.SCOTTsessions, only if the MGRrole is granted to SCOTT

E.SCOTTsessions, because he is the owner of the table

F.SYSTEMsession, only if the MGRrole is set in the session

Question 15

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A.By default, EM express is available for a database after database creation.

B.You can use EM express to manage multiple databases running on the same server.

C.You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D.You cannot start up or shut down a database Instance by using EM express.

E.You can create and configure pluggable databases by using EM express.

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 206CFAInstitute.ESG-Investing.v2025-09-08.q173; 153PECB.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 11

Question 12

Question 13

Question 14

Question 15

Download PDF File