Upgrade to Oracle Database 12c - 1Z1-060 Exam Practice Test

Question 1

What are three purposes of the RMAN "FROM" clause?

A. to support PUSH-based active database duplication

B. to support synchronization of a standby database with the primary database in a Data environment

C. To support file restores over the network in a Data Guard environment

D. To support file recovery over the network in a Data Guard environment

E. To support PULL-based active database duplication

Correct Answer: C,D,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

A. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.

B. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
PAYABLE

C. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

D. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
ACCOUNT PAYABLE

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

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?

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

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

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

D. Increasing the value of the JOB_QUEUE_PROCESSES parameter

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

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

Correct Answer: C,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

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?

A. It shows the resource usage for CPU, memory, and I/O in both time periods.

B. It shows the difference in the size of memory pools in both time periods.

C. It detects the top wait events causing performance degradation.

D. It identifies any workload change that caused a performance difference in both time periods.

E. It gives information about statistics collection in both time periods.

F. It detects any configuration change that caused a performance difference in both time periods.

Correct Answer: A,D,F

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

B. The statement results in an error because there are open PDBs.

C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

Correct Answer: D

Question 6

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

B. All the components may be moved from the SYSAUX tablespace.

C. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

D. All the components may be moved into SYSAUX tablespace.

Correct Answer: A,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

B. Oracle Data Pump.

C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

D. Edition-Based Table Redefinition.

E. Online Table Redefinition.

Correct Answer: E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

A. The Oracle database can be created using Oracle Managed Files.

B. The Oracle database will be easier to upgrade in the future.

C. The Oracle database can be created using storage managed by ASM.

D. The Oracle database will be automatically registered as a resource in Oracle Restart.

E. It is the only way to have "automatic restart in place" after instance failure.

Correct Answer: C,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

A. It will detect and advise about chained rows.

B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

C. It may advise the use of online table redefinition for tables in locally managed tablespaces

D. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

E. It may advise the use of segment shrink for free list managed tables.

Correct Answer: A,C,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

You use a recovery catalog for maintaining your database backups.
You execute the following command:

Which two statements are true? (Choose two.)

A. Checks are performed for logical corruptions.

B. Backup sets containing both data files and archive logs are created.

C. Checks are performed to confirm whether all database files exist in correct locations

D. Checks are performed for physical corruptions.

E. Corrupted blocks, if any, are repaired.

Correct Answer: C,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 11

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

A. Take the user data tablespace offline.

B. Place the root container in the nomount stage.

C. Ensure that HR_PDB is open.

D. Place the root container in ARHCHIVELOG mode.

Correct Answer: D

Oracle Upgrade to Oracle Database 12c - 1Z1-060 Exam Practice Test

Latest Update

Useful Links

Contact Us