Introduction to SQL
A subquery in an SQL SELECT statement:

can only be used with two tables.
cannot have its results sorted using ORDER BY.
can always be duplicated by a join.
has a distinct form that cannot be duplicated by a join.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

not a value
the same as 0 for integer and blank for character
the same as 0 for integer
the same as blank for character

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Introduction to SQL