Which stored procedure displays the SQL command executing for each connection?
A. sp_iqtransaction
B. sp_iqcontext
C. sp_iqstatus
D. sp_iqconnection
正解:B
質問 2:
Which command can NOT be used to assign a user to a specific login policy?
A. CREATE USER
B. sp_iqmodifylogin
C. ALTER USER
D. sp_iqaddlogin
E. GRANT CONNECT
正解:E
質問 3:
Which permissions can be inherited from group membership? (Choose 3)
A. REFERENCES
B. INSERT
C. CONNECT
D. KERBEROS LOGIN
E. ALTER
正解:A,B,E
質問 4:
Given a VARCHAR field of 100 bytes, how much space is needed to store the data in a Flat FP prior to compression?
A. 1 bit per distinct value
B. 101 bytes
C. 100 bytes
D. Varies based on the amount in use
正解:B
質問 5:
Which of the following circumstances warrant performing routine IQ Index Maintenance? (Choose 2)
A. 7 Days have passed since last index maintenance
B. After every data load
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
質問 6:
Which of these actions will help keep table versioning to a minimum? (Choose 2)
A. Enable a database event to disconnect users who have not issued any command after a set period of time
B. Revoke DBA Authority from all users except the DBA
C. Configure ODBC database connections to issue commits immediately before or after queries
D. Set the database optionPublic.Force_No_Scroll_Cursors = N
E. Revoke Resource Authority from all users except the DBA
正解:A,C
質問 7:
Which stored procedure can show fragmentation of the FP index?
A. sp_iqrowdensity
B. sp_iqtableinfo
C. sp_iqcolumn
D. sp_iqspaceused
正解:A
Matsumoto -
510-702試験対策はこの問題集ひとつで充分足りるんじゃないかと思ってます。Sybaseさんはいつも信用しております。