46. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints
47. Which of the following SQL commands can be used to add data to a database table?
48. Which of the following join is also called as an 'inner-join'?
49. Which of the following is NOT a type of SQL constraint?
50. What is an SQL virtual table that is constructed from other tables?
Read More Section(Sql Miscellaneous)
Each Section contains maximum 70 questions. To get more questions visit other sections.