Free 510-702 Exam Braindumps (page: 11)

Page 10 of 30

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

  1. sp_iqwho
  2. sp_iqtransaction
  3. sp_iqlocks
  4. sp_iqconnection

Answer(s): A,C



In Sybase IQ, the dblog utility... (Choose 2)

  1. translates a Transaction Log into a .sql command file.
  2. changes the name of the Transaction Log associated with a database.
  3. changes the name of the Transaction Log associated with a database, even if the database is running.
  4. displays the name of the Transaction Log mirror associated with a database.

Answer(s): B,D



What type of data can be stored in IQ_SYSTEM_MAIN? (Choose 3)

  1. System Tables
  2. User Data
  3. IQ Free List
  4. IQ TLV
  5. Table Metadata

Answer(s): B,C,D



Which dbspace is associated with the Catalog Store?

  1. IQ_SYSTEM_MAIN
  2. IQ_SYSTEM_TEMP
  3. SYSTEM
  4. USER_DBSPACE

Answer(s): C






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

510-702 Exam Discussions & Posts