510-702 Exam Questions and Answers | Exam-Dumps (Page: 1)

QUESTION: 1

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

sp_iqtransaction
sp_iqconnection
sp_iqcontext
sp_iqstatus

Answer(s): C

Reveal Solution Next Question

QUESTION: 2

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

Individual rows may be locked
Individual blocks may be locked
Individual pages may be locked
Individual tables may be locked

Answer(s): D

Reveal Solution Next Question

QUESTION: 3

The IQ transaction model allows?(Choose 2)

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

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 4

Sybase IQ snapshot versioning?Sybase IQ snapshot versioning

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

Answer(s): A

Reveal Solution Next Question

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?

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

Answer(s): C

Reveal Solution Next Question

Sybase 510-702 Exam (page: 1)
Sybase 510-702 IQ Administrator Professional Certification
Updated on: 25-Dec-2025

Access free 510-702 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

Sybase 510-702 Exam (page: 1) Sybase 510-702 IQ Administrator Professional Certification Updated on: 25-Dec-2025

Access free 510-702 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

Sybase 510-702 Exam (page: 1)
Sybase 510-702 IQ Administrator Professional Certification
Updated on: 25-Dec-2025