Oracle Database Administration from Zero to Hero - Querying Container Data Objects

This lecture covers container data objects, explaining their role in multi-tenant environments. It details how common users access these objects, modify their attributes, and restrict data visibility. The lecture also discusses applying attributes to specific objects and resetting them. Key concepts include container data objects, user access, and attribute management.

What are container data objects primarily used for?

• Encrypting database entries

• Managing network connections

• Providing information about objects in multiple containers

• Storing user credentials

Which column is common in container data objects to identify different containers?

• Container Name

• Container ID

• Container Type

• Container Status

How do common users view data in container data objects by default?

• They see data from the root container only

• They see data from the seed container only

• They see data from all containers

• They see data from the current container only

What must be changed to modify the default behavior of a common user accessing container data objects?

• Database schema

• Container data attribute

• User password

• User role

How can a common user be restricted to view data from specific PDBs?

• By modifying the user's role

• By changing the user's password

• By setting the container data attribute to a list of PDBs

• By altering the database schema

What does the ALTER USER statement do in the context of container data attributes?

• It changes the user's password

• It modifies the user's role

• It manages the visibility of container data objects

• It deletes the user account

What happens if you use ALTER USER SET CONTAINER DATA without specifying PDBs?

• It adds all PDBs to the visibility list

• It removes all PDBs from the visibility list

• It overwrites the existing visibility settings

• It does nothing

How can container data attributes be applied to specific objects?

• By altering the user's role

• By modifying the database schema

• By changing the user's password

• By using the FORECLOSE clause in ALTER USER

What is the difference between V_dularscience session and V Dual Science session?

• Both are internal objects

• Both are synonyms

• V_dularscience session is a synonym, V Dual Science session is the internal object

• V_dularscience session is the internal object, V Dual Science session is a synonym

Which view can be queried to obtain information about container data attributes in a multi-tenant environment?

• SYS_CONTAINER_DATA

• CDB_CONTAINER_DATA

• USER_CONTAINER_DATA

• PDB_CONTAINER_DATA