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

Question 131

Which three statements are true about SQL plan directives?

A.They instruct the optimizer to create only column group statistics.

B.They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

C.They are used to gather only missing statistics.

D.Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

E.They are tied to a specific statement or SQL ID.

F.They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

Question 132

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDBand 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.tmpfile 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.

Question 133

On your Oracle Database, you issue the following commands to create indexes:
SQL >CREATE INDEX oe.ord_customer_ix1ON or-orders (customer_id, sales_rep_id) INVISIBLE;
SQL>CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?

A.Only the ORD_CUSTOMER_IX1index created.

B.Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.

C.Both the indexes are created:however, only ORD_CUSTOMERS_IX1is used by the optimizer for queries on the ORDERS table.

D.The ORD_CUSTOMER_IX1index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.

E.Both the indexes are created and used by the optimizer for queries on the ORDERS table.

Question 134

You find this query being used in your Oracle12c database:

Which method a used by the optimizer to limit the rows being returned?

A.A TOP-N query is created to limit the rows to 20 percent of the total rows

B.A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

C.All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

D.A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

Question 135

Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

A.It utilizes the OS file system cache.

B.A traditional NFS mount is not required when using Direct NFS.

C.Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

D.Direct NFS is available only in UNIX platforms.

E.Direct NFS can load-balance I/O traffic across multiple network adapters.

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 131

Question 132

Question 133

Question 134

Question 135

Download PDF File