1. Using concatenation, the following code should return what?

CITY + '(' + STATE + ')'

a. CITY( STATE )

b. CITY(+STATE+)

c. CITY(STATE)

d. CITY (STATE)

2. Consider this SQL code:

CONCAT(RTRIM(vend_name), ' (', RTRIM(vend_country), ')')

What will it do to this record (note the trailing white spaces)?

vend_name: "Vendor Time "

vend_country: "Canada "

a. Vendor Time (Canada)

b. Vendor Time(Canada )

c. Vendor Time (Canada)

d. Vendor (Canada )

e. Vendor(Canada)

3. Common reasons to use an ALIAS include (Select All)

a. Real column name contains illegal characters.

b. Synthesizing the column name if the original name is ambigious.

c. Expanding the column name if the original name is too long.

d. Expanding the column name if the original name is easy to read.

4. Which of the following are legal numerical operators?(Select All)

a. -

b. *

c. /

d. %

5. What does the following SQL code return?

select substr('UCLA Extension',7,2) as substring;

a. xt

b. te

c. CLA Ext

d. LA Exte

6. Which of the following are commonly used numeric manipulation functions? (Select All)

a. ABS()

b. EXP()

c. SQRT()

d. PI()