List of top Computer Science Questions on SQL Functions

Which of the following are single row functions?
A. MAX()
B. SUM()
C. MOD()
D. DAY()

Which of the following statement will correctly filter products having an average price of 50?

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'

Which SQL function will return the following output:
mysql> Select __?__ (53, 10);
output __3

Vardan was asked by his teacher the meaning of the following command. He is not able to decide on the correct answer. Help him in selecting the correct answer.
Select * from stud where admn like '\%5\%5\%';

Match List I with List II:

LIST I	LIST II
A. Alter	I. Change the name of the column
B. Update	II. Update existing information in a table
C. Delete	III. Delete an existing row from table
D. Create	IV. Create a database

Choose the correct answer from the options given below: