没有合适的资源？快使用搜索试试~ 我知道了~

文库首页数据库Informixibm informix 12.10 数据库管理员技术认证考题

ibm informix 12.10 数据库管理员技术认证考题

Informix

12.10

数据库管理员

技术认证

5星 · 超过95%的资源需积分: 50 60 下载量 135 浏览量 2015-04-26 14:57:03 上传评论收藏 425KB PDF 举报

温馨提示

试读

47页

C2090-619 IBM Informix 12.10 System Administrator-IBM技术认证考题,最新的ibm informix 12.10 数据库管理员技术认证考题,考取专业IBM 技术认证，实现职场价值提升。如有需要，自行下载……。

资源推荐

资源详情

资源评论

IBM C2090-619

IBM Informix 12.10 System Administrator

Version: 4.0

温室小花.技术.博客 –纯粹的 unix 技术博客 http://www.evanjiang.net QQ:3819468

红颜弹指老，刹那芳华，与其天涯思君，恋恋不舍，心绕不断,莫若相忘于江湖！

多年 Unix/Linux 经验,丰富 MiddleWare /DataBase 经验,现居广州.

技术博客: http://www.evanjiang.net QQ: 438549233

Skype/MSN:zymh_zy@hotmail.com Mail: zymh_zy@163.com

QUESTION NO: 1

Which configuration parameter can toggle the automatic expansion of storage spaces?

A. SP_AUTOGROW

B. SP_AUTO_SPACE

C. SP_AUTOEXPAND

D. SP_EXPAND_ENABLE

Answer: C

Explanation:

QUESTION NO: 2

Which statement is FALSE about dbspace configurable page sizes?

A. Dbspace page size can only be set for non-critical dbspaces.

B. Possible page sizes are multiples of the default page size up to 16 kb.

C. Configure page sizes as close to the backup / restore and network buffer size as possible for

efficient data transfer across the wire.

D. Dbspace page size should be configured to accommodate the greatest number of average row

sizes with a minimum of remainder pages beingused.

Answer: C

Explanation:

QUESTION NO: 3

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF

lock errors. What action should be taken to reduce the network shared file lock contention?

A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.

B. Increase the value of NUMFDSERVERS and add more poll threads.

C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment

variable.

Answer: B

Explanation:

温室小花.技术.博客 –纯粹的 unix 技术博客 http://www.evanjiang.net QQ:3819468

红颜弹指老，刹那芳华，与其天涯思君，恋恋不舍，心绕不断,莫若相忘于江湖！

多年 Unix/Linux 经验,丰富 MiddleWare /DataBase 经验,现居广州.

技术博客: http://www.evanjiang.net QQ: 438549233

Skype/MSN:zymh_zy@hotmail.com Mail: zymh_zy@163.com

QUESTION NO: 4

Which configuration parameter should be set to enable asynchronous page requests when the

database server detects that a query is waiting on I/O?

A. DIRECT_IO

B. DBUPSPACE

C. AUTO_AIOVPS

D. AUTO_READAHEAD

Answer: D

Explanation:

QUESTION NO: 5

Which table attribute defines the percentage of changes (insert/update/delete) threshold to

consider the statistics as stale?

A. STATAUTO

B. STATFORCE

C. FORCE AUTO

D. STATCHANGE

Answer: D

Explanation:

QUESTION NO: 6

Which configuration parameter locks the resident and virtual segments of shared memory in

operating-system physical memory?

A. SHMSEG

B. SHMBASE

C. RESIDENT

D. INFORMIXSHMLCK

Answer: C

Explanation:

温室小花.技术.博客 –纯粹的 unix 技术博客 http://www.evanjiang.net QQ:3819468

红颜弹指老，刹那芳华，与其天涯思君，恋恋不舍，心绕不断,莫若相忘于江湖！

多年 Unix/Linux 经验,丰富 MiddleWare /DataBase 经验,现居广州.

技术博客: http://www.evanjiang.net QQ: 438549233

Skype/MSN:zymh_zy@hotmail.com Mail: zymh_zy@163.com

