Dumps Questions
Dumps Questions
Latest 000-917 - System Administration for IBM Informix Dynamic Server V10 Dumps
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
2.Which of the following commands print logical log records?
a.onlog -l
b.onmode -l
c.onstat -l
d.onstat -m
Show the answer with explanation
3.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.
Show the answer with explanation
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
Show the answer with explanation
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
Show the answer with explanation
www.dumpsquestions.com © 2009