Ace Oracle 1Z0-060 Certification with Actual Questions Oct 26, 2022 Updated [Q68-Q87]

NEW QUESTION 68
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:

NEW QUESTION 69
Which three statements are true about adaptive SQL plan management?

NEW QUESTION 70
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI)prompts you toenter the path of the Inventory directory and alsotospecify an operating system group name.
Which statement is true?

NEW QUESTION 71
Which statement is true concerning dropping a pluggable database (PDB)?

NEW QUESTION 72
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

NEW QUESTION 73
Which two statements are true about the Oracle Direct Network File system (DNFS)?

NEW QUESTION 74
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

NEW QUESTION 75
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

NEW QUESTION 76
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?

NEW QUESTION 77
Which two statements are true about the RMAN validate database command?

NEW QUESTION 78
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)

NEW QUESTION 79
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?

NEW QUESTION 80
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

NEW QUESTION 81
What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a “CREATE DATABASE” statement?

NEW QUESTION 82
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?

NEW QUESTION 83
An administrator account is granted the CREATE SESSIONand SET CONTAINERsystem privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

NEW QUESTION 84
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)

NEW QUESTION 85
You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

NEW QUESTION 86
Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)

NEW QUESTION 87
You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay?
(Choose three.)