QUESTION NO: 7

Which configuration parameter can be set to quickly return rows to a user while a query continues

processing?

A. OPTOFC

B. OPTMSG

C. OPT_GOAL

D. OPTCOMPIND

Answer: C

Explanation:

QUESTION NO: 8

Which statement is FALSE about Informix Automatic checkpoint Feature?

A. Automatic checkpoints cause less logical log activity.

B. Automatic checkpoints try to avoid transaction blocking.

C. Automatic checkpoints cause the database server to trigger more frequent checkpoints.

D. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or

onmode -wf.

Answer: A

Explanation:

QUESTION NO: 9

Which option maximizes performance in an Informix Warehouse (DSS) environment?

A. Higher value of LOGBUFF.

B. Higher value of PHYSBUFF.

C. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

Answer: D

Explanation:

温室小花.技术.博客 –纯粹的 unix 技术博客 http://www.evanjiang.net QQ:3819468

红颜弹指老，刹那芳华，与其天涯思君，恋恋不舍，心绕不断,莫若相忘于江湖！

多年 Unix/Linux 经验,丰富 MiddleWare /DataBase 经验,现居广州.

技术博客: http://www.evanjiang.net QQ: 438549233

Skype/MSN:zymh_zy@hotmail.com Mail: zymh_zy@163.com

QUESTION NO: 10

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE

DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which

statement is true?

A. The temp table will be created in datadbs1.

B. The temp table will be created in root dbspace.

C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Answer: B

Explanation:

QUESTION NO: 11

Which Informix utility can be used to display contents of logical-log files, either from disk or from

backup?

A. onlog

B. onclean

C. ondblog

D. onspaces

Answer: A

Explanation:

QUESTION NO: 12

In which table can you find a history of all SQL Administration API functions executed in the last 30

days?

A. sysadmin:admin_history

B. sysmaster:admin_history

C. sysadmin:command_history

D. sysmaster:command_history

温室小花.技术.博客 –纯粹的 unix 技术博客 http://www.evanjiang.net QQ:3819468

红颜弹指老，刹那芳华，与其天涯思君，恋恋不舍，心绕不断,莫若相忘于江湖！

多年 Unix/Linux 经验,丰富 MiddleWare /DataBase 经验,现居广州.

技术博客: http://www.evanjiang.net QQ: 438549233

Skype/MSN:zymh_zy@hotmail.com Mail: zymh_zy@163.com

剩余46页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

梦过轻殇

2017-07-27

对我很有用

温室小花

粉丝: 2
资源: 14

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

ibm informix 12.10 数据库管理员 技术认证 考题

informix考题informix考题

informix参考文档中文

数据库管理员认证考试复习提纲

Informix官方文档

informix 安装

informix 12.1官方指南（中文）

IBM Informix Version 12.10安装手册 UNIX, Linux, and Mac OS X

IBM Informix 12.1 数据库连接指南.pdf

Informix12.1201406-官方训练营的培训资料2

Sql经典练习题库（附答案）

informix12.10安装指南

IBM Informix 12.1 数据库设计和实现指南.pdf

informix12.10相关文档for linux (中文)

informix10.0数据库管理员手册

IBM DB2 10.1 高级管理员 技术认证 考题

sql语句的笔试经典考题

Oracle数据库管理员笔试题

IBM Informix 12.1 管理员指南.pdf

dreamweaver教程

Informix V12.10-Administrator's Guide-IBM Informix 管理员指南-639.pdf

IBM informix 11.X系统管理与开发指南

IBM Informix数据库设计和实现指南

Informix V12.10--Informix Quick Start Guide-2.pdf

IBM Informix Dynamic Server 管理员指南 11.5

Informix系统管理员指南-孙刚玉张俊卿

IBM Informix 12.1 Database Extensions 用户指南.pdf

IBM Informix 12.1 GLS 用户指南.pdf

informix使用指南

IBM Informix 12.1 性能指南.pdf

最新资源

ibm informix 12.10 数据库管理员技术认证考题

IBM DB2 10.1 高级管理员技术认证考题