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

Page 13 of 30
PDF with 115 Questions

In planning to create a new database, what is typically the initial size of the IQ Temporary Store?

  1. 50 percent of the size of the IQ Main Store
  2. Equal to the size of the IQ Main Store
  3. 20 percent of the size of the IQ Main Store
  4. 10 percent of the size of the IQ Main Store

Answer(s): C



By default, a table is created in which dbspace?

  1. Thedbspace with the most amount of free space.
  2. Thedbspace with the largest amount of contiguous free space.
  3. Thedbspace specified with the DEFAULT_DBSPACE option.
  4. The table is striped across all read-writedbspaces.

Answer(s): C



What happens to the loading process when character data is inserted into an integer column when the database option CONVERSION_ERROR is set to N?to ?N?

  1. NULL is inserted into the column in the row
  2. Data conversion error will be ignored
  3. Load will stop and cause a rollback
  4. Conversion error messages are sent to the IQ Message File

Answer(s): C



All of the following statements are TRUE regarding client-side bulk data loading EXCEPT:

  1. Client-side bulk loading allows data to be loaded from files located on the client.
  2. The character set of the file on the client must match the server collation.
  3. Client-side bulk data loading does not incur any extra disk space overhead on the server.
  4. Sybase IQ will process files in the file list of the LOAD TABLESING CLIENT FILE command inparallel.Sybase IQ will process files in the file list of the LOAD TABLE?SING CLIENT FILE command in parallel.

Answer(s): D






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

510-702 Exam Discussions & Posts