Special Summer 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

Examine the statements that use flashback technologies:

1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

2. SELECT * FROM customers AS OF SCN 123456;

3. FLASHBACK TABLE customers TO BEFORE DROP;

4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;

6. ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

Options:

A.

1, 2, 5

B.

1, 3, 6

C.

2, 3, 5, 6

D.

3, 4, 5

Buy Now
Question 2

You take your database backups by using the RMAN media management interface (MMI).

Which two are true about the use of the RMAN MMI? (Choose two.)

Options:

A.

You can use it to create image copies for entire file systems.

B.

You can use it to create image copies for database files.

C.

You can use it to create backup sets for database files.

D.

You can use it to create proxy copies for database files.

E.

You can use it to create proxy copies for entire file systems.

Question 3

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods for recovering the truncated table data? (Choose two.)

Options:

A.

Table Point-in-Time Recovery

B.

Database Point-in-Time Recovery

C.

Tablespace Point-in-Time Recovery

D.

Flashback Database

E.

Flashback Transaction Backout