CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Sybase
  5. 510-702

Free 510-702 Exam Braindumps (page: 7)

Page 6 of 30
PDF with 115 Questions

Which stored procedure can determine when an index was last used?

  1. sp_iqtableuse
  2. sp_iqstatus
  3. sp_iqindexmetadata
  4. sp_iqindexuse

Answer(s): D



Which of the following is TRUE of the TRUNCATE TABLE command? (Choose 2)

  1. All rows are deleted.
  2. Indexes are removed.
  3. The operation is logged.
  4. The operation is non-logged.
  5. The operation can be rolled back.

Answer(s): A,D



Which of the following circumstances warrant performing routine IQ Index Maintenance?
(Choose 2)

  1. A table was created with MINIMIZE_STORAGE='OFF'
  2. After every data load
  3. Cardinality of a column has changed, permitting a possible rebuilding with an optimized FP index
  4. 7 Days have passed since last index maintenance

Answer(s): A,C



Which index type is recommended for better performance on columns used in table joins?

  1. LF
  2. HG
  3. HNG
  4. DTTM

Answer(s): B






Post your Comments and Discuss Sybase 510-702 exam with other Community members:

510-702 Exam Discussions & Posts