Exam 1z0-083 topic 1 question 6 discussion

READ THIS: A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. You can create most schema objects—such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF D: they can exist in CDB$ROOT and application root. F: they can be created only in application root.

Correct answer is C,D

F is wrong since its says "only"

Overview of Common and Local Objects in a CDB A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-8B4B4F8B-1C2B-42C3-BE77-E9AA25CA397A

For me F is false "F. They can be created only in an application root." --> for "normal user", but not for "oracle developers", that's why they exists! :-) we should go for D, E.

common object An object that resides either in the CDB root or an application root that shares either data (a data-linked common object) or metadata (a metadata-linked common object). All common objects in the CDB root are Oracle-supplied. A common object in an application root is called an application common object.

DE is correct F is incorrect - becuase not only in an application root https://docs.oracle.com/en/database/oracle/oracle-database/23/multi/glossary.html#GUID-1C63428A-905A-4918-95AA-F3BBA3D2B825:~:text=Parent%20topic%3A%20Glossary-,common%20object,in%20an%20application%20root%20is%20called%20an%20application%20common%20object.,-Parent%20topic%3A common object An object that resides either in the CDB root or an application root that shares either data (a data-linked common object) or metadata (a metadata-linked common object). All common objects in the CDB root are Oracle-supplied. A common object in an application root is called an application common object.

https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-the-multitenant-architecture.html#GUID-8B4B4F8B-1C2B-42C3-BE77-E9AA25CA397A "A common object is *defined* in either the CDB root or an application root" (D: TRUE) "Oracle Database does not support creation of common objects in CDB$ROOT" + "You can create most schema objects . . . as common objects in an application root" (F:TRUE)

F is wrong. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/overview-of-the-multitenant-architecture.html#GUID-C7F5F6BD-E905-4402-A685-D4A79CF565EA Oracle recommends that you do not add common objects to the root or modify Oracle-supplied schemas in the root. However, you can create common users and roles for database administration.

How is it possible to be D and F? D - he says it is possible to create in CDB ROOT and in the application, in F he says it is only possible in the application root, I think people are mistaken. The correct statement is D and E.

I believe D,F correct. erials comments make sense

https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/application-containers2.html#GUID-CA425AC1-CA1C-498C-BC09-AD246BA67346

Correct: D,F A. Flase. Oracle Database does not support creation of common objects in CDB$ROOT. Only Oracle can create common objects in root B. False. Can be linked to metadata, data and data extended in Application Containers and Data or metadata in CDB$ROOT. C. False.Can exists in the CDB$ROOT and the Application Containers(not ONLY in Aplication Containers) but can only be CREATED in Application Containers(See A), only Oracle can create common objects that EXIST in the CDB$ROOT D. True. A common object is defined in either the CDB$ROOT(by oracle) or an application root(by users). E. False. Can be extended data liked only in application root, in CDB$root can be metadata linked and data(object) linked F. True. Database-supplied common objects are defined in CDB$ROOT and cannot be changed.

D eliminates A an F because of "only" and E uses data-links to make it useable

CDB root or application root, and can be data linked

F excludes D

df i think