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

1. Which statements are FALSE regarding a dynamic collision? (Choose 3)

A) It results in an automatic shutdown of the secondary node.
B) It can occur onboth a Coordinator or a secondary node.
C) It occurs only on the secondary nodes.
D) It results in a forced disconnect of a user connection to a secondary node.
E) It occurs only on the Coordinator node.

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

3. User Mary is assigned to group Sales. The Sales group has DBA and RESOURCE authority and owns a table named ProductSales. Which of the following statements is TRUE?

A) Mary does not have to specify the owner of theProductSales table.
B) Mary inherits the DBA and RESOURCE authority.
C) Mary has select rights on theProductSales table.
D) Mary can add users to the Sales group.

4. Which of the following is TRUE about global temporary tables in Sybase IQ?

A) Table data is visible to the session that inserts them.
B) Table data is visible across sessions for all users and reboots.
C) Table data is visible across sessions for a user that inserts them.
D) Table data is visible across reboots for a user that inserts them.

5. In which of the following cases do we need to synchronize a secondary server in Sybase IQ Multiplex? (Choose 2)

A) After adding a file to the IQ_SYSTEM_MAINdbspace
B) After restoring a secondary server from a backup
C) After running the Coordinator in single-node mode
D) After adding a file to the IQ_SYSTEM_TEMPdbspace

質問と回答：