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不对
因为init file文件中的COMPTIBLE参数被设置成了9.2.0 所以所有的tablespace默认都应该是字典管理的。
All the tablespaces in the SALES database will be dictionary managed by default。
呵呵 英文说的很学问啊,这句话应该是没有错误的
Note: Beginning in Oracle9i the default for non-SYSTEM
permanent tablespaces is locally managed whenever both of the
following criteria are met:
n The EXTENT MANAGEMENT clause is not specified
n The COMPATIBLE initialization parameter is set to 9.0.0 or
higher
Oracle9i Database Administrator’s Guide
默认的应该是本地管理表空间吧!