Sybase IQ Administrator Professional Certification (Version 15.2) - 510-702 Exam Practice Test

A. Group ? Individual ? DBA

B. DBA ? Individual ? Group

C. Group ? DBA ? Individual

D. DBA ? Group ? Individual

A. All rows are deleted.

B. The operation can be rolled back.

C. The operation is logged.

D. Indexes are removed.

E. The operation is non-logged.

A. ALTER

B. REFERENCES

C. INSERT

D. CONNECT

E. KERBEROS LOGIN

A. MINIMIZE_STORAGE

B. INDEX_PREFERENCE

C. NOEXEC

D. INDEX_ADVISOR

A. dbvalid

B. dblog

C. dbtran

D. dblocate

A. Start server from Sybase Central

B. Use thestartserver command on command line

C. Use thestart_iq utility on command line

D. Use thestart_asiq utility on command line

A. Data conversion errors are ignored.

B. NULL is inserted into the column in the row where error occurs.

C. All data conversion errors will stop the load and cause a rollback.

D. Conversion error messages are sent to the transaction log.

A. INSERT permission on the table.

B. EXECUTE permission on the stored procedure and REFERENCES permission on the table.

C. EXECUTE permission on the stored procedure and INSERT permission on the table.

D. EXECUTE permission on the stored procedure.

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

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

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 respect provides better query performance than case ignore.

A. Number of rows that can be processed in a Group By (Hash)

B. Memory used for building optimized FP indexes

C. Number of rows that can be processed in a Hash join

D. Memory used for loading HG indexes