Introduction to SQL Questions and Answers

Q: The benefits of a standard relational language include which of the following?

Correct answer: Reduced training costsA standard language means the skill transfers. Someone who knows SQL can work with Oracle, PostgreSQL, MySQL or SQL Server without learning a new query language for each, so training costs fall and staff are easier to recruit.The second option states the opposite of a benefit: a standard reduces dependence on a single vendor, since applications can be moved. And applications are certainly still needed - SQL queries the data; it does not supply the interface or the business logic around it.

Q: In SQL, the WHERE clause filters rows before grouping while HAVING filters after grouping.

Correct answer: TrueWHERE is applied to individual rows before GROUP BY forms the groups, so it cannot refer to an aggregate. HAVING is applied to the groups afterwards, which is why a condition such as COUNT(*) greater than 5 must go there.

Q: There is an equivalent join expression that can be substituted for all subquery expressions.

Correct answer: FalseSome subqueries have no join equivalent. A correlated NOT EXISTS, or a comparison against an aggregate of a related set such as WHERE salary > (SELECT AVG(salary) FROM emp), cannot be expressed as a join.The reason is structural: a join produces rows by combining them, whereas a subquery can return a single computed value or merely test whether any row exists. Many subqueries can be rewritten as joins, and doing so sometimes helps the optimiser - but the statement claims all of them can, and that is what makes it false.

Q: The SQL WHERE clause:

Correct answer: limits the row data are returned.WHERE is a filter on rows: it tests each candidate row against a condition and keeps those for which the condition is true.Which columns come back is decided in the SELECT list instead. The distinction is worth holding onto because the two operations are separate in relational terms - selection chooses rows, projection chooses columns - and SQL expresses them in different clauses. Since WHERE does only the first, the option claiming both is wrong.

Q: DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Correct answer: FalseDISTINCT and ALL qualify the SELECT list as a whole and may appear only once, immediately after SELECT. They are mutually exclusive, and ALL - keep duplicates - is the default.What can appear more than once is DISTINCT inside aggregate functions, as in COUNT(DISTINCT city) alongside SUM(DISTINCT amount). That is a different construct with a different scope: it de-duplicates the values fed to one function rather than the rows of the result.

Q: Which of the following are the five built-in functions provided by SQL?

Correct answer: COUNT, SUM, AVG, MAX, MINThese five are the standard aggregate functions, each reducing a set of rows to a single value: how many, the total, the mean, the largest and the smallest.They are usually paired with GROUP BY, which computes one such value per group, and with HAVING, which filters on the result. Two points of behaviour are worth remembering: they ignore nulls, except COUNT(*) which counts rows regardless; and MULT, DIV and NAME in the distractors are not SQL functions at all.

Q: The condition in a WHERE clause can refer to only one value.

Correct answer: FalseA WHERE condition can refer to as many values as needed. IN takes a list, BETWEEN takes two bounds, and AND and OR combine any number of conditions across any number of columns.A condition may also refer to values it does not name, through a subquery: WHERE id IN (SELECT id FROM other) tests against a whole set computed at run time. The single-value comparison is merely the simplest case, not the limit of the clause.

Q: You can add a row using SQL in a database with which of the following?

Correct answer: INSERTINSERT is the SQL statement that adds rows to a table, in the form INSERT INTO table (col1, col2) VALUES (v1, v2), or with a SELECT in place of VALUES to add many rows from a query.The distractors trade on the difference between data and structure. CREATE belongs to the data definition language and makes the table itself, not a row in it; ADD appears only as part of ALTER TABLE ... ADD COLUMN, which again changes structure; and MAKE is not SQL at all.

Q: To remove a relation from an SQL database, we use the ______ command.

Correct answer: Drop tableDROP TABLE removes the relation entirely - its rows, its definition, its indexes and its constraints - leaving no object of that name.DELETE is the near-miss and the distinction is important: it removes rows but keeps the table, so an empty relation remains ready for new data. DROP is a DDL statement and DELETE a DML one. Purge and Remove are not standard SQL for this purpose.

Q: The Microsoft Access wildcards are ____ and ____ .

Correct answer: question mark (?); asterisk (*)Microsoft Access departs from the SQL standard here. It uses * for any sequence of characters and ? for exactly one - the same characters MS-DOS used for file matching.Standard SQL uses % and _ for those two roles. The difference is a practical trap: a query written in Access and moved to another engine does not fail with an error but simply returns nothing, because * is then matched as a literal asterisk. Access in ANSI-92 mode accepts the standard characters instead.

31.

The benefits of a standard relational language include which of the following?

A.Reduced training costs
B.Increased dependence on a single vendor
C.Applications are not needed.
D.All of the above.

Answer: A

Correct answer: Reduced training costs

A standard language means the skill transfers. Someone who knows SQL can work with Oracle, PostgreSQL, MySQL or SQL Server without learning a new query language for each, so training costs fall and staff are easier to recruit.

The second option states the opposite of a benefit: a standard reduces dependence on a single vendor, since applications can be moved. And applications are certainly still needed - SQL queries the data; it does not supply the interface or the business logic around it.

Discuss in Forum

32.

In SQL, the WHERE clause filters rows before grouping while HAVING filters after grouping.

A.True
B.False

Answer: B

Correct answer: True

