Free 000-915 demo download
IBM 000-915 exam : system administration for infromix dynamic server v9
Testinside free 000-915 demo:
1. The System Administrator needs to know when the latest “update statistics medium” has been run.
Which of the following tables will most likely contain this information?
A. systables
B. sysdistrib
C. sysindexes
D. syscolumns
Answer: B
2. A non-critical dbspace has been taken offline due to a disk failure. This dbspace contained 10% of the
production data. A level-o archive and logical log backups are available for a restore of the database server,
which normally takes up to ten hours.
Which of the following is the best solution to restore the database server?
A. Do a cold restore and apply the logical logs
B. Do a warm restore and apply the logical logs
C. Do a warm restore without applying the logical logs
D. Do a cold restore without applying the logical logs.
Answer: B
3. A data warehousing system has 1TB of data. A batch job is run every night to load new data. No data or
schema changes occur during the daytime. Which of the following is the best backup strategy for this
database system?
A. Perform a physical backup after daily batch job completes; run logical log backups
B. Perform a physical backup before the daily batch job completes; run logical log backups
C. Perform a physical backup after the daily batch job completes; do not run logical log backups
D. Perform a physical backup before the daily batch job completes; do not run logical log backups
Answer: C
4. 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
5. A dbspace is almost full and more space is needed.When adding a new chunk to the dbspace, which of
following must be considered when specifying the size of the new chunk?
A. The size of the chunk should be considered but it can be changed after it is created.
B. Choose the chunk size carefully because its size cannot be changed once it is created.
C. For better performance, it is better to add a lot of small chunks than one very large chunk.
D. As a rule of thumb, the size of the new chunk should be twice the size of the previous chunk.
E. The size of the new chunk should not exceed the total size of all chunks currently allocated to the
dbspace.
Answer: B
Other exams:000-779 exam and 000-787 exam and 000-885 exam and 000-886 exam