欢迎来到天天文库
浏览记录
ID:24147168
大小:54.50 KB
页数:4页
时间:2018-11-12
《oracledba数据库结构题选2》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、OracleDBA数据库结构题选2Q.1: 2.TEMPORARY 3.ROLLBACK 4.USERS 1 Q.7:Sortscanbemanagedefficientlybyassigning____tablespacetosortoperations. 1.SYSEM 2.TEMPORARY 3.ROLLBACK 4.USERS 2 Q.8:Thesortsegmentofatemporarytablespaceiscreated 1.atthetimeofthefirstsortoperation 2.emoryrequi
2、redforsortingis1kb 4.alloftheabove 1 Q.9:PORARY 2.ROLLBACK 3.CACHE 4.INDEX 3 Q.10: 4 Q.11:Rollbacksegmentsareusedfor 1.readconsistency 2.rollingbacktransactions 3.recoveringthedatabase 4.alloftheabove 4 Q.12:Rollbacksegmentstores 1.oldvaluesofthedatach
3、angedbyeachtransaction 2.neationappliedintheeventofadatabasecrash 1.beforethecrashoccurs 2.aftertherecoveryisplete 3.immediatelyafterre-openingthedatabasebeforetherecovery 4.rollbackinfrmationisneverappliedifthedatabasecrashes 2 Q.2:Thedatadictionarytablesandvieakethedatabaseuse
4、rfriendly 2.tostoreuserdata 3.tostoreapplicationdata 4.forproperdatabasefunctioning 4
此文档下载收益归作者所有