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

Question 16

You execute the following commands to audit database activities:

Which statement is true about the audit record that generated when auditing after instance restarts?

A.One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B.One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C.One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D.One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

E.One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

Question 17

While investigating a possible security breach, you realized that some audit records were not retrieved when the unified_audit_trail view was queried.
How can you ensure that all available audit records are returned when the audit trail is queried?

A.Enable the OS auditing option in the database before querying the unified_audit_trail view.

B.Configure the immediate write mode using the dbms_audit_mgmt.set_audit_trail_property procedure before querying the unified_audit_trail view.

C.Execute the dbms_audit_mgmt.flush_unified_audit_trail procedure before querying the UNIFIED_AUDIT_TRAIL View.

D.Query the v$unified_audit_trail view rather than the unified_audit_trail view.

Question 18

You must track all transactions that modify certain tables in the SALES schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

A.Enable supplemental logging for the database.

B.Specify undo retention guarantee for the database.

C.Create a Flashback Data Archive in the tablespace where the tables are stored.

D.Create a Flashback Data Archive in any suitable tablespace.

E.Enable Flashback Data Archiving for the tables that require tracking.

Question 19

The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

A.2, 4, 5

B.2, 1, 4, 3, 5

C.1, 2, 3, 4, 5

D.1, 2, 4, 5

Question 20

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
* Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
* Version: Oracle Database 12c Release 1 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A.Transportable database

B.Transportable tablespace

C.Data Pump full export/import

D.The DBMS_PDB package

E.RMAN

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 16

Question 17

Question 18

Question 19

Question 20

Download PDF File