Q55 What will be outcome and why?

Posted on by Tran Anh

Q55. Examine this configuration:
1. CDB1 is a container database.
2. DEFAUTL_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1.
4. APP_PDB1 is an application PDB contained in APP_ROOT
5. COMPANYAPP is an application contained in APP_ROOT
6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.

You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;
System altered.

SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE ‘1.0’ TO ‘2.0’;
Pluggable database altered.

SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL);
Table altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO ‘2.0’;
Pluggable database altered.

SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.

SQL> desc emp;
Name Null? Type
—- —— ——–
ENO NUMBER
ENAME VARCHAR2(20)

SQL> SELECT * FROM emp;

ENO ENAME
—- ——-
100 Alan
200 Ben

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;

What will be outcome and why?

  • A. It will return an error because the SYNC operation is now allowed when constraints are added to common objects.
  • B. It will return an error because EMP.SAL is empty in APP_ROOT
  • C. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.
  • D. It will return an error because EMP is not empty in APP_ROOT.
  • E. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.
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