Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Sybase
  5. 510-702

Sybase 510-702 Exam Questions
510-702 Sybase IQ Administrator Professional Certification (Page 2 )

Updated On: 16-Feb-2026
Page 2 of 25
PDF with 115 Questions

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

  1. sp_iqtransaction
  2. sp_iqconnection
  3. sp_iqcontext
  4. sp_iqstatus

Answer(s): C



Which of the following statements are TRUE about Sybase IQ transaction control?

  1. Individual rows may be locked
  2. Individual blocks may be locked
  3. Individual pages may be locked
  4. Individual tables may be locked

Answer(s): D



The IQ transaction model allows?(Choose 2)

  1. one user to modify a table at a time.
  2. keeps changes invisible to users until all changes are committed.
  3. updates to be seen by all users at the time of change.
  4. multiple updates to a table concurrently.
  5. different isolation levels.

Answer(s): A,B



Sybase IQ snapshot versioning?Sybase IQ snapshot versioning

  1. allows updates to tables while users are reading the data.
  2. makes new table versions available automatically without explicit commit/rollbacks.
  3. stores a complete copy of each table per version.
  4. supports ANSI isolation level 0 reads.

Answer(s): A



You are a DBA user and have two open connections to the database. In one connection you are creating a HG index on a table which will require another 30 minutes to build. In the second connection you attempt to issue an Alter Table to drop a column on the same table. What will happen?

  1. The drop column will succeed but will not occur until the HG index build completes.
  2. If you issue an explicit commit first, the drop column will succeed while the HG index is being created.
  3. The drop column command will fail.
  4. The drop column command will succeed immediately.

Answer(s): C






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

Join the 510-702 Discussion