23.Note the following structures in your database server:
来源:互联网 发布:复旦大学软件工程硕士 编辑:程序博客网 时间:2024/06/07 00:47
23.Note the following structures in your database server:
1: Extents
2: OS Blocks
3: Tablespace
4: Segments
5: Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?
A.2, 5, 1, 4, 3
B.1, 2, 3, 4, 5
C.5, 2, 1, 3, 4
D.2, 1, 5, 4, 3
答案:A
解析:最小的应该是操作系统bolck,然后是oracle的block
然后是extents,然后是segments,然后是tablespace
SQL> l
1 select segment_name,tablespace_name,extents,blocks
2* from dba_segments where tablespace_name='USERS' and owner='SCOTT' and segment_type='TABLE'
SQL> /
SEGMENT_NA TABLESPACE EXTENTS BLOCKS
---------- ---------- ---------- ----------
DEPT USERS 1 8
EMP USERS 2 16
SALGRADE USERS 1 8
从这里我们可以看出users表空间包括多个segment,segment为dept的包括多个extent,dept包括1个extent
并且包括8个blocks,因此从这里可以看出来
blocks<extents<segment<tablespace
1: Extents
2: OS Blocks
3: Tablespace
4: Segments
5: Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?
A.2, 5, 1, 4, 3
B.1, 2, 3, 4, 5
C.5, 2, 1, 3, 4
D.2, 1, 5, 4, 3
答案:A
解析:最小的应该是操作系统bolck,然后是oracle的block
然后是extents,然后是segments,然后是tablespace
SQL> l
1 select segment_name,tablespace_name,extents,blocks
2* from dba_segments where tablespace_name='USERS' and owner='SCOTT' and segment_type='TABLE'
SQL> /
SEGMENT_NA TABLESPACE EXTENTS BLOCKS
---------- ---------- ---------- ----------
DEPT USERS 1 8
EMP USERS 2 16
SALGRADE USERS 1 8
从这里我们可以看出users表空间包括多个segment,segment为dept的包括多个extent,dept包括1个extent
并且包括8个blocks,因此从这里可以看出来
blocks<extents<segment<tablespace
0 0
- 23.Note the following structures in your database server:
- 96 Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M D
- 6.Note the following points describing various utilities in Oracle Database 11g:
- 107.Note the following points describing various utilities in Oracle Database 11g:
- 98 Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - Th
- Your server IP address is in the SORBS DNSBL database
- 92.You executed the following commands in an RMAN session for your database instance that has failur
- 186.User A executes the following command to drop a large table in your database: SQL> DROP TABLE tr
- 161.In your database instance, the user sessions are connected to the database server from the remot
- The following URL schemes found in your app are not in the correct format 解决方案
- 53.You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TAR
- The String class is provided in the Java library. Provide your own implementation for the following
- In the web.xml of your war, have the following entry:
- 126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
- 72.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG
- 114.You plan to implement the distributed database system in your company. You invoke Database Confi
- How to shrink the tempdb database in SQL Server
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- Python基本语法_基本数据类型_序列类型详解
- LeetCode 374. Guess Number Higher or Lower
- CSS3实现手机网页3D切换效果
- UVA 11889 - Benefit
- Android制作引导页和启动页
- 23.Note the following structures in your database server:
- aidl 进程间通信
- Activity启动模式
- MVC模式的优缺点
- 超实用的JavaScript代码段 Item7 -- “&&”和“||”操作符总结
- 设置一启动Activity就弹出键盘
- C语言中%p,%u,%lu都有什么用处
- android实现消息推送的解决方案
- 设置Activity全屏显示