Online Access Free 510-702 Exam Questions

Which ANSI Isolation Level does Sybase IQ employ?

• A.1
• B.2
• C.0
• D.3

What governs the rules for user logins?

• A.Login Policies
• B.sp_iqaddlogin
• C.Verify_Password_Function
• D.User Roles

Which index consists of a B-tree with a G-Array (group array)?

• A.HG
• B.HNG
• C.LF
• D.FP

Which of the following index types provide metadata to the optimizer? (Choose 3)

• A.HG
• B.HNG
• C.CMP
• D.FP(2)
• E.FP
• F.Unique LF

Which of the following information is NOT output from sp_iqstatus?

• A.Active versions
• B.Number of users currently logged on
• C.Page and block size
• D.Sybase IQ release