WHERE is applied to individual rows before GROUP BY forms the groups, so it cannot refer to an aggregate. HAVING is applied to the groups afterwards, which is why a condition such as COUNT(*) greater than 5 must go there.

Discuss in Forum

33.

There is an equivalent join expression that can be substituted for all subquery expressions.

A.True
B.False

Answer: B

Correct answer: False

Some subqueries have no join equivalent. A correlated NOT EXISTS, or a comparison against an aggregate of a related set such as WHERE salary > (SELECT AVG(salary) FROM emp), cannot be expressed as a join.

The reason is structural: a join produces rows by combining them, whereas a subquery can return a single computed value or merely test whether any row exists. Many subqueries can be rewritten as joins, and doing so sometimes helps the optimiser - but the statement claims all of them can, and that is what makes it false.

Discuss in Forum

34.

The SQL WHERE clause:

A.limits the column data that are returned.
B.limits the row data are returned.
C.Both A and B are correct.
D.Neither A nor B are correct.

Answer: B

Correct answer: limits the row data are returned.

WHERE is a filter on rows: it tests each candidate row against a condition and keeps those for which the condition is true.

Which columns come back is decided in the SELECT list instead. The distinction is worth holding onto because the two operations are separate in relational terms - selection chooses rows, projection chooses columns - and SQL expresses them in different clauses. Since WHERE does only the first, the option claiming both is wrong.

Discuss in Forum

35.

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

A.True
B.False

Answer: B

Correct answer: False

DISTINCT and ALL qualify the SELECT list as a whole and may appear only once, immediately after SELECT. They are mutually exclusive, and ALL - keep duplicates - is the default.

What can appear more than once is DISTINCT inside aggregate functions, as in COUNT(DISTINCT city) alongside SUM(DISTINCT amount). That is a different construct with a different scope: it de-duplicates the values fed to one function rather than the rows of the result.

Discuss in Forum

36.

Which of the following are the five built-in functions provided by SQL?

A.COUNT, SUM, AVG, MAX, MIN
B.SUM, AVG, MIN, MAX, MULT
C.SUM, AVG, MULT, DIV, MIN
D.SUM, AVG, MIN, MAX, NAME

Answer: A

Correct answer: COUNT, SUM, AVG, MAX, MIN

These five are the standard aggregate functions, each reducing a set of rows to a single value: how many, the total, the mean, the largest and the smallest.

They are usually paired with GROUP BY, which computes one such value per group, and with HAVING, which filters on the result. Two points of behaviour are worth remembering: they ignore nulls, except COUNT(*) which counts rows regardless; and MULT, DIV and NAME in the distractors are not SQL functions at all.

Discuss in Forum

37.

The condition in a WHERE clause can refer to only one value.

A.True
B.False

Answer: B

Correct answer: False

A WHERE condition can refer to as many values as needed. IN takes a list, BETWEEN takes two bounds, and AND and OR combine any number of conditions across any number of columns.

A condition may also refer to values it does not name, through a subquery: WHERE id IN (SELECT id FROM other) tests against a whole set computed at run time. The single-value comparison is merely the simplest case, not the limit of the clause.

Discuss in Forum

38.

You can add a row using SQL in a database with which of the following?

A.ADD
B.CREATE
C.INSERT
D.MAKE

Answer: C

Correct answer: INSERT

INSERT is the SQL statement that adds rows to a table, in the form INSERT INTO table (col1, col2) VALUES (v1, v2), or with a SELECT in place of VALUES to add many rows from a query.

The distractors trade on the difference between data and structure. CREATE belongs to the data definition language and makes the table itself, not a row in it; ADD appears only as part of ALTER TABLE ... ADD COLUMN, which again changes structure; and MAKE is not SQL at all.

Discuss in Forum

39.

To remove a relation from an SQL database, we use the ______ command.

A. Delete
B. Purge
C.Remove
D.Drop table

Answer: D

Correct answer: Drop table

DROP TABLE removes the relation entirely - its rows, its definition, its indexes and its constraints - leaving no object of that name.

DELETE is the near-miss and the distinction is important: it removes rows but keeps the table, so an empty relation remains ready for new data. DROP is a DDL statement and DELETE a DML one. Purge and Remove are not standard SQL for this purpose.

Discuss in Forum

40.

The Microsoft Access wildcards are ____ and ____ .

A.asterisk (*); percent sign (%)
B.percent sign (%); underscore (_)
C.underscore(_); question mark (?)
D.question mark (?); asterisk (*)

Answer: D

Correct answer: question mark (?); asterisk (*)

Microsoft Access departs from the SQL standard here. It uses * for any sequence of characters and ? for exactly one - the same characters MS-DOS used for file matching.

Standard SQL uses % and _ for those two roles. The difference is a practical trap: a query written in Access and moved to another engine does not fail with an error but simply returns nothing, because * is then matched as a literal asterisk. Access in ANSI-92 mode accepts the standard characters instead.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Introduction to SQL Questions and Answers || Introduction to SQL MCQ Questions and Answers || Introduction to SQL GK Questions and Answers || Introduction to SQL GK MCQ Questions || Introduction to SQL Multiple Choice Questions and Answers || Introduction to SQL GK || GK on Introduction to SQL || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Introduction to SQL Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications