New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Sure Pass Exam 1z0-067 PDF

Page: 5 / 10
Total 263 questions

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 17

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Options:

A.

By default, EM express is available for a database after database creation.

B.

You can use EM express to manage multiple databases running on the same server.

C.

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D.

You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

E.

You can create and configure pluggable databases by using EM express.

Question 18

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

The following are the possible steps to accomplish this task:

1. Place all the user-defined tablespace in read-only mode on the source database.

2. Upgrade the source database to a 12c version.

3. Create a new PDB in the target container database.

4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

5. Copy the associated data files and export the dump file to the desired location in the target database.

6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify the correct order of the required steps.

Options:

A.

2, 1, 3, 4, 5, 6

B.

1, 3, 4, 5, 6, 7

C.

1, 4, 3, 5, 6, 7

D.

2, 1, 3, 4, 5, 6, 7

E.

1, 5, 6, 4, 3, 2

Question 19

Which two statements are true about roles in multitenant container databases (CDBs)?

Options:

A.

Local roles can be granted to local and common users.

B.

A common role can be granted only to a common user.

C.

A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

D.

A common role can be granted only system privileges.

E.

The root container can have both local and common roles.

F.

A local role can be assigned to a common role in a PDB.

Question 20

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Options:

A.

SQL Performance Analyzer

B.

SQL Access Advisor

C.

SQL Tuning Advisor

D.

Automatic Workload Repository (AWR) report

E.

Automatic Database Diagnostic Monitor (ADDM)

Page: 5 / 10
Total 263 questions