Introduction to SQL
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

Both A and B
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

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.
A view is a database diagram.
A view is a special stored procedure executed when certain event occurs.
None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The HAVING clause does which of the following?

Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for groups rather than rows.
Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for rows rather than columns.

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL