Q12 Which table or set of tables will exist after the Flashback operation has completed?

Posted on by Tran Anh

Q12. Examine in this configuration:

1. CDB1 is a container database.
2. APP_ROOT is an application root in CDB1.
3. APP_PDB1 is an application PDB in APP_ROOT.
4. FLASHBACK DATABASE is ON .
You execute these commands:
$ sqlplus sys/oracle_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$database;
CURRENT_SCN
———–
2074756
SQL> CREATE TABLE cdb1_tab(c1 NUMBER);
Table created.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> CREATE TABLE app_root_tab(c1 NUMBER);
Table created.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> CREATE TABLE app_pdb1_tab(c1 NUMBER);
Table created.
SQL> conn / as sysdba
Connected.
SQL> ALTER PLUGGABLE DATABASE app_root close;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;
Flashback complete.

Which table or set of tables will exist after the Flashback operation has completed?

  • A. CDB1_TAB only
  • B. CDB1_TAB and APP_PDB1_TAB
  • C. none of the tables, because all three tables will be dropped
  • D. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
  • E. CDB1_TAB and APP_ROOT_TAB
Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận