Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-062

Free Oracle 1Z0-062 Exam Questions (page: 7)

Page 7 of 87
PDF with 419 Questions

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:

  1. 2, 4, 5
  2. 2, 1, 4, 3, 5
  3. 1, 2, 3, 4, 5
  4. 1, 2, 4, 5

Answer(s): B

Explanation:

* Evolving SQL Plan Baselines

* 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1. Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function. This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.



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 DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= `/dev/flash_device_1 `, ' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

  1. Set DB_FLASH_CACHE_ZISE = 64G.
  2. Set DB_FLASH_CACHE_ZISE = 64G, 64G
  3. Set DB_FLASH_CACHE_ZISE = 128G.
  4. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Answer(s): B

Explanation:

* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart Flash Cache" area. In previous releases only one file|device could be defined. DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache" /dev/sda ­ size 32G
/dev/sdb ­ size 32G
/dev/sdc ­ size 64G
New view V$FLASHFILESTAT ­ it's used to determine the cumulative latency and read counts of each file|device and compute the average latency



Identify three valid methods of opening, pluggable databases (PDBs).

  1. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
  2. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
  3. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
  4. ALTER DATABASE PDB OPEN issued from the root
  5. ALTER DATABASE OPEN issued from that PDB
  6. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
  7. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Answer(s): A,E,G

Explanation:

E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment.
AG: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the default unless a PDB being opened belongs to a CDB that is used as a physical standby database, in which case READ ONLY is the default. You can specify which PDBs to modify in the following ways:
List one or more PDBs.
Specify ALL to modify all of the PDBs.
Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed.



You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)

  1. Increasing the priority of the job class to which the job belongs
  2. Increasing the job's relative priority within the Job class to which it belongs
  3. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
  4. Moving the job to an existing higher priority scheduler window with the same schedule and duration
  5. Increasing the value of the JOB_QUEUE_PROCESSES parameter
  6. Increasing the priority of the scheduler window to which the job belongs

Answer(s): B,C

Explanation:

B: Job priorities are used only to prioritize among jobs in the same class.
Note: Group jobs for prioritization
Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.
C: Set resource allocation for member jobs
Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.



Viewing page 7 of 87



Post your Comments and Discuss Oracle 1Z0-062 exam prep with other Community members:

1Z0-062 Exam Discussions & Posts