Online Access Free 510-702 Exam Questions

Which stored procedure can show fragmentation of the FP index?

• A.sp_iqrowdensity
• B.sp_iqtableinfo
• C.sp_iqspaceused
• D.sp_iqcolumn

Which stored procedures are used to find users blocking other users from writing to a table? (Choose 2)

• A.sp_iqconnection
• B.sp_iqtransaction
• C.sp_iqlocks
• D.sp_iqwho

In a multiplex configuration, each node shares a(n) ___________________ .

• A.IQ Temporary Store
• B.IQ Main Store
• C.IQ Message File
• D.IQ Catalog Store
• E.Interfaces File

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

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

If a user selects from a table while another user updates the same table, what will happen?

• A.The user updating the table will be blocked.
• B.The selecting user will be blocked.
• C.The user updating the table will get an error.
• D.The selecting user will not be blocked.