第4部分

coolmax

31. From which of the following does the LOAD TABLE command load data?
ASCII or Binary Data Files
Other Sybase Database Servers
Other IQ Tables
Remote/ Foreign Database Servers

32. By default, where do Sybase IQ query plans appear?
In a file in the database directory
In the client program, such as dbisql
In the IQ messages file
In the transaction log

33. If you execute the following sequence of statements in the order shown, what are the contents of the “outfile”? create table foo (col1 int); insert into foo values (1); insert into foo values (2); commit; set temporary option TEMP_EXTRACT_NAME1=”outfile”; select count(*) from foo; select * from foo; At this point, the contents of the file named “outfile” are:
1,2,
2,1,
count(*), 2
empty.

34. What types of select queries will use the Word (WD) index? (Choose 2):
Queries that use LIKE
Queries that use GROUP BY
Queries that use the CONTAINS query verb
Queries that use BETWEEN

35. With a WD index on “address”, the statement “select * from customers where address contains(‘Ave’, ‘1255’)” will do which of the following?
Return all rows that contain either ‘Ave’ or ‘1255’
Return only rows that contain both ‘Ave’ and ‘1255’
Iignore the WD index and choose the FP index
Fail on a syntax error

36. Select three methods to add users to a Sybase IQ server. (Choose 3)
CREATE LOGIN
GRANT CONNECT
sp_iqaddlogin
sp_adduser
Sybase Central

37. Which is the overall authority for database management?
DBA
dbo
PUBLIC
sa
SYS

38. Which of the following can be used to add users to an IQ server? (Choose 2)
grant connect
sp_iq_process_login
sp_iqaddlogin
sp_iqmodifyadmin

39. Sybase IQ enforces which ANSI Isolation Level:
Level 0
Level 1
Level 2
Level 3

40. What is TRUE about “snapshot versioning”? (Choose 2)
Allows one reader and multiple writers per table
Allows multiple readers and one writer per table
Also referred to as table-level versioning
Supports ANSI isolation level 2