INTRODUCTION TO SQL QUIZ

SQL can be used to:

All of these

modify database data only.

query database data only.

create database structures only.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following group functions ignore NULL values?

MAX

All of these

COUNT

SUM

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 > ALL (SELECT SALARY FROM EMPLOYEE);prints

9

5

0

10

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following SQL commands is used to retrieve data?

INSERT

DELETE

JOIN

SELECT

TRUE ANSWER : ?
YOUR ANSWER : ?

The result of every SQL query is a table.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

What operator tests column for the absence of data?

IS NULL operator

None of these

NOT operator

EXISTS operator

TRUE ANSWER : ?
YOUR ANSWER : ?

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all records meeting the full criteria are to be returned.

all records with even partial criteria met are to be returned.

None of these

all columns of the table are to be returned.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following join is also called as an 'inner-join'?

Non-Equijoin

Equijoin

None of these

Self-Join

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