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

Question 21

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOTand SEEDcontainer 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_CONVERTclause.

C.Specify the PDB_FILE_NAME_CONVERTinitialization parameter.

D.Specify the DB_FILE_NAME_CONVERTinitialization parameter.

E.Specify all files names in the CREATE DATABASEstatement without using Oracle managed Files (OMF).

Question 22

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A.Effectively implements role separation

B.Enables you to take advantage of Oracle Managed Files.

C.Automatically registers the database with Oracle Restart.

D.Helps you to easily upgrade the database from a prior release.

E.Enables the Installation of Grid Infrastructure files on block or raw devices.

Question 23

You execute this piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTTqueries the SALcolumns in the view and the table?

A.Data is never redacted on the EMP_V.SALcolumn.

B.Data is redacted for the EMP.SALcolumn only if the SCOTTsession has the MGRrole set.

C.Data is redacted for the EMP.SALcolumn only if the SCOTTsession does not have the MGRrole set.

D.Data is never redacted on the EMP.SALcolumn.

E.Data is redacted for the EMP_V.SALcolumn only if the SCOTTsession has the MGRrole set.

Question 24

Your multitenantcontainer database (CDB) contains some pluggabledatabases (PDBs), youexecute the following command inthe root container:

Which two statements are true?

A.Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

B.The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C.The command will, create a common user whose description is contained in the root and each PDB.

D.The schema for the common user C # # A_ADMIN can be different in each container.

E.The command will create a user in the root container only because the container clause is not used.

Question 25

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.

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.Shutdown 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: 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 21

Question 22

Question 23

Question 24

Question 25

Download PDF File