510-702 無料問題集「Sybase IQ Administrator Professional Certification (Version 15.2)」

（A）ALTER

（B）CONNECT

（C）KERBEROS LOGIN

（D）INSERT

（E）REFERENCES

（A）Mary has select rights on theProductSales table.

（B）Mary inherits the DBA and RESOURCE authority.

（C）Mary can add users to the Sales group.

（D）Mary does not have to specify the owner of theProductSales table.

（A）GRANT GROUP

（B）ALTER USER

（C）ALTER LOGIN POLICY

（D）sp_iqmodifylogin

（A）Depending on the value of the LIMIT option, new data will fill empty rows first and then be appended to the end of the table.

（B）The new data will be added to the end of the table.

（C）Depending on the value of the SKIP option, new data will be appended to the end of the table.

（D）New data will fill empty rows first and then be appended to the end of the table.

（A）JDBC foriAnywhere

（B）ODBC

（C）Open Client

（D）JDBCJConnect

（A）updates to be seen by all users at the time of change.

（B）keeps changes invisible to users until all changes are committed.

（C）one user to modify a table at a time.

（D）multiple updates to a table concurrently.

（E）different isolation levels.

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

（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）Given that the database has very wide tables and a Catalog page size of 4K, increase Catalog page size to improve performance.

（A）IQ TLV

（B）System Tables

（C）User Data

（D）IQ Free List

（E）Table Metadata

（A）sp_iqsysmon

（B）sp_iqstatus

（C）sp_iqworkmon

（D）sp_iqobjectinfo

（E）sp_iqdbstatistics

（A）IQ Temporary Store

（B）IQ Main Store

（C）Catalog Store

（D）Transaction Log

（E）IQ Message File