IT Certification exam information exchange, brain dumps discussions sharing.
You are not logged in. Please login or register.
Share Test → Oracle Certifications → 1z0-083 topic 1 question 6
Which two are true about common objects? (Choose two.)
A.
They can be created only in CDB$ROOT.
B.
They can be only metadata-linked in an application container.
C.
They can exist in user-defined schemas only in application containers.
D.
They can exist in CDB$ROOT and an application root.
E.
They can be extended data-linked in CDB$ROOT.
F.
They can be created only in an application root.
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
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
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
– 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
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.
A local user can own a common object. Also, a common user can own a local object, but only
when the object is not data-linked or metadata-linked, and is also neither a metadata link nor
a data link.
D, F -100%
Share Test → Oracle Certifications → 1z0-083 topic 1 question 6
Note: This forum is a platform for users to share insights and discuss exam-related topics. We do not provide authentic exam questions or answers. The content here is contributed by community members and is meant for collaborative learning and discussion purposes only. Users are encouraged to refer to official sources for accurate exam materials.