QUESTION: 49

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

50 percent of the size of the IQ Main Store
Equal to the size of the IQ Main Store
20 percent of the size of the IQ Main Store
10 percent of the size of the IQ Main Store

Answer(s): C

Reveal Solution Next Question

QUESTION: 50

By default, a table is created in which dbspace?

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

Answer(s): C

Reveal Solution Next Question

QUESTION: 51

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?

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

Answer(s): C

Reveal Solution Next Question

QUESTION: 52

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

Client-side bulk loading allows data to be loaded from files located on the client.
The character set of the file on the client must match the server collation.
Client-side bulk data loading does not incur any extra disk space overhead on the server.
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

Reveal Solution Next Question

Free 510-702 Exam Braindumps (page: 13)

QUESTION: 49

QUESTION: 50

QUESTION: 51

QUESTION: 52