欢迎来到天天文库
浏览记录
ID:22263168
大小:58.00 KB
页数:5页
时间:2018-10-28
《oracle dba 用户管理试题选》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、OracleDBA用户管理试题选Q.1:Thedefaulttablespaceclauseinthecreateusermandsetsthelocationfor 1.DatabaseObjectscreatedbytheuser 2.TemporaryObjectsCreatedBytheUser 3.SystemObjectsCreatedbytheuser 4.Noneoftheabove Q.2:ax_Extents 4.Quota Q.4:E 2.DISCONNECT_TIME 3.CONNECT_TI
2、ME 4.NONEOFTHEABOVE Q.5:IT=TRUE 3.RES_LIMIT=TRUE 4.Theyareenabledbydefault Ansitsperiodsofcontiniousinactivetimeduringasession,expressedinminutes.OracleNet8configurationparameterSQL.EXPIRE_TIMEenablesdeadconnectiondetectionsendingprobepacketsfromsevertoclientinauserdef
3、inedinterval. 5=>3, 6=>1, 7=>2, 8=>2, 9=>2, 10=>3, 11=>2, 12=>2,Q.1:Thedefaulttablespaceclauseinthecreateusermandsetsthelocationfor 1.DatabaseObjectscreatedbytheuser 2.TemporaryObjectsCreatedBytheUser 3.SystemObjectsCreatedbytheuser 4.Noneo
4、ftheabove Q.2:ax_Extents 4.Quota Q.4:E 2.DISCONNECT_TIME 3.CONNECT_TIME 4.NONEOFTHEABOVE Q.5:itedbytheQuotaonatablespace 1.Update 2.Delete 3.Create 4.Alloftheabove Q.6: 2.indentifiedbyjames 3.Defaultablespacesystem 4.Noneoftheabove Q.7:etersforeach
5、profile 1.DBA_PROFILE 2.DBA_PROFILES 3.DBA_USERS 4.DBA_RESOURCES Q.8: 1.DBA_ROLES 2.DBA_ROLE_PRIVS 3.DBA_USERS 4.Noneoftheabove Q.10: 1.DBA_PROCESS 2.DBA_SESSION 3.V$SESSION 4.Noneoftheabove Q.11:killsession‘12,123‘; 1.KillSessionwithPID=12andSeria
6、l=123
此文档下载收益归作者所有