Free 510-702 Exam Braindumps

Which of the following information is NOT output from sp_iqstatus?

  1. Number of users currently logged on
  2. Page and block size
  3. Sybase IQ release
  4. Active versions

Answer(s): A



Which of the following stored procedures provide workload monitoring reports? (Choose 3)

  1. sp_iqcheckdb
  2. sp_iqdbstatistics
  3. sp_iqindexuse
  4. sp_iqindexmetadata
  5. sp_iqtableuse
  6. sp_iqunusedindex

Answer(s): C,E,F



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?

  1. ALLOCATION
  2. VERIFY
  3. CHECK
  4. DROPLEAKS

Answer(s): C



Which of the following stored procedures can be used to analyze the SQL Log file? (Choose 2)

  1. sp_iqconnection
  2. sa_get_request_profile
  3. sp_iqcontext
  4. sa_conn_properties
  5. sa_get_request_times

Answer(s): B,E






Post your Comments and Discuss Sybase 510-702 exam with other Community members:

510-702 Exam Discussions & Posts