Classical

Database MCQ - Query languages SQL

11:  

Which of the following is a legal expression in SQL?

A.

SELECT NULL FROM EMPLOYEE;

B.

SELECT NAME FROM EMPLOYEE;

C.

SELECT NAME FROM EMPLOYEE WHEN SALARY = NULL;

D.

None of the above

 
 

Option: B

Explanation :


12:  

Which of the following is a comparison operator in SQL?

A.

=

B.

LIKE

C.

BETWEEN

D.

All of the above

 
 

Option: A

Explanation :

References :- MSDN Link 


13:  

To delete a particular column in a relation the command used is:

A.

UPDATE TABLE

B.

TRUNCATE COLUMN

C.

ALTER , DROP

D.

DELETE COLUMN

 
 

Option: C

Explanation :


14:  

The ______ operator is used to compare a value to a list of literals values that have been specified.

A.

BETWEEN

B.

ANY

C.

IN

D.

ALL

 
 

Option: C

Explanation :


15:  

_____________ function divides one numeric expression by another and returns the remainder

A.

POWER

B.

MOD

C.

ROUND

D.

REMAINDER

 
 

Option: B

Explanation :




Suggest an improvement