Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM 000-917 Exam - Cheat-Test.com

Free 000-917 Sample Questions:

1. A dbspace was recently added to a database server. Which of the following commands will help identify
whether disk layout problems exist as a result of adding the dbspace?
A. onstat -g iob
B. onstat -g iov
C. onstat -g iof
D. onstat -g glo
Answer: C

2. The following error message appears in the database server message log:
09:28:43 Aborting Long Transaction: tx 0xa43c728 username: sallyr uid: 200
This transaction has rolled back. Which of the following best describes the situation in the error message?
A. A transaction has spanned multiple logical-log files and has caused the logical-log files to fill to 100% full.
B. A transaction has caused the physical-log file to fill to the percentage indicated by the LTXHWM configuration
parameter.
C. A transaction has caused a single logical-log file to fill to the percentage indicated by the LTXHWM
configuration parameter.
D. A transaction starting in the oldest log is open, and the percentage of logical-log files filled has passed the
LTXHWM configuration parameter.
Answer: D

3. Which of the following best describes external backups on the IBM Informix Dynamic Server?
A. An external backup allows backups using onbar or ontape; database transactions are active during external backups.
B. An external backup allows backups using onbar or ontape; database transactions are suspended during external backups.
C. An external backup allows backups using operating system or third-party utilities; transactions are active during external backups.
D. An external backup allows backups using operating system or third-party utilities; transactions are suspended
during external backups.
Answer: D

4. A Database Administrator is configuring the files to establish network connections on a UNIX system, which uses a sockets interface and a TCP/IP protocol.
The DBSERVERNAME configuration parameter has been set to 'dbserver1' and the name of the UNIX host
machine is 'chicago1'. The service name used is 'sqlexec'.
Which of the following entries in the sqlhosts file should be used?
A. chicago1 sqlexec dbserver1 onsoctcp
B. chicago1 onsoctcp dbserver1 sqlexec
C. dbserver1 onsoctcp sqlexec chicago1
D. dbserver1 onsoctcp chicago1 sqlexec
Answer: D

5. A database server has been running for days but after monthly reports were run, the following message appeared in the online.log:
12:25:01 Memory allocation error
Which of the following most likely caused the error?
A. The DS_TOTAL_MEMORY has been reached.
B. The swap space on the computer has been set too high.
C. An operating system limit on shared memory has been reached.
D. The BUFFERS and SHMVIRTSIZE configuration parameters are larger than the maximum segment size allowed.
Answer: C

6. Images with an average size of 50 bytes are to be stored as large objects in the database. For a database server that uses a 4KB page size, which of the following methods should be used to store the large objects and utilize disk space most efficiently?
A. Create a normal dbspace to store the large objects.
B. Create a blobspace with a 2KB blobpage size to store the large objects.
C. Create a blobspace with an 8KB blobpage size to store the large objects.
D. Create a blobspace with a 16KB blobpage size to store the large objects.
Answer: A

7. A Database Administrator needs to know the physical location of a table. Which of the following commands would show this information?
A. oncheck -pe
B. oncheck -pr
C. oncheck -pR
D. oncheck -pp
Answer: A

8. To specify which configuration file to use, the ONCONFIG environment variable must be set to the:
A. name of the configuration file to use.
B. path of the configuration file to use.
C. path and name of the configuration file to use.
D. $INFORMIXDIR/etc directory where the configuration file will be located.
Answer: A


© 2014 Cheat-Test.com, All Rights Reserved