ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 字典管理表空间?

字典管理表空间?

原创 Linux操作系统 作者:lijiebin 时间:2008-01-18 11:36:23 0 删除 编辑
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不对

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-613354/,如需转载,请注明出处,否则将追究法律责任。

下一篇: exp权限
请登录后发表评论 登录
全部评论

注册时间:2008-01-10

  • 博文量
    145
  • 访问量
    149787