To celebrate the Christmas, cheaptestinside cut down  price

from now  to 12.30 .2009,you can use my 20%  code  :holiday20

you can save  your moeny

moer  cheap exam in  www.cheaptestinside.com

Exam Number/Code: 000-918

Exam Name: System Administration for IBM Informix Dynamic Server V11

Updated:8/17/2009

Questons and Answers : 282 questions

but it sell  only $49

Exam Language(s): English

1. Click the Exhibit button.
Given the sqexplain output in the exhibit, which SQL statement will make the est_rows column accurate?
exhibit Missing
A. update statistics high for table
B. update statistics high for systables
C. update statistics high for table orders
D. update statistics high for table customer
Answer: A
2. Which two protocols are used on a Linux platform for IPC connections? (Choose two.)
A. fast fiber
B. shared memory
C. stream pipe
D. named pipe
E. local loopback
Answer: BC
3. Click the Exhibit button.
exhibit Missing
In the exhibit, how does an IDS database administrator or programmer ensure that only committed data will
be seen and that no locking errors will occur?
A. Change user 1 isolation level to dirty read.
B. Change user 2 isolation level to dirty read.
C. Change user 1 isolation level to committed read last committed.
D. Change user 2 isolation level to committed read last committed.
Answer: D
4. You detected excessive memory usage that might be caused by a memory leak in the application.Which
two commands would be useful in this scenario? (Choose two.)
A. onstat -u
B. onstat -g sql -r 120
C. onstat -g ses -r 60
D. onstat -g mgm
E. onstat -g mem
Answer: CE
5. A user wants to save SQL explain output to the file: /tmp/myexplain.out. Which syntax should be used?
A. set explain on file to /tmp/myexplain.out
B. set explain on file /tmp/myexplain.out

C. set explain file /tmp/myexplain.out
D. set explain file to /tmp/myexplain.out
Answer: D
6. Which type of backup and restore (BAR) utility would be suited for restoring a single table from a level 0
backup to a specific point in time?
A. onbar
B. ontape
C. archecker
D. onarchive
Answer: C
7. When determining the physical log size, what should you consider?
A. RTO_SERVER_RESTART configuration parameter
B. DYNAMIC_LOGS configuration parameter
C. PHYSBUFF configuration parameter
D. LOGFILES configuration parameter
Answer: A
8. Given the following message log information:
15:56:29 Physical Recovery Started at Page (1:1210).
15:56:29 Physical Recovery Complete: 147 Pages Examined, 10 Pages Restored.
15:56:29 Logical Recovery Started.
15:56:29 10 recovery worker threads will be started.
15:56:32 Logical Recovery has reached the transaction cleanup phase.
15:56:32 Logical Recovery Complete.
5 Committed, 2 Rolled Back, 0 Open, 0 Bad Locks
What would be the reason for the difference in ‘Pages Examined’ and ‘Pages Restored’ during physical
recovery?
A. The database server might physically log a page image multiple times between checkpoints.
B. The physical recovery restores only the first logged page image.
C. It is an expected behavior.
D. The physical log size is too large.
Answer: A
9. An IDS server has its LRU_MIN_DIRTY set to 1 and its LRU_MAX_DIRTY set to 2. Occasionally the
checkpoint blocks user transactions from doing updates to the database for too long. How should the
database administrator correct this situation?
A. Set onconfig parameter AUTO_CKPT to 1 and follow any advice in online.log.

