Pre-Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following 1z0-062 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

Oracle Database 12c: Installation and Administration Questions and Answers

Question 1

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

Options:

A.

Put all readonly tablespaces in read write mode

B.

Recompile all invalid objects

C.

Set the compatible parameter to 12.1.0.1

D.

Gather dictionary statistics

E.

Empty all user recycle bins

Buy Now
Question 2

Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

Options:

A.

An extent contains data blocks that are always physically contiguous on disk.

B.

An extent can span multiple segments.

C.

Each data block always corresponds to one operating system block.

D.

It is possible to have tablespaces of different block sizes.

E.

A data block is the smallest unit of I/O in data files.

Question 3

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:

SQL > CREATE UNDO TABLESPACE undotb01

DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;

What is the result?

Options:

A.

It executes successfully and creates an UNDO tablespace in HR_PDB.

B.

It falls and reports an error because there can be only one undo tablespace in a CDB.

C.

It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D.

It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E.

It executes successfully but neither tablespace nor the data file is created.