Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following 1z0-063 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: Advanced Administration Questions and Answers

Question 1

Users report this error message when inserting rows into the orders table:

ERROR at line1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

Options:

A.

drop and re-create the index

B.

coalesce the order.ind index

C.

coalesce the indexes tablespace

D.

perform an on line table rebuild using dbms_redefinition

E.

rebuild the index online moving it to another tablespace that has enough free space for the index

Buy Now
Question 2

You want to move your existing recovery catalog to another database.

Examine the steps:

1) Export the catalog data by using the Data Pump Export utility in the source database.

2) Create a recovery catalog user and grant the necessary privileges in the target database.

3) Create a recovery catalog by using the CREATE CATALOG command.

4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.

6) Connect to the destination database.

7) Connect as CATALOG to the destination recovery catalog schema.

Identify the option with the correct sequence for moving the recovery catalog.

Options:

A.

1, 6, 4

B.

2, 3, 7, 5

C.

1, 2, 6, 4

D.

1, 2, 3, 6, 5

Question 3

Examine the output:

SQL> ARCHIVE LOG LIST

Database log modeArchive Mode

Automatic archival Enabled

Archive DestinationUSE_DB_RECOVERY_FILE_DEST

Oldest online log sequence376

Next log sequence to archive378

Current log sequence378

Which three types of files are automatically placed in the fast recovery area? (Choose three.)

Options:

A.

Flashback data archives (FDA)

B.

Archived redo log files

C.

Control file autobackups

D.

Server parameter file (SPFILE)

E.

Recovery Manager (RMAN) backup pieces