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

Note! Following 1z0-060 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

Upgrade to Oracle Database 12c Questions and Answers

Question 1

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

Options:

A.

Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

B.

The C##A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C.

The command will create a common user whose description is contained in the root and each PDB.

D.

The schema for the common user C # # A_ADMIN can be different in each container.

E.

The command will create a user in the root container only because the CONTAINER clause is not used.

Buy Now
Question 2

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.)

Options:

A.

to check the database time consumed for the two time periods

B.

to review the change in the initialization parameters between the two runs

C.

to find the resource consumption by SQL statements that are common to both periods

D.

to check the performance improvement and degradation caused during the change

E.

to review the hardware resources used during the two runs

F.

to compare the performance change of top SQL statements for the two runs

Question 3

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

Options:

A.

All users except SYS

B.

All users except SCOTT

C.

All users except SYS and SCOTT

D.

All users except SYS, SYSTEM, and SCOTT