DESIGN OF STEEL STRUCTURE QUIZ

SQL is a data sublanguage.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints

9

5

10

0

TRUE ANSWER : ?
YOUR ANSWER : ?

The wildcard in a WHERE clause is useful when?

An exact match is not possible in a SELECT statement.

An exact match is necessary in a SELECT statement.

An exact match is necessary in a CREATE statement.

An exact match is not possible in a CREATE statement.

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL is a programming language.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL keyword BETWEEN is used:

None of these

for ranges.

to limit the columns displayed.

as a wildcard.

TRUE ANSWER : ?
YOUR ANSWER : ?

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

LIKE only.

IN only.

Both IN and NOT IN.

NOT IN only.

TRUE ANSWER : ?
YOUR ANSWER : ?

A dynamic view is one whose contents materialize when referenced.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following group functions ignore NULL values?

COUNT

All of these

SUM

MAX

TRUE ANSWER : ?
YOUR ANSWER : ?

Count function in SQL returns the number of

groups.

distinct values.

values.

columns.

TRUE ANSWER : ?
YOUR ANSWER : ?