IBM
000-918 System Administration for IBM Informix Dynamic Server V11
http://killexams.com/exam-detail/000-918
E. table level restores
Answer: A, C
QUESTION: 131
Given the following messages:
07:32:49 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 07:32:49 Physical Recovery Started at Page (1:1342). 07:32:49 Physical Recovery Complete: 31 Pages Examined, 31 Pages Restored. 07:32:49 Logical Recovery Started. 07:32:49 10 recovery worker threads will be started. 07:32:53 Logical Recovery has reached the transaction cleanup phase. 07:32:53 Logical Recovery Complete. 4 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks Which two statements certainly apply to this situation? (Choose two.)
A. B. C. D E.
The instance is in online mode. There were incomplete transactions. The database server went offline under uncontrolled conditions. Four transactions were rolled forward. The logical recovery took a few minutes to complete.
Answer: C, D
QUESTION: 132
Click the Exhibit button.
Under which situation SHMVIRT_ALLOCSEG?
would
a
database
46
administrator
consider
implementing
A. to avoid assertions as a result of running out of memory B. to set configurable memory block size (in kilobytes) for a virtual memory portion C. to allocate a private memory space for a query
47
D. to assist a decision support system that has PDQ priority set greater than 0
Answer: A
QUESTION: 133
Which statement is true within IDS version 11.10?
A. You can use the Scheduler on the secondary server of an HDR pair of servers. B. You can use the Administration API and the Query Drill-Down facility on the secondary server of an HDR pair of servers. C. You can use the Administration API and the Scheduler on the secondary server of an HDR pair of servers. D. You can use the Query Drill-Down facility on the secondary server of an HDR pair of servers.
Answer: D
QUESTION: 134 Click the Exhibit button. A system has high bufwaits and its number of dirty pages is consistently exceeding the lru_max_dirty_limit. Given the onstat statistics in the exhibit, which two configuration parameter settings will boost performance? (Choose two.)
48
A. B. C. D. E.
Use RA_THRESHOLD to increase the current value. Use BUFFERPOOL to decrease buffers. Use BUFFERPOOL to increase the number of LRU queues and buffers. Use CLEANERS to increase page cleaning. Use a fixed value for SHMTOTAL.
Answer: C, D
QUESTION: 135 A machine with four tape drives is available for database backups. The database administrator
49
wants to enable parallel backups for the database server. Which database configuration parameter should be set to confirm the parallel backups?
A. B. C. D.
ISM_DATA_POOL BAR_WORKER_MAX BAR_XPORT_COUNT BAR_MAX_BACKUP
Answer: D
QUESTION: 136
Which command would be used to monitor disk activity per chunk?
A. B. C. D.
onstat -g iog onstat -d onstat -g iof onstat -F
Answer: C
QUESTION: 137 Which command would you use to find out the logical log number and log position where fast recovery will start?
A. B. C. D.
onstat -l oninit -F oninit -r oncheck -pr
Answer: D
QUESTION: 138 A database administrator is receiving XBSA errors during restore from Informix Storage Manager (ISM). The On-Bar activity log and On-Bar debug log do not provide enough information about the XBSA error. How can the database administrator turn on XBSA debugging?
50
A. B. C. D.
Set the BAR_DEBUG_LEVEL configuration parameter. Set the ISM_DATA_POOL configuration parameter. Set the ISM_XBSA_DEBUG environment variable. Set the ISM_DEBUG_LEVEL environment variable.
Answer: D
QUESTION: 139
When determining the physical log size, what should you consider?
A. B. C. D.
RTO_SERVER_RESTART configuration parameter DYNAMIC_LOGS configuration parameter PHYSBUFF configuration parameter LOGFILES configuration parameter
Answer: A
QUESTION: 140
What is the purpose of the reserved area of the first chunk of an sbspace?
A. B. C. D.
to allocate space to either the metadata or user-data area when more space is needed to store statistical information about the sbspace to enable the database server to manipulate and recover smart large objects to store smart large objects when sbspace is not specified in a PUT clause
Answer: A
QUESTION: 141
The data held in the fourth column of the sqlhosts file should also be found in which file?
A. B. C. D.
hosts resolv.conf services onconfig
51
Answer: C
QUESTION: 142
An IDS server receives the following message:
15:29:13 Results: The server might block transactions during checkpoints. Which are two solutions to the message? (Choose two.)
A. Remove flushers to keep up with the checkpoint. B. Add additional log space. C. Cannot do anything, the system will hang forever waiting for it to unblock. D. Lengthen the time between checkpoints using CKPTINTVL. E. Tune LRU flushing more aggressively by reducing values of lru_min_dirty and lru_max_dirty in the BUFFERPOOL.
Answer: B, E
52
For More exams visit https://killexams.com/vendors-exam-list
Kill your exam at First Attempt....Guaranteed!