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 :

Click on Discuss to view users comments.

Write your comments here:



12:  

Which of the following is a comparison operator in SQL?

A.

=

B.

LIKE

C.

BETWEEN

D.

All of the above

 
 

Option: A

Explanation :

Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types

References :- MSDN Link 

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Supiksha Jain said: (4:59pm on Thursday 24th May 2018)
Call can't possible. Because DROP delete the entire table and DELETE deletes the entire column or row

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



15:  

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

A.

POWER

B.

MOD

C.

ROUND

D.

REMAINDER

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here: