大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
OCP 19c 1Z0-083認(rèn)證考試題庫(kù)(第4題)-CUUG內(nèi)部學(xué)員版083題庫(kù)解析
4、For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
C. to include specific user tablespaces only when relocating a PDB
D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
E. to exclude a temp tablespace when plugging in a PDB
F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Answer: DF
(解析:B 答案如果把 temp 表空間去掉,則答案是對(duì)的,因?yàn)?system 和 sysaux 表空間是必須的。
您可以使用此子句將多個(gè)模式的數(shù)據(jù)分離為不同的 pdb。例如,當(dāng)您將一個(gè)非 CDB 移動(dòng)到一個(gè) PDB,并且該非 CDB 具有多個(gè)支持不同應(yīng)用程序的架構(gòu)時(shí),可以使用此子句將屬于每個(gè)架構(gòu)的數(shù)據(jù)分離到一個(gè)單獨(dú)的PDB中,假設(shè)每個(gè)架構(gòu)在非CDB中使用了一個(gè)單獨(dú)的表空間。)
The USER_TABLESPACES clause of the CREATE PLUGGABLE DATABASE statement specifies which tablespaces are available in the new PDB.
You can use this clause to specify one of the following options:
List one or more tablespaces to include.
Specify ALL , the default, to include all of the tablespaces.
Specify ALL EXCEPT to include all of the tablespaces, except for the tablespaces listed.
Specify NONE to exclude all of the tablespaces.
)