Free Access Oracle.1Z0-060.v2022-02-12.q102 Practice Test (Page 16)

Question 71

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

A.Place the root container in ARHCHIVELOG mode.

B.Take the user data tablespace offline.

C.Place the root container in the nomount stage.

D.Ensure that HR_PDB is open.

Question 72

A new report process containing a complex query is written, with high impact on the database.
You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

A.Execute the query and view Active Session History (ASH) for information about the query.

B.Enable SQL trace for the query.

C.Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_ MONITOR function to view the report.

D.Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Question 73

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?

A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1will fall.

B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2failure group until the CONTROLLER1for failure group is brought back online.

C.ASM does not mirror any data until the CONTROLLER1failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER2failure group, without mirroring.

D.The data in the CONTROLLER1failure group is copied to the CONTROLLER2failure group and rebalancing is initiated.

Question 74

Examine this set of commands to perform data pump export and import operations:
On the source database:
$> expdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1 On the target database:
$> impdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1 Which three statements are true? (Choose three.)

A.Metadata for dependent objects required to create the SALES_Q1view is exported.

B.This impdpoperation creates the view as a table and populates it with data from the export dump file.

C.The impdpoperation creates the view and the dependent object.

D.All rows from the dependent objects that are required are exported along with the metadata to create the SALES_Q1view.

E.The exdpoperation exports data that satisfies the conditions of the defining query used when the view was created.

Question 75

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
'+RECO';
Which five steps are performed by RMAN? (Choose five.)

A.flashing back the original database to the desired point in time

B.importing the SCOTT.EMP table into the original database

C.truncating the SCOTT.EMP table in the original database

D.creating an auxiliary instance

E.exporting the SCOTT.EMP table from the auxiliary database

F.recovering the auxiliary database to the desired point in time

G.restoring the tablespaces required for point-in-time recovery

H.dropping the SCOTT.EMP table in the original database

Premium Bundle

Newest 1Z0-060 Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing 1Z0-060 Exam! BraindumpsPass.com now offer the updated 1Z0-060 exam dumps, the BraindumpsPass.com 1Z0-060 exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com 1Z0-060 pdf dumps with Exam Engine here:

Access 1Z0-060 Premium Version

(205 Q&As Dumps, 40%OFF Special Discount: Exam-Tests)

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 142Adobe.AD0-E605.v2025-09-05.q50