Free 640-802 Demo Download

Free demo for IBM IBM certifications II 000-918 exam (System Administration for IBM Informix Dynamic Server V11). You can check out the interface, question quality and usability of our practice exams

Free Download 640-802 Exam Pdf Demo
Free Download 640-802 Exam iEngine Demo

　
　
Exam : IBM 000-918
Title : System Administration for IBM Informix Dynamic Server V11

1. 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

2. 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

3. 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

4. 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

5. 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

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. 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

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