Sybase IQ Administrator Professional Certification (Version 15.2) 認定 510-702 試験問題:

1. You have a license to run Sybase IQ with 4 cores. You are switching to a new 8 core server to run your Sybase IQ database. In order to comply with Sybase licensing you need to ?Sybase licensing you need to

A) set bothqnumbercpus and qgovern server parameters to 4.set both ?qnumbercpus and ?qgovern server parameters to 4.
B) set the server parameterqnumbercpus to 4.set the server parameter ?qnumbercpus to 4.
C) purchase a Sybase IQ license for an additional 4 cores.
D) set the server parameterqgovern to 4. set the server parameter ?qgovern to 4.

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

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

3. Which of the following is shared by all servers in a multiplex?

A) IQ Main Store
B) IQ Message File
C) Catalog Store
D) Transaction Log
E) IQ Temporary Store

4. Which of the following stored procedures provide workload monitoring reports? (Choose 3)

A) sp_iqindexmetadata
B) sp_iqindexuse
C) sp_iqunusedindex
D) sp_iqcheckdb
E) sp_iqdbstatistics
F) sp_iqtableuse

5. As you load data using Load Table you encounter the error warning: Partial input record 512 skipped at EOF.? What could be most likely the problems? (Choose 2)

A) The column specification in the Load Table command does not match the input file.
B) There is a column delimiter in the data.
C) There is insufficient memory in the IQ Temporary Cache to load this table.
D) Record number 512 in the input data file is unreadable.
E) A data conversion error occurred in a row of input data.

質問と回答：