Free Pass4sure 000-918 question bank that you need to pass the exam

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!