171. Which SQL keyword is used to retrieve only unique values?
A. DISTINCTIVE
B. UNIQUE
C. DISTINCT
D. DIFFERENT

172. Which SQL keyword is used to retrieve a maximum value?
A. TOP
B. MOST
C. UPPER
D. MAX

173. What is a view?
A. A view is a special stored procedure executed when certain event occurs.
B. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
C. A view is a database diagram.
D. None of these

174. Which of the following SQL commands is used to retrieve data?
A. DELETE
B. INSERT
C. SELECT
D. JOIN

175. Which of the following is a SQL aggregate function?
A. LEFT
B. AVG
C. JOIN
D. LEN

176. Which SQL statement is used to update data in a database?
A. SAVE
B. UPDATE
C. SAVE AS
D. MODIFY

177. Which SQL statement is used to delete data FROM a database?
A. COLLAPSE
B. REMOVE
C. ALTER
D. DELETE

178. Which SQL keyword is used to sort the result-set?
A. SORT BY
B. ORDER
C. ORDER BY
D. SORT

179. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
A. 6789
B. 2345
C. 1234
D. 456789

180. Which of the following group functions ignore NULL values?
A. MAX
B. COUNT
C. SUM