Introduction to SQL
Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints

10
0
5
9

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and age <80;
SELECT name, course_name FROM student WHERE age>50 and <80;
SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a database diagram.
A view is a special stored procedure executed when certain event occurs.
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
None of these

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL