OracleDBA用户管理试题选Oracle认证考试

文章作者 100test 发表时间 2009:04:09 22:29:10
来源 100Test.Com百考试题网


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. 0update
  2. 0delete
  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

相关文章


OracleDBA存储管理试题选Oracle认证考试
OracleDBA回滚段管理试题选Oracle认证考试
OracleDBA用户管理试题选Oracle认证考试
OracleDBA审计数据库试题选Oracle认证考试
OracleDBA数据库结构试题选2Oracle认证考试
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