Exam 000-918 study material Made available by Testkingprep.com
Free 000-918 Exam Preparation Questions Exam 000-918: System Administration for IBM Informix Dynamic Server V11
For Latest 000-918 Exam Questions and study guides- visit- http://www.testkingprep.com/000-918.html
Question:1 Which oninit option puts the database server in administration mode? A. -u B. -s C. -j D. -k Answer: C Question:2 You detected excessive memory usage that might be caused by a memory leak in the application. Which two commands would be useful in this scenario? (Choose two.) A. onstat -u B. onstat -g sql -r 120 C. onstat -g ses -r 60 D. onstat -g mgm E. onstat -g mem Answer: C, E Question:3 A large database system containing 100 dbspaces lost a critical dbspace. What is the quickest way to recover dbspace_1? A. Cold restore all dbspaces. B. Cold restore critical dbspaces and dbspace1 followed by a hot restore of the remaining dbspaces. C. Cold restore critical dbspaces and dbspace1 followed by a cold restore of the remaining dbspaces. D. Cold restore critical dbspaces and dbspace1 followed by a warm restore of the remaining dbspaces. Answer: D Question:4 A database administrator (DBA) is performing an onbar restore and the restore process is taking a long time to complete. The DBA does not know how far the restore has completed. Which configuration parameter should a DBA set to monitor the restore process? A. Set the BAR_HISTORY configuration parameter to monitor the onbar process. B. Set the BAR_PROGRESS_FREQ configuration parameter prior to starting the restore. C. Set the BAR_DEBUG_LOG configuration parameter prior to starting the restore. D. Set the BAR_PROCESS_MON configuration parameter prior to starting the restore. Answer: B Question:5 In which two ways should a database administrator check the data buffer pool cache rate? (Choose two.) A. onstat -g mem B. onstat -p C. a select from the sysprofile table D. a select from the sysbufpool table E. onstat -P Answer: B, C Question:6 What is the purpose of FASTPOLL onconfig parameter? A. Uses the OS supported replacement for the legacy poll() function. B. Employs an aggressive AIO VP scheduling algorithm. C. Disables Kernal Asnchronous I/O in favor of AIO. D. Optimizes SQL thread monitoring.
For Latest 000-918 Exam Questions and study guides- visit- http://www.testkingprep.com/000-918.html
Answer: A Question:7 Click the Exhibit button. Which action should a DBA take to address the message shown in the exhibit in the online.log file?
A. Make sure free space in the rootdbs is at least 200 MB. B. Increase the size of the physical log to 300 MB. C. Ensure that the logical logs have at least 200000 KB of space. D. Expand the size of the root dbs. Answer: B Question:8 What are two ways to add logging to a database? (Choose two.) A. ontape B. ontape 1 C. ontape D. ontape 2 Answer: A Question:9 Which two tasks are supported by External Backup and Restore (EBR)? (Choose two.) A. Restoring a single dbspace to be restored to the current point in time B. Backing up Informix logical logs by a third-party can be used during the restore process C. Using a third-party tool to make a partial or complete copy of the instance chunks D. Backing up the logical log E. Table level restores to a user specified point-in-time Answer: A, C Question:10 A user with a DBSA role received the error: 27010: Only an administrative user or informix can connect in administrative/single user mode. Which parameter should be configured to fix the problem? A. ALLOW_SINGLE_USER_DBA B. ADMIN_USER_MODE_WITH_DBSA C. SINGLE_USER_DBA D. SINGLE_USER_CONNECT_DBSA Answer: B
For Latest 000-918 Exam Questions and study guides- visit- http://www.testkingprep.com/000-918.html
For complete Exam 000-918 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/000-918.html
http://www.testkingprep.com/
For Latest 000-918 Exam Questions and study guides- visit- http://www.testkingprep.com/000-918.html