Which two are true about common objects? (Choose two.)

Question

Options

• AThey can be created only in CDB$ROOT.
• BThey can be only metadata-linked in an application container.
• CThey can exist in user-defined schemas only in application containers.
• DThey can exist in CDB$ROOT and an application root.
• EThey can be extended data-linked in CDB$ROOT.
• FThey can be created only in an application root.

• A
  5% (3)
• B
  12% (7)
• C
  2% (1)
• D
  78% (45)
• E
  3% (2)

Explanation

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

No community discussion yet for this question.