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

Question 11

In your database, you want to ensure that idle sessions that are blocking active sessions are automatically terminated after a specified period of time.
How would you accomplish this?

A.Setting a metric threshold

B.Implementing Database Resource Manager

C.Enabling resumable timeout for user sessions

D.Decreasing the value of the IDLE_TIME resource limit in the default profile

Question 12

You execute the following PL/SQL:

Which two statements are true?

A.Fine-Grained Auditing (FGA) is enabled for the PRICEcolumn in the PRODUCTStable for SELECT statements only when a row with PRICE > 10000is accessed.

B.FGA is enabled for the PRODUCTS.PRICEcolumn and an audit record is written whenever a row with PRICE > 10000is accessed.

C.FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICEcolumn.

D.FGA is enabled for the PRICEcolumn of the PRODUCTStable and the SQL statements is captured in the FGA audit trial.

Question 13

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1' ,'/dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZEbe configured to use both devices?

A.Set DB_FLASH_CACHE_SIZE = 64G.

B.Set DB_FLASH_CACHE_SIZE = 64G, 64G

C.Set DB_FLASH_CACHE_SIZE = 128G.

D.DB_FLASH_CACHE_SIZEis automatically configured by the instance at startup.

Question 14

You are administering a database stored in Automatic Storage Management (ASM).
You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

A.Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

B.Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

C.Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

D.Use the MKDG command to restore the disk group with the same configuration as the backed- up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

E.Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

F.Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

Question 15

You areconnected using SQL* Plus to amultitenant container database (CDB)with SYSDBA privileges and executethefollowing sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

A.If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

B.It succeeds because the PDB_ADMIN user has the required privileges.

C.It fails because common users are unable to use the SET CONTAINER statement.

D.It fails because local users are unable to use the SET CONTAINER statement.

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 221CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 184Nutanix.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