SQL MCQ Questions and answers Page-4 section-1

Section 1 Section 2

16.
Which SQL statement is used to update data in a database?

A. SAVE

B. UPDATE

C. SAVE AS

D. MODIFY

Answer & Solution Discuss in Board Save for Later

17.
Which SQL statement is used to delete data FROM a database?

A. COLLAPSE

B. REMOVE

C. ALTER

D. DELETE

Answer & Solution Discuss in Board Save for Later

18.
Which SQL keyword is used to sort the result-set?

A. SORT BY

B. ORDER

C. ORDER BY

D. SORT

Answer & Solution Discuss in Board Save for Later

19.
The SQL statement
SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

A. 6789

B. 2345

C. 1234

D. 456789

Answer & Solution Discuss in Board Save for Later

20.
Which of the following group functions ignore NULL values?

A. MAX

B. COUNT

C. SUM

D. All of the above

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10 11 12 13 14

SQL MCQ Questions and answers

16. Which SQL statement is used to update data in a database?

Answer & Solution

17. Which SQL statement is used to delete data FROM a database?

Answer & Solution

18. Which SQL keyword is used to sort the result-set?

Answer & Solution

19. The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

Answer & Solution

20. Which of the following group functions ignore NULL values?

Answer & Solution

Read More Section(Sql Miscellaneous)

16.
Which SQL statement is used to update data in a database?

17.
Which SQL statement is used to delete data FROM a database?

18.
Which SQL keyword is used to sort the result-set?

19.
The SQL statement
SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

20.
Which of the following group functions ignore NULL values?