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

Question 1

In a multiplex configuration, each node shares a(n) ___________________ .

A. Interfaces File

B. IQ Message File

C. IQ Temporary Store

D. IQ Main Store

E. IQ Catalog Store

Correct Answer: D

Question 2

Select three features of Sybase IQ. (Choose 3)

A. Vertical/Column Data Storage

B. Bit-Wise Storage Technology

C. In-Memory Database (IMDB)

D. Ad-Hoc Query Optimizer

E. Row Level Locking

Correct Answer: A,B,D

Question 3

What authority is required for database backup, checkpoint, and allows you to drop user connections?

A. SPACE ADMIN

B. MULTIPLEX ADMIN

C. OPERATOR

D. PERMS ADMIN

E. USER ADMIN

Correct Answer: C

Question 4

For a user-defined main store dbspace, what is the recommended number of dbfiles?

A. 3 + (number_of_multihost_cores/10)

B. 3 + (number_of_multihost_cores/2)

C. Number_of_multihost_cores

D. 2 xnumber_of_multihost_cores

Correct Answer: A

Question 5

Which of the following statements are TRUE if the command given below is executed? (Choose 2) CREATE DBSPACE MyDbspace USING FILE MyFile1 '/IQ/data/file1' SIZE 2000 RESERVE 1000;

A. The reserve of 1000MB is part of the 2000MB specified for the file.

B. IQ Main Storedbspace called MyDbspace?is created.IQ Main Store dbspace called ?MyDbspace?is created.

C. A Catalog Storedbspace is created.

D. Will create a raw devicedbfile of 2000MB.

Correct Answer: A,B

Question 6

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

A. Check

B. Allocation

C. Dropleaks

D. Verify

Correct Answer: B,C

Question 7

In planning to create a new database, what is typically the initial size of the IQ Temporary Store?

A. 10 percent of the size of the IQ Main Store

B. 20 percent of the size of the IQ Main Store

C. Equal to the size of the IQ Main Store

D. 50 percent of the size of the IQ Main Store

Correct Answer: B

Question 8

Which of the following need to be in place before a full database Restore can be done? (Choose 2)

A. Must have a DBA connection to a running server.

B. IQ Catalog Store and Transaction Log must not exist.

C. IQ Catalog Store and Transaction Log must be recreated as empty files.

D. IQ Catalog Store and Transaction Log must exist.

Correct Answer: A,B

Question 9

The ability of the Sybase IQ server to create an FP(3) index on a column with 10 million distinct values is controlled by the database options FP_LOOKUP_SIZE and FP_LOOKUP_SIZE_PPM. The default values of these database options directly related to the ?FP_LOOKUP_SIZE and FP_LOOKUP_SIZE_PPM. The default values of these database options directly related to the

A. amount of free space in the IQ Main Store.

B. size of the Catalog Store Cache.

C. size of the IQ Temporary Store Cache.

D. size of the IQ Main Store Cache.

Correct Answer: D

Welcome to TestSimulate

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