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

Page 12 of 30
PDF with 115 Questions

Which of the following statements are TRUE if the command given below is executed? (Choose 2) CREATE DBSPACE MyDbspace USING FILE MyFile1 '/IQ/data/file1' SIZE 2000 RESERVE 1000;

  1. Will create a raw devicedbfile of 2000MB.
  2. The reserve of 1000MB is part of the 2000MB specified for the file.
  3. A Catalog Storedbspace is created.
  4. IQ Main Storedbspace called MyDbspace?is created.IQ Main Store dbspace called ?MyDbspace?is created.

Answer(s): B,D



Which of the following actions are permitted on partitioned tables? (Choose 2)

  1. Full-width loads
  2. Partial-width loads
  3. Split one partition into two partitions in differentdbspaces
  4. Split one partition into two partitions in the samedbspace
  5. Merge non-adjacent partitions

Answer(s): A,D



What is the preferred Sybase IQ device type?

  1. In-Memory
  2. Write Once Read Many (WORM)
  3. File System files
  4. Raw Devices

Answer(s): D



Data in a table can span ____________________ and __________________. (Choose 2)

  1. dbfiles
  2. dbspaces
  3. databases
  4. IQ Main and Catalog Store

Answer(s): A,B






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

510-702 Exam Discussions & Posts