Exam 1z0-083 topic 1 question 3 discussion

B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB

i double checked B again. B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB ? ____________________________________________________________________________________ Its definitely FALSE Because to exclude some tablespaces we can use for example USER_TABLESPACES=ALL EXCEPT('tbs1','tbs4','tbs5'); in this case all tablespaces will be included except tbs1, tbs4 and tbs5 Howver This clause does not apply to the SYSTEM, SYSAUX, or TEMP tablespaces. so you should not include these tablespaces in a tablespace list for this clause. If i want to translate Answer B into an example, it should look like that: USER_TABLESPACES=ALL EXCEPT('system','sysaux','emp'); Apparently something like that is not allowed, therefor Answer B is wrong Correct answers are D, F

B and D correct. F incorrect based on my reading of the doc - "This clause lets you specify the tablespaces to be made available in the new PDB. The SYSTEM, SYSAUX, and TEMP tablespaces are available in all PDBs and cannot be specified in this clause. " https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC as explained here: https://docs.google.com/document/d/1EObi-yvTmyduKdPo7TE_YCLdQmjgpZwwr6Fg2_DPPVM/edit?usp=sharing

https://oracle-base.com/articles/12c/multitenant-user_tablespaces-clause-12c

F is wrong. You don't have user tablespaces in PDB$SEED.

from https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC, there is no user_tablespaces in syntax. F is wrong

B and D correct. F incorrect based on my reading of the doc - "This clause lets you specify the tablespaces to be made available in the new PDB. The SYSTEM, SYSAUX, and TEMP tablespaces are available in all PDBs and cannot be specified in this clause. " https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC

as explained here: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC

I think BD as well. I looked in the syntax diagrams and the user_tablespace clause is also valid for answer F. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC

https://oracle-base.com/articles/12c/multitenant-user_tablespaces-clause-12c Remember, the SYSTEM, SYSAUX and TEMP tablespaces are always included.

Correct: B,D A. False. Default tablespaces are defined with the DEFAULT_TABLESPACE clause not with USER_TABLESPACE clause. B. True. Specify NONE in USER_TABLESPACE clause to make only the SYSTEM, SYSAUX, and TEMP tablespaces available in the new PDB. C. False. The USER_TABLESPACE clause is available for use in 3 scenarios: When creating a PDB from SEED, When cloning an existing PDB or When creating a PDB from XML File D. True. When you move a non-CDB to a PDB, and the non-CDB had several schemas that each supported a different application, you can use this clause to separate the data belonging to each schema into a separate PDB. This technique assumes that each schema used a separate tablespace in the non-CDB. E. False. The SYSTEM, SYSAUX, and TEMP tablespaces always are available in all PDBs and cannot be specified in this clause F. False. When create PDB from seed no users tablespaces are defined in seed container

Hello. Answer F is false. Database cdb@seed have only dictionary structures. This database have only system tablespaces (SYSTEM, SYSAUX ...). In this time we omit user_tablespace clause. https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13850 This is tricky question. :). Corect are B and D.

B= with NONE D=Specify tablespace to make the tablespace available in the new PDB

I found https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC very helpfull. See user_tablespaces_clause

This one is tricky, and I found 3 correct answers. The USER_TABLESPACE clause is available for use in 3 scenarios. A. When creating a PDB from SEED. B. When cloning an existing PDB. C. When creating a PDB from XML File USER_TABLESPACE has 4 choices: (This clause lets you specify the tablespaces to be made available in the new PDB. The SYSTEM, SYSAUX, and TEMP tablespaces are available in all PDBs and cannot be specified in this clause.) 1. Specify tablespace to make the tablespace available in the new PDB. You can specify more than one tablespace in a comma-separated list. 2. Specify ALL to make all tablespaces available in the new PDB. This is the default. 3. Specify ALL EXCEPT to make all tablespaces available in the new PDB, except the specified tablespaces. 4. Specify NONE to make only the SYSTEM, SYSAUX, and TEMP tablespaces available in the new PDB. A. is wrong. Default tablespaces are defined with the DEFAULT_TABLESPACE clause. B is correct. See point 4 for USER_TABLESPACE. C is wrong. See description before point 1. D is correct. See point 1. E is wrong. See description before point 1. F is correct. See point 1.

I'd say B is correct. The documentation says: "Specify NONE to exclude all tablespaces." and later "This clause does not apply to the SYSTEM, SYSAUX, or TEMP tablespaces." That is, when specifying NONE, only SYSTEM, SYSAUX and TEMP will be included. And that's what answer B says. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-pdb-creation.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59

assuming it should be "PDB seed" in F : SQL> create pluggable database pdb4 admin user pdbadmin identified by pdbadmin USER_TABLESPACES=('USERS'); Pluggable database created. Not much sense, but it works.