Your multitenant container database (CDB) contains some pluggable databases (PDBs), you
execute the following command in the root container:
Which two statements are true?
A.
Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
B.
The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
C.
The command will, create a common user whose description is contained in the root and each
PDB.
D.
The schema for the common user C # # A_ADMIN can be different in each container.
E.
The command will create a user in the root container only because the container clause is not
used.
Explanation:
* Example, Creating Common User in a CDB
This example creates the common user c##testcdb.CREATE USER c##testcdb IDENTIFIED BY password
DEFAULT TABLESPACE cdb_tbs
QUOTA UNLIMITED ON cdb_tbs
CONTAINER = ALL;
A common user’s user name must start with C## or c## and consist only of ASCII characters. The
specified tablespace must exist in the root and in all PDBs.
* CREATE USER with CONTAINER (optional) clause
/ CONTAINER = ALL
Creates a common user.
/ CONTAINER = CURRENT
Creates a local user in the current PDB.
* CREATE USER
* The following rules apply to the current container in a CDB:
The current container can be CDB$ROOT (root) only for common users. The current container
can be a particular PDB for both common users and local users.
The current container must be the root when a SQL statement includes CONTAINER = ALL.
You can include the CONTAINER clause in several SQL statements, such as the CREATE USER,
ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
Only a common user with the commonly granted SET CONTAINER privilege can run a SQL
statement that includes CONTAINER = ALL.
http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_8003.htm#SQLRF54751
If you omit this clause and the current container is a PDB, then CONTAINER = CURRENT is the default. If you omit this clause and the current container is the root, then CONTAINER = ALL is the default.
create table only in current container
So CD
hi is it right CD ? ,
I need your help next week I have exam.
CD
“B” is wrong. The specified tablespace must exist in the root and in all PDBs. If the tablespace temporary exists in all containers, we can not affirm that the commum user will be able to use temporary tablespace only in root.
“D” is correct. The common user can create different objects in each container.
“C” is correct.
Scope for Names and Privileges in PDBs
PDBs have separate namespaces, which has implications for the following structures:
Schemas
A schema contained in one PDB may have the same name as a schema in a different PDB. These two schemas may represent distinct local users, distinguished by the PDB in which the user name is resolved at connect time, or a common user (see “Overview of Common and Local Users in a CDB”).
Objects
An object must be uniquely named within a PDB, not across all containers in the CDB. This is true both of schema objects and nonschema objects. Identically named database objects and other dictionary objects contained in different PDBs are distinct from one another.
An Oracle Database directory is an example of a nonschema object. In a CDB, common user SYS owns directories. Because each PDB has its own SYS schema, directories belong to a PDB by being created in the SYS schema of the PDB.
During name resolution, the database consults only the data dictionary of the container to which the user is connected. This behavior applies to object names, the PUBLIC schema, and schema names.
CD
C D
CD