INTRODUCTION TO SQL QUIZ

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL statement is used to update data in a database?

UPDATE

SAVE AS

SAVE

MODIFY

TRUE ANSWER : ?
YOUR ANSWER : ?

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?