Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

brackets -- [...].
braces -- {...}.
parenthesis -- (...) .
CAPITAL LETTERS.

ANSWER DOWNLOAD EXAMIANS APP

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

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
AND will be evaluated first; OR will be evaluated second; NOT 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
A view is which of the following?

A base table that can be accessed via SQL commands
A virtual table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands

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

ANSWER DOWNLOAD EXAMIANS APP