System Administration for IBM Informix Dynamic Server V10 : 000-917 Exam
Test information:
• Number of questions: 73
• Time allowed in minutes: 120
• Required passing score: 61%
Related certifications:
• IBM Certified Database Administrator — DB2 9 DBA for Linux UNIX and Windows
• IBM Certified System Administrator – System Administration for IBM Informix Dynamic Server V10
Exam Topics Include:
• Database Physical System Design
• Installation and Configuration
• System Activity Monitoring
• Troubleshooting
• Performance Tuning
• dbspace Configuration
• Database Server Operations
• Backup and Restore
Product Description
Exam Number/Code: 000-917
Exam Name:System Administration for IBM Informix Dynamic Server V10
“System Administration for IBM Informix Dynamic Server V10″, also known as 000-917 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 146 Q&A to your 000-917 Exam preparation. In the 000-917 exam resources, you will cover every field and category in IBM certifications helping to ready you for your successful IBM Certification.
Exam Details
If you are knowledgeable with Informix Dynamic Server V10 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of Informix databases, you may benefit from this certification role. To attain the IBM Certified System Administrator – System Administration for IBM Informix Dynamic Server V10 certification, candidates must pass 1 test(000-917).
QUESTION 1
Which of the following formulas represent the recommended method to calculate the estimated minimum size of logical logs files in an IBM Informix Dynamic Server?
A. LOGSIZE = ((number of connections * maxrows) * rowsize ) / 2048) / LOGFILES
B. LOGSIZE = ((number of users * maxrows) * rowsize ) / 1024) / LOGFILES
C. LOGSIZE = ((number of connections * maxrows) * rowsize ) / 1024) / LOGFILES
D. LOGFILES = ((number of connections * maxrows) * rowsize ) / 1024) / LOGSIZE Answer: C
QUESTION 2
Which of the following commands print logical log records?
A. onlog -l
B. onmode -l
C. onstat -l
D. onstat -m
Answer: A
QUESTION 3
Kernel AIO is configured on a UNIX platform; but the database server is not taking advantage of it. Which of the following is the most likely reason for this problem?
A. All chunks are created using cooked files. B. All chunks are created on raw devices.
C. The KAIOON environment variable is on. D. Only one CPU VP was configured.
Answer: A
QUESTION 4
Which of the following configuration parameters specifies the maximum amount of time
a transaction will wait to acquire a lock in a distributed database environment?
A. DEADLOCK_TIMEOUT B. TXTIMEOUT
C. BLOCK_TIMEOUT D. DRTIMEOUT
Answer: A
QUESTION 5
A company is using the following nightly backup strategy:
Level 0 every Sunday
Level 1 every Wednesday
Level 2 every Friday
Logical logs are continuously backed up
Users were inserting data on a Friday morning when the database server’s only disk drive failed. Which of the following methods 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 followed by a logical log restore
C. A level 0, 1, and 2 restore followed by a logical log restore
D. A level 0 and 1 restore only
Answer: B
QUESTION 6
Given the following ONCONFIG parameters:
The IDS with J/Foundation server fails to initialize. What is the cause?
A. No user defined classes are allowed in this configuration.
B. A mandatory ‘num’ argument is missing from the VPCLASS. C. The virtual processor class must be in lowercase.
D. UDR is not a pre-defined virtual processor class. Answer: A
QUESTION 7
Which of the following commands will start the database server in single user mode and initialize rootdbs?
A. oninit -iy B. oninit -ijy C. oninit
D. oninit -isy
Answer: B
QUESTION 8
A database server has performance problems related to insufficient buffers. In addition, frequent memory swapping is observed at the operating system level. Which of the following should be increased FIRST to solve this performance problem?
A. The amount of temporary dbspace
B. The number of database buffers
C. The amount of physical memory
D. The amount of virtual memory
Answer: C
QUESTION 9
A Database Administrator wants to configure AIO VPs for an IDS version 10 database server. Which of the following configuration parameters should be used to set the number
of AIO VPs to 2?
A. NUMAIOVPS B. NUMCPUVPS C. VPCLASS
D. NUMKIOVPS Answer: C
QUESTION 10
A dbspace needs to be dropped to free disk space. Typically which of the following is the best method to do this?
A. Drop all objects in the dbspace, drop all chunks that belong to the dbspace, and then drop the dbspace.
B. Drop all objects in the dbspace, then drop the dbspace.
C. Drop all chunks that belong to the dbspace, drop all objects in the dbspace, and then drop the dbspace.
D. Drop all chunks that belong to the dbspace, then drop the dbspace.
Answer: B
QUESTION 11
Which of the following tasks are performed when the oninit command is executed without options? (Select two answers.)
A. Allocate virtual processors and initialize rootdbs
B. Initiate fast recovery and virtual processors
C. Initialize shared memory and allocate semaphores
D. Initiate logical log backup to ensure logical consistency of the data
E. Initiate virtual processors and start the bundled JVM for server-side processing
Answer: B,C
*pass4sure ibm 000-917 Questions and Answers : 146 Q&A
* Updated: October 2nd , 2008
* Price: $159.99 $99.99
Free down:Testking ibm 000-917
Free down:Pass4sure ibm 000-917
| IBM Free Downloads |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Ibm 's Exam Pack |
767 |
1 days ago | Download |
If you would like to make a comment, please fill out the form below.
[...] Designer V5R3 pass4sure 000-884 Exam : IBM Tivoli Identity Manager Express V4.6 Specialist pass4sure 000-917 Exam : System Administration for IBM Informix Dynamic Server V10 pass4sure 000-973 Exam : Power [...]