PRACTICE QUESTIONS MCQ - SQL MCQ

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

View Explanation
Comment

Correct AnswerOption B

Rate difficulty Rate difficulty:

Easy Medium Hard

Choose a difficulty.

Cancel reply

Your email address will not be published. Required fields are marked *

Report

Name

Save my name and email in this browser for the next time I comment.

Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name

Save my name and email in this browser for the next time I comment.

12 Which of the following is a comparison operator in SQL?

A
=
B
LIKE
C
BETWEEN
D
All of the above

View Explanation
Comment

Correct AnswerOption A

Rate difficulty Rate difficulty:

Easy Medium Hard

Choose a difficulty.

Found this useful?

Follow:

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

Cancel reply

Your email address will not be published. Required fields are marked *

Report

Name

Save my name and email in this browser for the next time I comment.

Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name

Save my name and email in this browser for the next time I comment.

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

View Explanation
Comment

Correct AnswerOption C

Rate difficulty Rate difficulty:

Easy Medium Hard

Choose a difficulty.

Cancel reply

Your email address will not be published. Required fields are marked *

Report

Name

Save my name and email in this browser for the next time I comment.

Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name

Save my name and email in this browser for the next time I comment.

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

View Explanation
Comment

Correct AnswerOption C

Rate difficulty Rate difficulty:

Easy Medium Hard

Choose a difficulty.

Cancel reply

Your email address will not be published. Required fields are marked *

Report

Name

Save my name and email in this browser for the next time I comment.

Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name

Save my name and email in this browser for the next time I comment.

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

A
POWER
B
MOD
C
ROUND
D
REMAINDER

View Explanation
Comment

Correct AnswerOption B

Rate difficulty Rate difficulty:

Easy Medium Hard

Choose a difficulty.

Cancel reply

Your email address will not be published. Required fields are marked *

Report

Name

Save my name and email in this browser for the next time I comment.

Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name

Save my name and email in this browser for the next time I comment.

First Previous 1 2 3 4 Next Last