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: 8)

Page 7 of 30
PDF with 115 Questions

Which of the following statements are TRUE with respect to CREATE DATABASE parameters?
(Choose 2)

  1. Case respect provides better query performance than case ignore.
  2. Case ignore provides better query performance than case respect.
  3. Given that the database has very wide tables and a Catalog page size of 4K, increase Catalog page size to improve performance.
  4. Given that the database has very wide tables and a Catalog page size of 4K, decrease Catalog page size to improve performance.

Answer(s): A,C



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

  1. MINIMIZE_STORAGE
  2. INDEX_ADVISOR
  3. NOEXEC
  4. INDEX_PREFERENCE

Answer(s): B



Which of the following indexes are allowed on a column of data type DATETIME? (Choose 3)

  1. DATE
  2. DTTM
  3. FP
  4. HG
  5. TIME

Answer(s): B,C,D



Given a VARCHAR field of 100 bytes, how much space is needed to store the data in a Flat FP prior to compression?

  1. 100 bytes
  2. 101 bytes
  3. Varies based on the amount in use
  4. 1 bit per distinct value

Answer(s): B






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

510-702 Exam Discussions & Posts