- 讲师:刘萍萍 / 谢楠
- 课时:160h
- 价格 4580 元
特色双名师解密新课程高频考点,送国家电网教材讲义,助力一次通关
配套通关班送国网在线题库一套
Q. 1 : When will the rollback information applied in the event of a database crash
1. before the crash occurs
3. immediately after re-opening the database before the recovery
Q. 2 : The data dictionary tables and views are stored in
1. USERS tablespace
3. TEMPORARY tablespace
Q. 3 : Oracle uses the data dictionary tables and views
1. to make the database user friendly
3. to store application data
Q. 4 : No data in any data dictionary tables should be deleted or altered by any user. Which of the following object is an exception to this rule,
1. AUD$
3. USER_HISTORY$
Q. 5 : A collection of segments is a (an)
1. extent
3. tablespace
Q. 6 : When the database is open, which of the following tablespaces must be online
1. SYSTEM
3. ROLLBACK
[NextPage]
Q. 7 : Sorts can be managed efficiently by assigning ____ tablespace to sort operations.
1. SYSEM
3. ROLLBACK
Q. 8 : The sort segment of a temporary tablespace is created
1. at the time of the first sort operation
3. when the memory required for sorting is 1kb
Q. 9 : Which of the following segments is self administered
2. ROLLBACK
4. INDEX
3
Q. 10 : What is the default temporary tablespace, if no temporary tablespace is defined
2. USERS
4. SYSTEM
4
Q. 11 : Rollback segments are used for
1. read consistency
3. recovering the database
Q. 12 : Rollback segment stores
2. new values of the data changed by each transaction
4. none
1
责编:罗莉
课程专业名称 |
讲师 |
课时 |
查看课程 |
---|
课程专业名称 |
讲师 |
课时 |
查看课程 |
---|
点击加载更多评论>>