www.McqFinder.in

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

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

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;

Databases MCQ with Answers

For more MCQ's Click Here

Related Databases MCQ with Answers

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

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

POWER

MOD

ROUND

REMAINDER

Answer is:

MOD

116) A data manipulation command the combines the records from one or more tables is called

SELECT

PROJECT

JOIN

PRODUCT

Answer is:

JOIN

Databases MCQ with Answers

For more MCQ's Click Here