B. Increase the number of page cleaners (i.e. flushers).
C. Increase the buffer pool size.
D. Set the onconfig parameter RTO_SERVER_RESTART to “on”.
Answer: A
10. Which two statements are true for an hierarchical routing topology when setting up SQLHOSTS server
group? (Choose two.)
A. Root and nonroot servers only need to maintain their leaf node server groups.
B. Root and nonroot servers must each maintain all server groups within the enterprise.
C. Enterprise Replication will transmit exactly the SQLHOSTS information, there is no need to maintain
them.
D. Each leaf server must have SQLHOSTS information only for itself and its parent.
E. SQLHOSTS entries for nodes that do not directly connect are not required.
Answer: BD
11. Which memory area is used for log records for smart objects?
A. virtual portion of shared memory
B. logical log buffers
C. /tmp
D. DBSPACETEMP
Answer: B
12. Given the following ‘onstat -g arc’ information:
IBM Informix Dynamic Server Version 11.10.FC1 — On-Line — Up 45:18:13 — 38912 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 02/11/2007.22:01 43 0×5338c
1 02/14/2007.22:01 66 0×1b2e8
2 02/16/2007.22:01 75 0×1d2e8
dbs1 2 0 02/14/2007.22:01 43 0×5338c
1 02/14/2007.22:01 66 0×1b2e8
2 02/16/2007.22:01 75 0×1d2e8
On February 16, 2007, at 1:00 PM, a chunk in dbspace bs1 encountered hardware failure.
Which method will restore all of the data, to the point of failure, to a replacement disk drive?
A. a level 0 and 2 restore followed by a logical log restore
B. a level 0 and 1 restore only
C. a level 0 and 1 restore followed by a logical log restore

D. a level 0, 1, and 2 restore followed by a logical log restore
Answer: C
13. Which two parameters influence the total size of the resident portion of shared memory? (Choose two.)
A. RESIDENT
B. BUFFERS
C. LOCKS
D. SHMBASE
E. PHYSBUFF
Answer: CE
14. What will the setting “SQLTRACE level=LOW,ntraces=2000,size=2,mode=global” within the Informix
onconfig file record?
A. statement statistics, statement text, and list of table names
B. statement text, host variables, and statement iterators
C. statement statistics, statement text, and statement iterators
D. statement text, statement iterators, and database name
Answer: C
15. A database administrator uses the following onconfig parameters:
TAPEDEV = /foo/resdev
How will this affect ontape backup?
A. ontape will use the directory /foo/resdev if it exists for storage space backup.
B. ontape will use the definitions for TAPEBLK from the file /foo/resdev.
C. ontape will write an informational message to the file /foo/resdev.
D. ontape will use the definitions for TAPESIZE from the file /foo/resdev.
Answer: A
16. Which command would be used to monitor disk activity per chunk?
A. onstat -g iog
B. onstat -d
C. onstat -g iof
D. onstat -F
Answer: C
17. An Informix database server has been configured with the following parameters:
BAR_MAX_BACKUP 5
BAR_NB_XPORT_COUNT 4
BAR_XFER_BUF_SIZE 10
How many data buffers will be created during an onbar parallel backup attempt?

A. 50
B. 20
C. 40
D. 25
Answer: B
18. Both standard and temporary dbspaces are listed in the DBSPACETEMP configuration parameter or
environment variable. Which rule applies?
A. Sort, backup, implicit, and non-logging explicit temporary tables are created in temporary dbspaces if
adequate space exists.
B. Backup, implicit, and non-logging explicit temporary tables are created in temporary dbspaces if
adequate space exists. Sort temporary tables are specified by the PSORT_DBTEMP environment variable.
C. Sort, backup, implicit, and non-logging explicit temporary tables are created in all available dbspaces if
adequate space exists.
D. Explicit temporary tables created without the WITH NO LOG option are created in the root dbspace.
Answer: A
19. The table called “state” has lock mode set to row within an unbuffered logged database. The onconfig
file has USELASTCOMMITTED ‘COMMITTED READ’ set. One user session has run the following:
begin work;
select * from state where code = “AK”;
update state set sname = “ALASKA” where code = “AK”;
The results from the SQL select statement run by user one was:
AK Alaska
Session two runs the following (session one is still connected):
set isolation to dirty read;
select * from state where code = “AK”;
What will session two see when they run the above SQL statements?
A. AK and Alaska
B. AK and ALASKA
C. Error code 244 and isam 107.
D. The session waits until user one is finished processing.
Answer: B
20. You are receiving an error when trying to drop a chunk that you think is empty. Which command will
show you if any object is still allocating part of the chunk?
A. oncheck -pe
B. onstat -d
C. oncheck -cD
D. oncheck -cc
Answer: A

