[Solved] Which of the following is a legal expression in SQL?

McqMate

Q.	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 WHERE SALARY = NULL;
D.	none of the above
Answer» B. SELECT NAME FROM EMPLOYEE;

998

0

Do you find this helpful?

1

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
dump, writes out SQL DDL statements and SQL insert statements to a ﬁle, which can then be reexecuted to re- create the database.
Which SQL function is used to count the number of rows in a SQL query?
Which of the following invokes functions in sql?
Which of the following is used as the embedded SQL in COBOL?
Which of the following is used to distinguish the variables in SQL from the host language variables?
Which of the following SQL command can be used to modify existing data in a database table?
Which of the following statements is/are not true for SQL proﬁler?
Which of the following is the original purpose of SQL?
Which of the following is NOT a type of SQL constraint?