2016年Oracle DBA用户管理试题及答案
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
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 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 RE_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,
-
H3C云计算销售专家认证
H3C云计算销售专家认证是H3C公司推出的针对渠道销售人员资质评定的能力认证,通过该认证的学员已具备基本的云计算产品销售能力,对服务器、存储、云管理平台等云产品和行业应用有了基本了解,能够独立与客户进行日常交流并进一步挖掘用户需求。1.考试及费用代码名称...
-
2016年计算机应用能力模拟考试题
2016年4月计算机应用能力考试即将开始了,下面本站小编为大家分享的是最新的计算机应用能力考试模拟试题及答案,希望对大家有所帮助!1.请将WindowsXP中文版注销。点击左下角开始菜单——最下面一行有注销2.设置虚拟内存初始大小值和最大值都为1152MB。...
-
2016年J2EE认证试题(附答案)
J2EE用来建设大型的分布式企业级应用程序。或者用更时髦的名词说就是电子商务应用程序。下面本站小编为大家推荐的是J2EE认证考试题,希望对大家有所帮助!一、基础问答1.下面哪些类可以被继承?java.lang.Thread(T)java.lang.Number(T)java.lang.Double(F)java.la...
-
2017年计算机二级office高级应用试题
多媒体技术是一种迅速发展的综合性电子信息技术,它给传统的计算机系统、音频和视频设备带来了方向性的变革,将对大众传媒产生深远的影响。下面是小编整理的计算机二级office高级应用试题,欢迎大家参考!一、选择题[单选题]计算机软件的确切含义是()。A.计算机程序...