Which two are true about common objects? (Choose two.)
Which two are true about common objects? (Choose two.)
Common objects can exist in both the CDB$ROOT and an application root, this means that these objects are available at the common level and can be used across multiple pluggable databases (PDBs). However, while they can exist in the CDB$ROOT, users are not allowed to create them there; only Oracle can create such objects in CDB$ROOT. Instead, users are permitted to create common objects within an application root, allowing these objects to be shared among all application PDBs within the application container. This makes options D and F the correct answers.
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.
However F contradicts D...
I think D and F are the correct answers. They do not contradict; You must distinguish here between Oracle supplied objects already present in the root after install and the common objects the user creates. So answer D is ok for already existing objects. And answer F is ok because users are only allowed to create common objects in application root.
Correct answer is C,D
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.
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
CDB root or application root, and can be data linked
F excludes D
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.
by definition, E is wrong, just D is true
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/glossary.html
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.
D - says "exist" not "create" , you cannot create common objects in CDB$ROOT but exist supplied common objects by default , So they can only be created in aplicattion root (F)
For example, AWR data resides in the root. Each PDB uses an object link to point to the AWR data in the root
D eliminates A an F because of "only" and E uses data-links to make it useable
df i think
– Regular PDBs: — Common objects exist in the CDB root only. — Data is stored in the CDB root only. — Or each PDB has a private data copy. — CANNOT be created by users — Can be created by Oracle-supplied users – Application PDBs: Common objects exist in the application root — The object definition exists in the application root only. — Data is stored in the application root only. — Or data is stored in both the application root and the application PDB. — Or data is stored in the application PDB. — Can be created by users
DF were correct answers