Which two statements are true?

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you
execute the following command in the root container:

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.

Show Hint

← Previous question

Next question →

Leave a Reply 33

smbd.smth

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

JanK

C – TRUE
To create a common user, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root.

D – TRUE – not tested

Gautam

B is correct as per http://www.toadworld.com/platforms/oracle/b/weblog/archive/2014/04/28/12c-pdb-cannot-share-cdb-s-temporary-tablespace.aspx

E is correct.

Gautam

Ref: http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#BAJECDFH

Why E – When the current container is the root, the CONTAINER clause of the ALTER SYSTEM SET statement controls which PDBs inherit the parameter value being set. The CONTAINER clause has the following syntax:

CONTAINER = { CURRENT | ALL }
The following settings are possible:

•CURRENT, the default, means that the parameter setting applies only to the current container.

When the current container is the root, the parameter setting applies to the root and to any PDB with an inheritance property of true for the parameter.

•ALL means that the parameter setting applies to all containers in the CDB, including the root and all of the PDBs.

Specifying ALL sets the inheritance property to true for the parameter in all PDBs.

Ranjit

BE are wrong.

Only CD can be true

Mohammad Rafiq

B and E appears to be correct.

Domingo

B is false. If a TEMP_TS temporary tablespace is created in each PDB and CDB then the common user c##a_admin is created without errors and will use temp_ts temporary tablespace (local) in the PDB when is connected to PDB.

Tested

michele

I thik CD

Alessandro

rsv1999

Only a common user with the CREATE USER and the SET CONTAINER common privileges can create a common user. A common privilege is a privilege granted across all the PDBs.
A common user with the CREATE USER and SET CONTAINER privilege in the PDB can create a local user in that PDB.

If the container clause is omitted, the default depends on the context. If the common user is connected to the root container the default is CONTAINER=ALL. If the common user is
connected to a PDB the default is CONTAINER=CURRENT.

When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command must exist in every PDB. If none of these are specified, the default
TABLESPACE, TEMPORARY TABLESPACE, and PROFILE for the PDB will be used.

To create a common user, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root.
While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:
DEFAULT TABLESPACE
TEMPORARY TABLESPACE
QUOTA
PROFILE
Hence I would say the correct answers are: A, C

rsv1999

If these objects do not exist in all the containers, the CREATE USER statement fails.

Jai

rsv statement is correct.

SQL> create user c##a_admin1 identified by password default tablespace data_ts
2 quota 100M on test_ts
3 quota 500k on data_ts
4 temporary tablespace temp_ts
5 profile default;
create user c##a_admin1 identified by password default tablespace data_ts
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database PDB1
ORA-00959: tablespace ‘DATA_TS’ does not exist

SQL> create user c##a_admin2 identified by password temporary tablespace temp_ts;
create user c##a_admin2 identified by password temporary tablespace temp_ts
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database PDB1
ORA-00959: tablespace ‘TEMP_TS’ does not exist

SQL> create user c##a_admin1 identified by password;

User created.

Miguel Lima

A, B, E incorrect

C, D Correct

A incorrect based on

http://dbasolved.com/2013/06/29/common-user-vs-local-user-12c-edition/

Miguel Lima

one more reference on this

http://www.oracle.com/technetwork/issue-archive/2014/14-nov/o64ocp12c-2349447.html

J ANTONIO

The schemas for a common user can differ in each container.

For example, if c##dba is a common user that has privileges on multiple containers, then the c##dba schema in each of these containers may contain different objects.

J ANTONIO

C,D

J ANTONIO

http://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CIHGICDD

Yaseen

Answer: C,D

http://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503

CONTAINER Clause

The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values.

To create a common user, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root.

To create a local user, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB.

https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89257

Nagaraj

A & C are the right answers.
The command executes only if all the objects present in root (CDB) and all PDBs.
C##A_ADMIN is same all, available in root (CDB) and in all PDBs.

praveen

Why A is correct?
Schema objects can’t be shared across PDBs.

jhonnyrip

the correct answers are B and E

create user command uses container=current.

praveen

That depends on the scope if you are executing from Root or PDB.

From root – it is ALL

Ans : CD

Peter

Carlos

A) False

https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG754

User-created schema objects owned by common users cannot be shared across PDB boundaries. Schema objects owned by Oracle-created common users are shared throughout the entire CDB.

B) False

https://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503

To create a common user, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root.

While creating a common user, any default tablespace, temporary tablespace, or profile specified using the following clauses must exist in all the containers belonging to the CDB:

C) True

https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-12cr1

Common User : The user is present in all containers (root and all PDBs).

D) True

http://www.oracle.com/technetwork/issue-archive/2014/14-nov/o64ocp12c-2349447.html

common users can create schema objects in a PDB if they have privileges to create schema objects in that PDB; those objects are created in that PDB only

E) False

https://docs.oracle.com/database/121/SQLRF/statements_8003.htm#SQLRF01503

In Oracle Database 12c Release 1 (12.1.0.1), the name of a common user must begin with C## or c## and the name of a local user must not begin with C## or c##.

test1234

C, D

Umaruddin Ansari

B,C are correct
when a common user is created CONTAINER=ALL is default. definition of this common user is available in all pdbs.

scientific trading machine discount

Between me and my husband we’ve owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I’ve settled down to one line of players. Why? Because I was happy to discover how well-designed and fun to use the underappreciated (and widely mocked) Zunes are.

http://toshkoraychevprofitsystemreviews.com/scientific-trading-machine-review

blog

Thanks for a marvelous posting! I quite enjoyed reading it, you happen to be a great author.I will be sure to bookmark your blog and definitely will come back at some point. I want to encourage one to continue your great writing, have a nice holiday weekend!

http://wayneweiglexx74.livejournal.com/1334.html