Questions and Answers:282 Q&As
Updated: 2009-09-22
Exam Number/Code: 000-918
Exam Name: System Administration for IBM Informix Dynamic Server V11
IBM IBM certifications II 000-918 282Q&As are created by senior IT lecturers in Certinside certification Q&A network and IBM certifications II product experts combination PROMETRIC or VUE true-to-date environmental examination of the original title.
The Questions & Answers cover the latest real test and with all the correct answer.we promise the Q&A for IBM certifications II 000-918(System Administration for IBM Informix Dynamic Server V11) examination of original title complete coverage.000-918 Questions & Answers help you pass the exam.
000-918 Free Demo Download
Certinside offers free demo for 000-918 282 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.
Download 000-918 Exam Pdf Demo
Download 000-918 Exam iEngine Demo
Exam : IBM 000-918
Title : System Administration for IBM Informix Dynamic Server V11
1. 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
2. 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
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. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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