149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
来源:互联网 发布:数据库删除一条数据 编辑:程序博客网 时间:2024/06/01 08:34
149.You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two.)
A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E.The space utilization description of the data blocks in segments is managed through free lists.
答案:AD
解析:SEGMENT SPACE MANAGEMENT AUTO--说明启用了assm
A:正确,assm
B:错误,这个应该属于表压缩的功能
表压缩
1.11g表压缩是通过 pctfree 参数来控制的,当往一个数据块中插入数据的时候,它是以非压缩的形式
存入的,只要空闲区下降到了 pctfree 的时候,oracle 就开始自动压缩数据,这意味着磁盘空间占用减少
,因此这个数据块就允许继续插入新的未压缩数据直到空闲区再次下降到了pctfree的限制值为止,这个时候压缩又
被触发了
2.这种压缩技术消除了删除操作产生的空洞而且是数据块中连续的空闲区最大化
3.想要使用这种技术,需要将初始化参数设置为 database compatibility 设置为11.1或以上,
还必须在 create table 的时候使用下面两种子句
a.compress for all operations
默认,11g之前的版本在大规模装入数据时压缩数据
b.compress for direct_load operations 子句
在oltp操作和直接装入数据操作时都压缩数据
4.开启表压缩
alter table wahaha compress for all operations;--它只对新数据有效
C:错误,这个说的是数据字典管理的表空间
D:正确,参考145题,这里启用了assm,因此使用的是位图
E:错误
SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two.)
A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E.The space utilization description of the data blocks in segments is managed through free lists.
答案:AD
解析:SEGMENT SPACE MANAGEMENT AUTO--说明启用了assm
A:正确,assm
B:错误,这个应该属于表压缩的功能
表压缩
1.11g表压缩是通过 pctfree 参数来控制的,当往一个数据块中插入数据的时候,它是以非压缩的形式
存入的,只要空闲区下降到了 pctfree 的时候,oracle 就开始自动压缩数据,这意味着磁盘空间占用减少
,因此这个数据块就允许继续插入新的未压缩数据直到空闲区再次下降到了pctfree的限制值为止,这个时候压缩又
被触发了
2.这种压缩技术消除了删除操作产生的空洞而且是数据块中连续的空闲区最大化
3.想要使用这种技术,需要将初始化参数设置为 database compatibility 设置为11.1或以上,
还必须在 create table 的时候使用下面两种子句
a.compress for all operations
默认,11g之前的版本在大规模装入数据时压缩数据
b.compress for direct_load operations 子句
在oltp操作和直接装入数据操作时都压缩数据
4.开启表压缩
alter table wahaha compress for all operations;--它只对新数据有效
C:错误,这个说的是数据字典管理的表空间
D:正确,参考145题,这里启用了assm,因此使用的是位图
E:错误
0 0
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- 77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES
- 176.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report
- 35.You executed the command to create a password file in the database server:
- 145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
- You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPAC
- 144.You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLE
- 25.You need to create a table with the following column specifications:
- 1Z0-051 25. You need to create a table with the following column specifications:
- 147.View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But
- 157.Examine the commands executed in the following sequence: 1: SQL> CREATE ROLE mgrrole; 2: SQL> G
- 126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
- 164.Examine the command that is used to create a table: SQL> CREATE TABLE orders( oid NUMBER(6) PRI
- 124.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAME
- you must specify a way to create the tab indicator.
- Create tablespace SQL
- 33.You want to create an ORD_DETAIL table to store details for an order placed having the following
- 62 You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a
- 文件类和Map
- C语言基础杂碎
- P1053Easy sssp
- JAVA中Action层, Service层 ,modle层 和 Dao层的功能区分
- 二十二.完善Dashboard页面并更改font awesome icons
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- Myeclipse的配置,Tomcat,JDK
- iOS开发笔记>> 如何渲染自定义格式字符串的UILabel
- Win7下安装linux虚拟机
- Faster-rcnn训练自己的数据库
- 浅析人脸检测之Haar分类器方法:Haar特征、积分图、 AdaBoost 、级联
- 萤火虫之歌
- kmp-KMP入门必做-匹配
- 一图秒懂P2P、P2C 、O2O 、B2C、B2B、C2C