Free Sybase 510-702 Practice Test & Real Exam Questions

Exam Code/Number: 510-702
Exam Name/Title: Sybase IQ Administrator Professional Certification (Version 15.2)
Certification Provider: Sybase
Corresponding Certification: Sybase Certification

Exam Questions: 119
Updated On: Aug 14, 2026

Question #1

Which of the following circumstances will enable a LOAD TABLE command to be executed in parallel across many processors? (Choose 2)

A. The database optionAppend_Load option is ON.

B. The input data file is fully delimited and the Row Delimited By option is specified.

C. The LIMIT option in Load Table command is used.

D. The input data file is fixed width and the Row Delimited By option is specified.

E. The table being loaded is empty.

Discussion 0

Correct Answer: B,D Vote an answer

Question #2

Which of the following sp_iqcheckdb modes can NOT check index consistency? (Choose 2)

A. Dropleaks

B. Allocation

C. Verify

D. Check

Discussion 0

Correct Answer: A,B Vote an answer

Question #3

When referring to a database object, an owner prefix is NOT required if?(Choose 2)

A. he has RESOURCE authority.

B. he is the owner of the object.

C. the object is a stored procedure.

D. the object is owned by a group of which he is a member.

E. the object is a view.

Discussion 0

Correct Answer: B,D Vote an answer

Question #4

For a LOAD TABLE using an IGNORE CONSTRAINT NULL 10, UNIQUE 10, CHECK 10 parameter, which of the following will cause a rollback? (Choose 2)

A. 9 Foreign key constraint violations

B. 4 null values in non-null columns

C. 15 check constraint violations

D. 7 duplicate keys

Discussion 0

Correct Answer: A,C Vote an answer

Question #5

Which permissions can be inherited from group membership? (Choose 3)

A. INSERT

B. REFERENCES

C. KERBEROS LOGIN

D. ALTER

E. CONNECT

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #6

What happens when CONVERSION_ERROR option =FF? (Choose 2)What happens when CONVERSION_ERROR option =?FF? (Choose 2)

A. All data conversion errors will stop the load and cause a rollback.

B. Data conversion errors are ignored.

C. NULL is inserted into the column in the row where error occurs.

D. Conversion error messages are sent to the transaction log.

Discussion 0

Correct Answer: B,C Vote an answer

Question #7

What governs the rules for user logins?

A. User Roles

B. Verify_Password_Function

C. Login Policies

D. sp_iqaddlogin

Discussion 0

Correct Answer: C Vote an answer

Question #8

Which procedure provides information about block types in dbspaces? (Choose 2)

A. sp_iqdbspaceinfo

B. sp_iqtable

C. sp_iqspaceused

D. sp_iqdbspace

E. sp_iqfile

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #9

Which of the following statements are TRUE about APPEND_LOAD? (Choose 2)

A. If set to N?table could be larger if deletes have been appliedIf set to ?N? table could be larger if deletes have been applied

B. Can be set dynamically

C. N?by DEFAULT?N?by DEFAULT

D. If set to N?makes the loading slowerIf set to ?N? makes the loading slower

Discussion 0

Correct Answer: A,B Vote an answer

Download Free Sybase 510-702 Demo

Simply submit your e-mail address below to get started with our free demo of your Sybase 510-702 exam.