145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
来源:互联网 发布:excel数据透视表快捷键 编辑:程序博客网 时间:2024/05/16 10:48
145.Examine the commands executed in a DBA session:
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A.No more data files can be added to the tablespace.
B.Segment space is managed by free lists in the tablespace.
C.A user created without being assigned a default tablespace uses this tablespace.
D.The tablespace can be dropped with the current setting with segments present in it.
答案:AC
解析:big表空间只能有一个数据文件A正确,因为指定为数据库的默认表空间,因此如果创建用户的时候没有指定表空间
那么使用该表空间C正确,默认表空间不能被删除D错误
B:参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN01102
里面有这么一句
Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment space management,
ASSM(automatic segment space management)自动段空间管理
1.使用位图来管理磁盘空间的,他存放在段中一个单独的数据块中,它被称为位图块,当插入数据的时候,oracle检索位图获取一个具有足够空间的块然后更新位图块中的记录
2.只能在表空间一级而且是本地管理的表空间才能开启,在创建表空间的时候加入语句segment space management auto子句就可以完成自动的段空间管理配置
3.11g默认创建的本地表空间就是自动管理表空间,除了system、临时表空间、还原表空间之外其他都是自动管理的表空间
4.可以通过下面的对象进行查看相关信息
dba_tablespaces
dba_data_files
dba_extents --区间
dba_segments --段
dba_free_space --空闲空间
freelist
这个就是一个列表
手工数据块的管理
1.插入操作的时候,oracle将保留数据块15%的空闲空间,为将来的更新做准备
2.当空闲区小于15%的时候,oracle将该数据从空闲队列(freelists)中去掉
3.如果删除或修改造成了数据行的缩小,虽然大于了15%,但是使用的空间大于30,因此还是不能插入
4.只有当小于30(pctused),该数据块才可以重新放入空闲队列中
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A.No more data files can be added to the tablespace.
B.Segment space is managed by free lists in the tablespace.
C.A user created without being assigned a default tablespace uses this tablespace.
D.The tablespace can be dropped with the current setting with segments present in it.
答案:AC
解析:big表空间只能有一个数据文件A正确,因为指定为数据库的默认表空间,因此如果创建用户的时候没有指定表空间
那么使用该表空间C正确,默认表空间不能被删除D错误
B:参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN01102
里面有这么一句
Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment space management,
ASSM(automatic segment space management)自动段空间管理
1.使用位图来管理磁盘空间的,他存放在段中一个单独的数据块中,它被称为位图块,当插入数据的时候,oracle检索位图获取一个具有足够空间的块然后更新位图块中的记录
2.只能在表空间一级而且是本地管理的表空间才能开启,在创建表空间的时候加入语句segment space management auto子句就可以完成自动的段空间管理配置
3.11g默认创建的本地表空间就是自动管理表空间,除了system、临时表空间、还原表空间之外其他都是自动管理的表空间
4.可以通过下面的对象进行查看相关信息
dba_tablespaces
dba_data_files
dba_extents --区间
dba_segments --段
dba_free_space --空闲空间
freelist
这个就是一个列表
手工数据块的管理
1.插入操作的时候,oracle将保留数据块15%的空闲空间,为将来的更新做准备
2.当空闲区小于15%的时候,oracle将该数据从空闲队列(freelists)中去掉
3.如果删除或修改造成了数据行的缩小,虽然大于了15%,但是使用的空间大于30,因此还是不能插入
4.只有当小于30(pctused),该数据块才可以重新放入空闲队列中
0 0
- 145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
- 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
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- 172.The SQL statements executed in a user session are as follows:
- OCP 172. The SQL statements executed in a user session are as follows:
- 92 Examine the output of the query that you executed to list the objects in the recycle bin: SQL> SE
- 36.Examine the following SQL commands:
- 35.You executed the command to create a password file in the database server:
- 156.Examine the following steps performed on a database instance: 1: The DBA grants the CREATE TABL
- 92.You executed the following commands in an RMAN session for your database instance that has failur
- 77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES
- 164.Examine the command that is used to create a table: SQL> CREATE TABLE orders( oid NUMBER(6) PRI
- Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Doc ID 1050261.1)
- Create tablespace in Oracle
- 176.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report
- Create tablespace SQL
- 124.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAME
- Hbase入门之:原理、基本概念与架构
- Java获取目录下全部文件
- OC-小游戏
- iOS UITableView用系统自带的分割线隐藏不用显示的线
- Android ListView工作原理完全解析,带你从源码的角度彻底理解
- 145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
- 2016.8.4入营测试
- Ubuntu下安装jdk
- 146.Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)
- Unity GUI自适应屏幕分辨率的方法
- spring 与redis缓存整合 实例
- HDU5795 A Simple Nim
- java api从高德地图获取某个位置的经纬度
- 实现子Div在父Div中水平居中的一种方法