Online Access Free 000-619 Exam Questions

What is the earliest version you can migrate / upgrade directly to Informix 12.10?

• A.8.0
• B.9.40
• C.10.0
• D.7.30

Which two parameters are mandatory when running "ifxclone"? (Choose two.)

• A.Target server configuration parameters.
• B.Target server instance size.
• C.Target server instance name.
• D.Source server instance sqlhosts.
• E.Source server instance TCP/IP address.

Which two statements are true?

• A.Temporary dbspaces can have different page sizes.
• B.Separate temporary dbspaces are required for each buffer pool.
• C.If rootdbs is mirrored then all the temporary spaces must be mirrored.
• D.If DBSPACETEMP is not configured then temporary space will never be used.
• E.DBSPACETEMP dbspaces can be temporary or standard dbspaces.

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

• A.The query or query block must include at least 2 fact tables.
• B.The query or query block must refer to a subset of the tables in the AQT.
• C.The table references or joins specified in the query or query block must be the same as the references in the data mart definition.
• D.The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

Which statement is true about log salvaging?

• A.Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.
• B.Log salvaging cannot be avoided if onbar is used for restore.
• C.ontape cannot perform salvage of logs.
• D.Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.