Q128. Examine these queries and their output: You want to recover PDB1 to Restore Point R1. How do you achieve this?

Đăng vào Tác giả Datalinks.vn 1
Share
Tweet
Share
Pin
0 Shares

Q128. Examine these queries and their output:

word image 5758 1

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

  • A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
  • B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
  • C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
  • D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
  • E. This cannot be done due to the lack of a clean restore point.
Share
Tweet
Share
Pin
0 Shares

Xem thêm:

  1. Q3. Examine these queries and their output After a system crash, an instance restart and an attempted opening of the PDBs result in
  2. Q13. Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
  3. Q112. Examine this output: In which two scenarios is incomplete recovery required?
  4. Q128 Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?
  5. Q46. The HR_ROOT Application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
  6. Q84. PDB1 and PDB2 are pluggable databases in CDB1
  7. Q86. A container database (CDB) contains two pluggable databases PDB1 and PDB2
  8. Q28 Which Oracle Flashback feature could be used to recover the data?
  9. Q92 Choose the minimum required steps in the correct order to recover the database
  10. Q124. Which two are true about Recovery Manager (RMAN) diagnostic message output?

Datalinks.vn

Hello các bạn, mình là Dương Nguyễn tác giả của blog này. Với gần 20 năm làm việc trong lĩnh vực CNTT, VT trong và ngoài nước, mong muốn được chia sẻ kiến thức và kinh nghiệm về database với các bạn đam mê và quan tâm đến lĩnh vực này. Đặc biệt là #OracleDatabase hoặc luyện thi #OCP database admin. Warren Buffett từng nói "Muốn đi nhanh hãy đi một mình, muốn đi xa hãy đi cùng nhau". Các bạn cần người đồng hành thì alo tôi nhé. Call/Zalo: 0765 871 888. Thanks you !.....
0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest

1 Bình luận
Phản hồi nội tuyến
Xem tất cả bình luận
Datalinks.vn
Tác giả
Datalinks.vn
2 ngày trước

Answer: D

Without a clean restore point, the SQL option is unavailable.
RMAN offers the ability to flashback a PDB to a specific restore point directly. In this case, you can:
Connect to CDB$ROOT with RMAN.
Ensure the R1 restore point exists in the RMAN repository.
Execute the command FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1.

0
Trả lời