510-702 Exam Training Practice Tests (Sybase IQ Administrator Professional Certification (Version 15.2))]

Question 1

Which stored procedure displays the SQL command executing for each connection?

A. sp_iqcontext B. sp_iqtransaction C. sp_iqstatus D. sp_iqconnection

Correct Answer: A

Question 2

Which of the following is TRUE about global temporary tables in Sybase IQ?

A. Table data is visible across sessions for all users and reboots. B. Table data is visible across reboots for a user that inserts them. C. Table data is visible across sessions for a user that inserts them. D. Table data is visible to the session that inserts them.

Correct Answer: D

Question 3

Which of the following server switches control checkpoint intervals? (Choose 2)

A. -gp B. -gc C. -gd D. -gr E. -gm

Correct Answer: B,D

Question 4

In planning to create a new database, what is typically the initial size of the IQ Temporary Store?

A. 10 percent of the size of the IQ Main Store B. Equal to the size of the IQ Main Store C. 20 percent of the size of the IQ Main Store D. 50 percent of the size of the IQ Main Store

Correct Answer: C

Question 5

Which mode of sp_iqcheckdb should be used to see if the values in the FP index are consistent with the values in the other indexes?

A. VERIFY B. ALLOCATION C. CHECK D. DROPLEAKS

Correct Answer: C

Question 6

What happens when CONVERSION_ERROR option =FF? (Choose 2)What happens when CONVERSION_ERROR option =?FF? (Choose 2)

A. Conversion error messages are sent to the transaction log. B. All data conversion errors will stop the load and cause a rollback. C. Data conversion errors are ignored. D. NULL is inserted into the column in the row where error occurs.

Correct Answer: C,D

Question 7

Which of these actions will help keep table versioning to a minimum? (Choose 2)

A. Revoke Resource Authority from all users except the DBA B. Configure ODBC database connections to issue commits immediately before or after queries C. Enable a database event to disconnect users who have not issued any command after a set period of time D. Revoke DBA Authority from all users except the DBA E. Set the database optionPublic.Force_No_Scroll_Cursors = N

Correct Answer: B,C

Question 8

The database option MAX_HASH_ROWS controls the?(Choose 2)

A. Memory used for loading HG indexes B. Memory used for building optimized FP indexes C. Number of rows that can be processed in a Group By (Hash) D. Number of rows that can be processed in a Hash join

Correct Answer: C,D

Sybase IQ Administrator Professional Certification (Version 15.2) - 510-702 Exam Practice Test