Which of the following function retrieves the average of a selected column of rows in a table?

(a)

Add()

(b)

SUM()

(c)

AVG( )

(d)

AVERAGE()

The function that returns the largest value of the selected column is

(a)

MAX()

(b)

LARGE()

(c)

HIGH()

(d)

MAXIMUM()

Which of the following is called the master table?

(a)

sqlite_master

(b)

sql_master

(c)

main_master

(d)

master_main

The most commonly used statement in SQL is

(a)

cursor

(b)

select

(c)

execute

(d)

commit

Which of the following clause avoide the duplicate?

(a)

Distinct

(b)

Remove

(c)

Where

(d)

GroupBy