510-702 무료 덤프문제 온라인 액세스

What is the state of the dbspace when the database starts but one or more files cannot be opened?

• A.Dbspace will be online.
• B.Dbspace will be dynamically online.
• C.Dbspace will be offline.
• D.Dbspace will be dynamically offline.

What parameter is used to limit the number of user connections to the Sybase IQ server?

• A.-gm
• B.-gc
• C.-cl
• D.-gl
• E.-gd

If the multiplex coordinator fails, what happens? (Choose 2)

• A.The failover node automatically assumes the role of Coordinator.
• B.All writers in the multiplex will shut down.
• C.All nodes in the multiplex will shut down.
• D.Another node must be manually promoted to Coordinator to continue DML operations.
• E.The entire multiplex is placed in a read-only state.

What database option will cause Sybase IQ to provide index recommendations?

• A.MINIMIZE_STORAGE
• B.INDEX_PREFERENCE
• C.INDEX_ADVISOR
• D.NOEXEC

Which stored procedure can show fragmentation of the FP index?

• A.sp_iqcolumn
• B.sp_iqtableinfo
• C.sp_iqrowdensity
• D.sp_iqspaceused