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. |
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. |
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
|