[oracle]Oracle DBA 用户管理试题选
【shitiku.jxxyjl.com--Oracle试题集锦】
q. 1 : the default tablespace clause in the create user command sets the location for1. 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
2. kill session with sid=12 and serial =123
3. kill session with serial =123 and sid=12
4. none of the above
q. 12 : what parameter in init.ora enables the resource limits
1. resource=true
2. resource_limit=true
3. res_limit=true
4. they are enabled by default
answer:
1=>1,
2=>2,
3=>4,
4=>1 : idle_time (in user profile) limits periods of continious inactive time during a session, expressed in minutes. oracle net8 configuration parameter sqlnet.expire_time enables dead connection detection sending probe packets from sever to client in a user defined interval.
5=>3,
6=>1,
7=>2,
8=>2,
9=>2,
10=>3,
11=>2,
12=>2,
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
-
国外某公司的营业部经理是一位年轻的女士_国外某公司的Oracle DBA试题详细阅读
oracle dba interview questions by b g 1 how many memory layers are in the shared pool? 2 how do you find out from the rman catalog if a particular a...
-
【oracledba面试题及答案】OracleDBA创建数据库试题精选详细阅读
q 1 : this symbol, when you put infront of a line in the parameter file, 1 $ 2 @ 3 4 ! q 2 : when you change a parameter value...
-
oracle_Oracle DBA 审计数据库试题选详细阅读
q 1 : what feature in oracle allows you to monitor suspicious activity on the datbase 1 replication 2 auditing 3 monitoring 4 tuning...
-
[oracledba面试题及答案]OracleDBA数据库结构题选1详细阅读
q 1 : physical disk resources in an oracle database are 1 control files 2 redo log files 3 data files 4 all of the above 4 q 2 : wha...