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

Page 14 of 30
PDF with 115 Questions

What happens when a Sybase IQ Server runs out of space during a Load or Insert?

  1. Nothing
  2. Load or Insert is suspended until DBA adds more space
  3. Load or Insert fails and the entire transaction is rolled back
  4. More space is automatically allocated from RESERVE

Answer(s): C



Load table is executed with the following condition: IGNORE CONSTRAINT NULL 50, UNIQUE 100, CHECK 20, ALL 125 Rollback will occur if there are... (Choose 2)

  1. 50 NULL violations.
  2. 101 UNIQUE constraint violations.
  3. 126 total violations.
  4. 20 CHECK violations.

Answer(s): B,C



Which Database option must be set to load a table and NOT enforce Foreign Key constraints?

  1. CONVERSION_ERROR =N?CONVERSION_ERROR =?N
  2. DISABLE_RI_CHECK = N?DISABLE_RI_CHECK = ?N
  3. CONVERSION_ERROR = FF?CONVERSION_ERROR = ?FF
  4. DISABLE_RI_CHECK = FF?DISABLE_RI_CHECK = ?FF

Answer(s): B



When performing an incremental insert into an existing table with deleted rows, what is the default behavior of the newly inserted data?

  1. The new data will be added to the end of the table.
  2. Depending on the value of the SKIP option, new data will be appended to the end of the table.
  3. Depending on the value of the LIMIT option, new data will fill empty rows first and then be appended to the end of the table.
  4. New data will fill empty rows first and then be appended to the end of the table.

Answer(s): D






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

510-702 Exam Discussions & Posts