Sybase 510-702 問題集

質問 1：
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 has select rights on theProductSales table.
B. Mary does not have to specify the owner of theProductSales table.
C. Mary can add users to the Sales group.
D. Mary inherits the DBA and RESOURCE authority.
正解：B

質問 2：
The IQ transaction model allows?(Choose 2)
A. one user to modify a table at a time.
B. different isolation levels.
C. multiple updates to a table concurrently.
D. keeps changes invisible to users until all changes are committed.
E. updates to be seen by all users at the time of change.
正解：A,D

質問 3：
Which of the following circumstances warrant performing routine IQ Index Maintenance? (Choose 2)
A. After every data load
B. 7 Days have passed since last index maintenance
C. Cardinality of a column has changed, permitting a possible rebuilding with an optimized FP index
D. A table was created with MINIMIZE_STORAGE='OFF'
正解：C,D

質問 4：
Which statements are FALSE regarding a dynamic collision? (Choose 3)
A. It results in an automatic shutdown of the secondary node.
B. It occurs only on the secondary nodes.
C. It occurs only on the Coordinator node.
D. It results in a forced disconnect of a user connection to a secondary node.
E. It can occur onboth a Coordinator or a secondary node.
正解：A,C,E

質問 5：
What is the result of the following backup database command?

A. Backup of data is done in parallel into backup1 and backup2 folders.
B. Backup of data is done in sequentially first filling the backup1 folder and then into backup2 folder.
C. Only 2 filesbackupA and backupB are created with unlimited size.
D. Only 2 filesbackupA and backupB are created with 33554432 size each.
正解：A

質問 6：
Which is TRUE about table partitioning? (Choose 3)
A. Sybase IQ supports up to a maximum of 2048 partitions for range partitioning.
B. Partition columns can be any data type.
C. All existing data must lie within the first declared partition range.
D. Partition column may not be changed.
E. Partition key must exist and cannot be NULL.
正解：C,D,E

質問 7：
Which stored procedure can determine when an index was last used?
A. sp_iqindexmetadata
B. sp_iqtableuse
C. sp_iqstatus
D. sp_iqindexuse
正解：D

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

質問 9：
What is the state of the dbspace when the database starts but one or more files cannot be opened?
A. Dbspace will be offline.
B. Dbspace will be dynamically online.
C. Dbspace will be online.
D. Dbspace will be dynamically offline.
正解：D