cheaptestinside The introduction of savings schemes to help more computer work certificate, under the economic crisis, it is their own weight to increase employment

Cheaptestinside offer many 80% discount.it is free.but u can buy discout form us . i can help you to save A lot of money! we offer 50%,25%,0% discount .u can use it when buy my products.

Now We have more special offers . only $88 can hlep pass exams which you want to test exams! For example, you want to test MCSE2003: 70-270 290 291 293 294 298 228. ALL Microsoft is $88!

please order now

Exam Number/Code: 000-017

Exam Name: Foundations of Tivoli process automation engine V7.1

Updated:4/8/2009

Questons and Answers : 94 questions

Exam Language(s): English

Market Price: $ 59.00

Member Price:$59.00

We recommend you buying the 000-017 exam bootcamps online on our offical site CheapTestInside.com

 1.A customer wants to ensure that any data sent to the Tivoli process automation engine’s Integration Framework for retrieval of financial data into the Tivoli process automation engine cansurvive restarts and failures. Which statement is true?
A.A JMS messaging engine must be configured with a persistent data store.
B.The customer must have the persist data option set for the Integration Framework adapter.
C.It can be configured by setting a property inside the Tivoli process automation engine after installation.
D.The messages are stored local to the adapter and will survive failures without any additional configuration.
Correct:A
2.What is the correct method to initiate an invocation channel?
A.an action class
B.Java system protocols
C.an invocation message
D.a Java Message Service (JMS) queue connection
Correct:A
3.Where are the conditions for the Conditional user interface functionality defined?
A.in the System Properties application
B.in the Application Designer application
C.in the Database Configuration application
D.in the Conditional user interface application
Correct:B
4.Which tasks can the user perform from the Scheduling Status tab on Run Reports on the Report Administration application?
A.preview a report; generate a report
B.edit a report schedule; preview a report
C.view a report schedule; generate a report
D.view a report schedule; edit a report schedule
Correct:D
5.At which level are Drilldown options set?
A.Site
B.System
C.Item Set
D.Organization
Correct:D
6.The building block of the Integration Framework enables applications to perform the following functions: publish and query application data; add, update, and delete application data; and import and export application data. What is this building block?
A.web services
B.object structure
C.extended Java objects
D.Java message queuing
Correct:B
7.When the agent saves the service request ticket, the system launches into a Service Request Workflow process and evaluates the data on the record. If the agent has not entered asset, location, or configuration item data, the system displays a dialog box with the following options: Close ticket - informational call Close ticket - unauthorized caller Close ticket - misdirected call Take no action If an asset, location, or configuration item is specified on the record, the system displays a dialog box with the following options: Take Ownership of ticket Assign Ownership of ticket Create Work Order Take no action on this ticket Which three Nodes are used in this part of the workflow process? (Choose three.)
A.Wait
B.Input
C.Task
D.Condition
E.Interaction
F.Manual Input
Correct:D E F
8.Which two types of Migration packages can be defined?
A.Push, Pull
B.Ad hoc, Defined
C.Snapshot, Change
D.Dedicated, Run Time
Correct:C
9.A client has two plants that share a raw material preprocessing facility. Which structures would best fit this situation?
A.two organizations; two sites, each with a preprocessor and a plant; multiple systems
B.single organization; two sites, each having a preprocessor and a plant; one geographical system
C.single organization; single site; one primary geographical system; two functional processing systems
D.two organizations, each with a single site and duplicate preprocessor locations; two functional systems
Correct:C
10.Which two types of condition can be created using the Conditional Expression Manager? (Choose two.)
A.class
B.unique
C.universal
D.expression
E.conditional
Correct:A D

Tags : , cheaptestinside

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!