Question

Match List I with List II

LIST I	LIST II
A. SELECT LOWER('COMPUTER');	IV. 'computer'
B. SELECT LEFT('COMPUTER', 3);	I. 'COM'
C. SELECT RIGHT('COMPUTER', 4);	II. 'UTER'
D. SELECT MID('COMPUTER', 2, 3);	III. 'OMP'

• A. A-I, B-II, C-IV, D-III
• B. A-IV, B-I, C-III, D-II
• C. A-IV, B-I, C-II, D-III
• D. A-IV, B-II, C-I, D-III

Hint:

The `MID` function in SQL allows you to extract a substring from a string, while `LEFT` and `RIGHT` extract from the beginning or end of the string respectively. The `LOWER` function is useful for case-insensitive comparisons.

Answer 1

The Correct Option is C

- The function `SELECT LOWER('COMPUTER')` converts the string to lowercase, so the correct answer for A is 'computer' (IV).
- The function `SELECT LEFT('COMPUTER', 3)` extracts the first three characters from the string 'COMPUTER', so the correct answer for B is 'com' (I).
- The function `SELECT RIGHT('COMPUTER', 4)` extracts the last four characters from the string 'COMPUTER', so the correct answer for C is 'ter' (II).
- The function `SELECT MID('COMPUTER', 2, 3)` extracts a substring starting from the second character and with a length of 3 characters, so the correct answer for D is 'omp' (III).
Therefore, the correct answer is "A-IV, B-I, C-II, D-III."