510-702 by Sybase Actual Free Exam Q&As

Question 1

By default, a table is created in which dbspace?

A. Thedbspace specified with the DEFAULT_DBSPACE option. B. The table is striped across all read-writedbspaces. C. Thedbspace with the most amount of free space. D. Thedbspace with the largest amount of contiguous free space.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Data in a table can span ____________________ and __________________. (Choose 2)

A. databases B. IQ Main and Catalog Store C. dbfiles D. dbspaces

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

Which stored procedure shows a list of unused indexes?

A. sp_iqindexmetadata B. sp_iqindexuse C. sp_iqunusedindex D. sp_iqindexadvice

Discussion 0

Correct Answer: C Vote an answer

Question 4

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

A. sp_iqfile B. sp_iqdbspaceinfo C. sp_iqtable D. sp_iqdbspace E. sp_iqspaceused

Discussion 0

Correct Answer: A,D Vote an answer

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

Question 5

Which command should a user run before running a database backup?

A. sp_iqcheckdb B. COMMIT C. sp_iqconnections D. sp_iqstatus E. CHECKPOINT

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which of the following index types provide metadata to the optimizer? (Choose 3)

A. HG B. CMP C. Unique LF D. FP(2) E. FP F. HNG

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 7

Which of the following indexes can be created UNIQUE?

A. HG B. CMP C. FP D. HNG

Discussion 0

Correct Answer: A Vote an answer

Sybase IQ Administrator Professional Certification (Version 15.2) - 510-702 Exam Practice Test