최신 510-702 무료덤프 - Sybase IQ Administrator Professional Certification (Version 15.2)

A. 7 duplicate keys

B. 15 check constraint violations

C. 9 Foreign key constraint violations

D. 4 null values in non-null columns

A. 1 day

B. 180 days

C. 30 days

D. 1 hour

A. FP

B. Unique LF

C. HNG

D. HG

E. CMP

F. FP(2)

A. Level1 ?prevents dirty reads

B. Level0 ?allows dirty reads

C. Level3 ?prevents phantom reads

D. Level2 ?prevents non-repeatable reads

A. Native connectivity via CIS proxy tables

B. Remote connection must always use JDBC

C. Linked tables

D. Using Sybase Enterprise Connect Data Access

A. sp_iqstatus

B. sp_iqconnection

C. sp_iqcontext

D. sp_iqlocks

A. IQ_SYSTEM_MAIN

B. IQ_SYSTEM_TEMP

C. SYSTEM

D. USER_DBSPACE

A. Can be set dynamically

B. If set to N?table could be larger if deletes have been appliedIf set to ?N? table could be larger if deletes have been applied

C. If set to N?makes the loading slowerIf set to ?N? makes the loading slower

D. N?by DEFAULT?N?by DEFAULT

A. Given that the database has very wide tables and a Catalog page size of 4K, increase Catalog page size to improve performance.

B. Case respect provides better query performance than case ignore.

C. Given that the database has very wide tables and a Catalog page size of 4K, decrease Catalog page size to improve performance.

D. Case ignore provides better query performance than case respect.