最新的IBM 000-619免費考試真題

問題1

Which two statements are true?

A. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

B. If rootdbs is mirrored then all the temporary spaces must be mirrored.

C. Temporary dbspaces can have different page sizes.

D. Separate temporary dbspaces are required for each buffer pool.

E. If DBSPACETEMP is not configured then temporary space will never be used.

正確答案: A,C

問題2

The purge policy CANNOT be executed for a rolling window table utilizing which method?

A. By calling the syspurge function.

B. By running ALTER FRAGMENT with the PURGE NOW predicate.

C. By the purge_tables task of the Scheduler.

D. By setting up the server to automatically run the purge policy.

正確答案: B

問題3

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear",
"informix_stores");

A. Converts the shared disk secondary server to a standard server and shuts down the primary server.

B. Clears the log position of the SDS servers and restarts replication.

C. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

D. Shuts down the primary server and converts the secondary server to be the primary.

正確答案: C

問題4

Which action can be taken if an instance is down?

A. Cold restore by onbar using storage space backups taken by ontape on tape devices.

B. A point-in-time mixed restore.

C. A mixed restore using onbar whole system backup and incremental dbspace level backups.

D. Warm restore of non-critical storage spaces.

正確答案: B

問題5

The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the
SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable
= ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name =
? uto_crsd? UPDATE ph_threshold SET value = ?WHERE name =
UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name =
? UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name =
UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name =
? UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

A. Compress and defragment tables with more than 5000 uncompressed rows.

B. Compress, repack and shrink tables with more than 5000 uncompressed rows.

C. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

D. Compress all tables with less than 5000 rows.

正確答案: B

問題6

Which is NOT a feature of onbar backups?

A. The ability to backup without a storage manager.

B. The ability to do a point-in-time restore.

C. The ability to do an external backup using a Storage Area Network.

D. The ability to parallelize backups.

正確答案: A

問題7

Click on the exhibit. Which type of join is occurring?

A. Multi Index Join

B. ANSI Join

C. Star Join

D. Index Self-Join

正確答案: C

最新的IBM Informix 12.10 System Administrator - 000-619免費考試真題

聯系我們

站內鏈接

最新更新