www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
Engineering
Computer Science
Computer Science Set-1
Databases
109

Databases MCQ with Answers

109) Which of the following operations need the participating relations to be union compatible?

UNION

INTERSECTION

DIFFERENCE

All of the these

Answer is:

All of the these

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

111) Which of the following is a legal expression in SQL?

SELECT NULL FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE WHEN SALARY = NULL;

None of the above

Answer is:

SELECT NAME FROM EMPLOYEE;

112) Which of the following is a comparison operator in SQL?

=

LIKE

BETWEEN

All of the above

Answer is:

=

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

UPDATE TABLE

TRUNCATE COLUMN

ALTER , DROP

DELETE COLUMN

Answer is:

ALTER , DROP

Explanation:

ALTER , DROP command is used to delete a particular column in a relation.

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

BETWEEN

ANY

IN

ALL

Answer is:

IN

Databases MCQ with Answers

For more MCQ's Click Here