510-702 試験問題を無料オンラインアクセス

Which ANSI Isolation Level does Sybase IQ employ?

• A.2
• B.3
• C.0
• D.1

Which of the following statements are TRUE about Sybase IQ transaction control?

• A.Individual rows may be locked
• B.Individual pages may be locked
• C.Individual tables may be locked
• D.Individual blocks may be locked

When loading data from a file, what component of the Sybase IQ server is used to buffer data read from disk and build HG indexes?

• A.Heap Memory
• B.IQ Catalog Cache
• C.IQ Temporary Cache
• D.IQ Main Cache

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

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

Which is TRUE about table partitioning? (Choose 3)

• A.All existing data must lie within the first declared partition range.
• B.Partition column may not be changed.
• C.Partition key must exist and cannot be NULL.
• D.Sybase IQ supports up to a maximum of 2048 partitions for range partitioning.
• E.Partition columns can be any data type.