Databases MCQ with Answers

a SQL query automatically eliminates duplicates.

SQL permits attribute names to be repeated in the same relation.

a SQL query will not work if there are no indexes on the relations

None of these

CHARACTER

NUMERIC

FLOAT

All of the above

UNION

INTERSECTION

DIFFERENCE

All of the these

Dynamic Data Language

Detailed Data Language

Data Definition Language

Data Derivation Language

SELECT NULL FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE WHEN SALARY = NULL;

None of the above