Exam 1Z0-083 Topic 6 Question 58 Discussion

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2.DEFAULT_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/ orac1e@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 the outcome and why?