OracleDBA用户管理试题选
来源:优易学 ?2011-12-29 17:50:59 ? 【优易学:中国教育365bet娱乐_365bet可靠吗_安卓365bet门户网】 ? 资料下载 ? IT书店
q.?1?:?the?default?tablespace?clause?in?the?create?user?command?sets?the?location?for?
  
  1.?database?objects?created?by?the?user?
  2.?temporary?objects?created?by?the?user?
  3.?system?objects?created?by?the?user?
  4.?none?of?the?above?
  
  q.?2?:?what?does?sessions_per_user?in?a?resource?limit?set?
  
  1.?no?of?concurrent?sessions?for?the?database?
  2.?no?of?sessions?per?user?
  3.?no?of?processes?per?user?
  4.?none?of?the?above?
  
  q.?3?:?what?keyword?during?the?create?user?command,?limits?the?space?used?by?users?objects?in?the?database?
  
  1.?size?
  2.?next_extent?
  3.?max_extents?
  4.?quota?
  
  
  q.?4?:?what?value?sets?the?no?activity?time?in?minutes?before?a?user?is?disconnected?
  
  1.?idle_time?
  2.?disconnect_time?
  3.?connect_time?
  4.?none?of?the?above?
  
  q.?5?:?what?operations?are?limited?by?the?quota?on?a?tablespace?
  
  1.?update?
  2.?delete?
  3.?create?
  4.?all?of?the?above?
  
  q.?6?:?which?of?the?following?statements?is?incorrect?when?used?with?:?alter?user?james?
  
  1.?add?quota?5m?
  2.?indentified?by?james?
  3.?defaul?tablespace?system?
  4.?none?of?the?above?
  
  q.?7?:?what?view?consists?information?about?the?resource?usage?parameters?for?each?profile?
  
  1.?dba_profile?
  2.?dba_profiles?
  3.?dba_users?
  4.?dba_resources?
  
  q.?8?:?what?2?values?are?required?to?kill?a?user?session?
  
  1.?sid,?process?id?
  2.?sid,?serial?#?
  3.?serial?#,?process?id?
  4.?none?of?the?above? 
  
  q.?9?:?what?view?contains?the?information?about?all?users?and?the?roles?granted?to?them?
  
  1.?dba_roles?
  2.?dba_role_privs?
  3.?dba_users?
  4.?none?of?the?above?
  
  q.?10?:?where?can?you?obtain?the?sid?and?serial?#?from?
  
  1.?dba_process?
  2.?dba_session?
  3.?v$session?
  4.?none?of?the?above?
  
  q.?11?:?what?is?the?effect?of?the?following?command?"?alter?system?kill?session?‘12,123‘;?
  
  1.?kill?session?with?pid=12?and?serial=123

责任编辑:小草

文章搜索:
?相关文章
热点资讯
热门课程培训