当前位置:首页 > 全部子站 > IT > Oracle

Oracle DBA 数据库结构试题选2

来源:长理培训发布时间:2017-09-16 15:10:52

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

责编:罗莉

发表评论(共0条评论)
请自觉遵守互联网相关政策法规,评论内容只代表网友观点,发表审核后显示!

国家电网校园招聘考试直播课程通关班

  • 讲师:刘萍萍 / 谢楠
  • 课时:160h
  • 价格 4580

特色双名师解密新课程高频考点,送国家电网教材讲义,助力一次通关

配套通关班送国网在线题库一套

课程专业名称
讲师
课时
查看课程

国家电网招聘考试录播视频课程

  • 讲师:崔莹莹 / 刘萍萍
  • 课时:180h
  • 价格 3580

特色解密新课程高频考点,免费学习,助力一次通关

配套全套国网视频课程免费学习

课程专业名称
讲师
课时
查看课程
在线题库
面授课程更多>>
图书商城更多>>
在线报名
  • 报考专业:
    *(必填)
  • 姓名:
    *(必填)
  • 手机号码:
    *(必填)