You work as a database administrator for Certkiller .com. You have two database,
SALES and HR; created ion the same machine using Oracle database 120g. For the
SALES database, the initialization parameter COMPTIBLE is set to 9.2.0 and for
the HR database, COMPATIBLE is set to 10.0.0. Thesales_tbstablespaceiscreatein
the SALES database as follows:
CREATE TABLESPACEsales_tbsDATAFILE '/ Certkiller / Certkiller data/sales_tbs.dbf'
SIZE50M EXTENT MANAGEMENT LOCAL;
Thehr_tbstablespacecreated in the HR database is as follows:
CREATIVE TABLESPACEhr_tbsDATAFILE'/ Certkiller / Certkiller data/hr_tbs.dbf' SIZE 50M
Which two statements are correct in this scenario?
A. Hr_tbsis abigfiletablespace.
B. Abigfiletablespacecannot be created in the SALES database
C.All tablespaces in HR database will be locally managed by default.
D.Sales_tbsandhr_tbstablespaces can share the same data file.
E.All the tablespaces in the SALES database will be dictionary managed by default.
Answer: B, E
怎么看出sales的默认是字典管理表空间? 我觉得E不对
SALES and HR; created ion the same machine using Oracle database 120g. For the
SALES database, the initialization parameter COMPTIBLE is set to 9.2.0 and for
the HR database, COMPATIBLE is set to 10.0.0. Thesales_tbstablespaceiscreatein
the SALES database as follows:
CREATE TABLESPACEsales_tbsDATAFILE '/ Certkiller / Certkiller data/sales_tbs.dbf'
SIZE50M EXTENT MANAGEMENT LOCAL;
Thehr_tbstablespacecreated in the HR database is as follows:
CREATIVE TABLESPACEhr_tbsDATAFILE'/ Certkiller / Certkiller data/hr_tbs.dbf' SIZE 50M
Which two statements are correct in this scenario?
A. Hr_tbsis abigfiletablespace.
B. Abigfiletablespacecannot be created in the SALES database
C.All tablespaces in HR database will be locally managed by default.
D.Sales_tbsandhr_tbstablespaces can share the same data file.
E.All the tablespaces in the SALES database will be dictionary managed by default.
Answer: B, E
怎么看出sales的默认是字典管理表空间? 我觉得E不对
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-613354/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8135069/viewspace-613354/