Oracle 1z0-060 Exam Dumps

Question 6 of 40

You execute a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the

OCP schema.

was enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.

RECYCLE_BIN -

What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.

Recover the table using traditional Tablespace Point In Time Recovery.

Recovery the table using Database Point In Time Recovery.

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

Correct Answer: A

To recover the contents of the OCA.EXAM_RESULTS table to the OCP schema, use the FLASHBACK TABLE command since the FLASHBACK ANY TABLE system privilege has been granted. The quickest way is to execute the command as SYSTEM to rename the table to the intended schema and name. Thus, the appropriate command is FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS.

Question 7 of 40

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?

Increasing the priority of the job class to which the job belongs

Increasing the job's relative priority within the Job class to which it belongs

Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

Moving the job to an existing higher priority scheduler window with the same schedule and duration

Increasing the value of the JOB_QUEUE_PROCESSES parameter

Increasing the priority of the scheduler window to which the job belongs

Correct Answer: A, C

To reduce the elapsed time for an important database scheduler job, there are two effective actions you can take. First, increasing the priority of the job class to which the job belongs will ensure that this job class is given preference over others, optimizing resource allocation and reducing waiting time. Second, increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window will provide the jobs in that class with more resources, which can significantly diminish the job's elapsed time.

Question 8 of 40

You execute the following commands to audit database activities:

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

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.

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.

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.

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.

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

Correct Answer: E

When the given commands are executed, the audit settings ensure that one audit record is created for the entire session if JOHN successfully executes a SELECT, INSERT, or DELETE command on a table. This record contains the information necessary to document the actions taken. Specifically, the setting 'BY SESSION' means that a single record is created per session instead of per statement, and the audit trail includes extended details such as the SQL text and execution plan.

Question 9 of 40

To enable the Database Smart Flash Cache, you configure the following parameters:

DB_FLASH_CACHE_FILE = /dev/flash_device_1 , /dev/flash_device_2

DB_FLASH_CACHE_SIZE=64G -

What is the result when you start up the database instance?

It results in an error because these parameter settings are invalid.

One 64G flash cache file will be used.

Two 64G flash cache files will be used.

Two 32G flash cache files will be used.

Correct Answer: A

Setting multiple flash cache devices should be done by specifying the flash cache size for each device separately in the DB_FLASH_CACHE_SIZE parameter, such as 64G,64G. The current configuration will result in an error because it does not correctly specify the sizes for multiple devices.

Question 10 of 40

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

ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

ALTER DATABASE PDB OPEN issued from the root

ALTER DATABASE OPEN issued from that PDB

ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Correct Answer: A, D, G

To open a pluggable database (PDB), there are specific commands that must be issued from either the root container or the PDB itself. The command 'ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root' is valid and can be used to open all PDBs from the root container. The command 'ALTER DATABASE PDB OPEN issued from the root' is also valid as it allows a specific PDB to be opened from the root container. The command 'ALTER PLUGGABLE DATABASE OPEN issued from that PDB' is valid as well because you can issue the command directly from within the PDB you wish to open. The other options are either incorrect syntax or issued from inappropriate contexts.