ocp 052 you are creating a locally managed tablespace
来源:互联网 发布:网络切换开关 编辑:程序博客网 时间:2024/06/13 09:30
You are creating a locally managed tablespace to meet the following requirements:
All the extents should be of the same size. The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents.
Which three options would you choose? (Choose three.)
A) set PCTFREE and PCTUSED to 50
B) specify extent allocation as Uniform
C) specify extent allocation as Automatic
D) create the tablespace as bigfile tablespace
E) create the tablespace as smallfile tablespace
F) set segment space management to Automatic
G) use the RESIZE clause while creating the tablespace
Answer: B,E,F
All the extents should be of the same size,需要区统一管理,选B
The data should be spread across two data files,只有smallfile类型的表空间才能有多个数据文件,所以选E。
A bitmap should be used to record the free space within the allocated extents,要用位图管理,那么需要段空间自动管理(ASSM),选F
- ocp 052 you are creating a locally managed tablespace
- Creating a Locally Managed Tablespace
- Shrinking a Locally Managed Temporary Tablespace
- Locally Managed Tablespaces
- WARNING: You are creating/reusing datafile
- are you a loser?
- Locally vs. Dictionary Managed Tablespaces
- 184 You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g d
- you are not a superman!
- Are You a Software Architect?
- You are given a tetrahedron.
- The database has local access protection and you are not authorized to access it locally
- ORA-3214 When Creating a Tablespace [ID 153869.1]
- Error: You are creating QApplication before calling UIApplicationMain
- nethogs – creating socket failed are you root?
- Lesson 7 Are you a teacher?
- Lesson 7 Are you a teacher?
- Are you a qualified Windows programmer?
- spring3.1+hibernate4
- Android源码下载——用git clone实现单个目录下载
- 大数加法和大数乘法
- 杨氏矩阵与钩子公式
- jQuery .position() .offset()
- ocp 052 you are creating a locally managed tablespace
- Win 32 多线程程序设计学习笔记之二:线程
- LeetCode:Binary Tree Postorder Traversal
- 机器学习中的数学(1)-回归(regression)、梯度下降(gradient descent)
- C++第11周项目3——回文、素数
- Eclipse Java EE IDE 添加tomcat服务器以及解决404的问题
- IOS开发之——CoreText
- 建立Telnet服务器
- hdoj 1166 敌兵布阵(LTE)