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

Question 56

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE 'u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;
What is the result?

A.It executes successfully and creates an UNDO tablespace in HR_PDB.

B.It falls and reports an error because there can be only one undo tablespace in a CD

C.It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.

D.It fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.

E.It executes successfully but neither tablespace nor the data file is created.

Question 57

Examine the commands executed to monitor database operations:
$ > conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid:= DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job',
FORCED_TRACKING => 'Y');
Which two statements are true? (Choose two.)

A.Database operations will be monitored only when they consume a significant amount of resources.

B.Database operations for all sessions will be monitored.

C.Database operations will be monitored only if the STATISTICS_LEVELparameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESSis set to DIAGNISTIC + TUNING.

D.Only DML and DDL statements will be monitored for the session.

E.All subsequent statements in the session will be treated as one database operation and will be monitored.

Question 58

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

A.Use Oracle Managed Files (OMF).

B.Specify the SEED FILE_NAME_CONVERT clause.

C.Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D.Specify the DB_FILE_NAME_CONVERT initialization parameter.

E.Specify all files names in the CREATE DATABASE statement without using Oracle Managed Files (OMF).

Question 59

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLEprivilege to the common user C # # A_ADMINin root and all PDBs. You then execute this command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

A.It executes successfully and the CREATE TABLEprivilege is revoked from C # # A_ADMINin root only.

B.It fails and reports an error because the CONTAINER=ALLclause is not used.

C.It excludes successfully and the CREATE TABLEprivilege is revoked from C # # A_ADMINin root and all PDBs.

D.It fails and reports an error because the CONTAINER=CURRENTclause is not used.

E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMINin all PDBs.

Question 60

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)

A.Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.

B.Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

C.Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.

D.Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

E.Shut down the database instance and then restart the CDB and PDBs.

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

Question 56

Question 57

Question 58

Question 59

Question 60

Download PDF File