1z0-083 topic 1 question 99

We can verify that, by default, neither PDB$SEED nor APP SEED create temporary tablespace (at least that's how it seems to work in 19.3.0)

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TOYS_ROOT                      READ WRITE NO
         4 TOYS_ROOT$SEED                 READ WRITE NO
         5 PDB1                           READ WRITE NO
         6 HR_ROOT                        READ WRITE NO
         7 OPERATIONS                     READ WRITE NO
         8 RESEARCH                       READ WRITE NO

SQL> select name from v$pdbs where con_id not in (select con_id from cdb_temp_files);
NAME
---------------
PDB$SEED
TOYS_ROOT$SEED

I think A is correct (CDB$ROOT + pdb1 + pdb2 + app_root + app_pdb1 + app_pdb2 = 6)

Agree, i dont see any tempfiles in 19c.

SQL> select con_id, file_name from cdb_temp_files;

    CON_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
         1
E:\ORADATA\CEQTESTDB\DATAFILE\O1_MF_TEMP_JKT0HX3S_.TMP

         3
E:\ORADATA\CEQTESTDB\0D866E7293684B4AB3DFA708272C5DB4\DATAFILE\O1_MF_TEMP_JKT2N9
BQ_.DBF

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 EQTESTDB                       READ WRITE NO

D, 8 tested.
show pdbs
CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO       
         3 APP1                           READ WRITE NO       
         4 APP1$SEED                      READ WRITE NO       
         5 PDB2                           READ WRITE NO       
         6 APPPDB1                        READ WRITE NO       
         7 APPPDB2                        READ WRITE NO       
         8 PDB1                           READ WRITE NO       

select count(1) from v$datafile where name like '%undo%';
  COUNT(1)
----------
         8

D is the right answer

Choosing D -

  1* select sys_context('userenv', 'db_name') db_name, property_name, property_value from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE'
SYS@CDB1:CDB1>/

DB_NAME    PROPERTY_NAME                  PROPERTY_VALUE
---------- ------------------------------ ------------------------------
PDB$SEED   DEFAULT_TEMP_TABLESPACE        TEMP

Did you try alter session to PDB$SEED then query for the temp file? The following is what I found in version 19.14.0.0
SQL> alter session set container=PDB$SEED;

Session altered.

SQL> SELECT con_id, name FROM v$containers;

    CON_ID NAME
---------- ----
         2 PDB$SEED

SQL> SELECT con_id,tablespace_name,file_name FROM cdb_temp_files ORDER BY con_id;

    CON_ID TABLESPACE_NAME                FILE_NAME
---------- ------------------------------ ---------
         2 TEMP                           /dbbssdev_data/oradata/CBSSDEV/datafile/temp012022-05-04_18-20-27-034-PM.dbf

I think the SEED's temp tablespace is hidden from CDB, but it's still existed.
I will choose D, eight for this.

6 only in 19.13
select TABLESPACE_NAME,file_name from cdb_temp_files;

D is the right answer

>> Therefore, the CDB root and every PDB, application root, and application PDB has its own default temporary tablespace.
1+1*2+1+1*2=?