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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
The order of occurrence determines the order of evaluation.
NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

None of these
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.

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL