Introduction to SQL Questions and Answers

Q: ON UPDATE CASCADE ensures which of the following?

Correct answer: Data IntegrityON UPDATE CASCADE is part of a foreign key definition. When the referenced key changes in the parent table, the change is propagated automatically to every matching row in the child table.That preserves referential integrity: without it, changing a parent key would either be refused or leave child rows pointing at a value that no longer exists. Normalization is a matter of table design rather than of runtime behaviour, and materialized views are a storage feature. The related clause ON DELETE CASCADE does the same work for deletions.

Q: The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Correct answer: TrueGROUP BY collects rows sharing the same value in the named column or columns into a single group, and the aggregate functions in the SELECT list are then computed once per group.Two rules follow. Every column in the SELECT list must either appear in the GROUP BY or be inside an aggregate, since anything else has no single value per group. And filtering on the aggregates belongs in HAVING, which runs after the grouping, rather than in WHERE, which runs before it.

Q: The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Correct answer: TrueA plain SELECT returns every row that matches, duplicates included, because SQL tables are multisets rather than true sets. To collapse repeats, DISTINCT must be stated explicitly.Two details are worth knowing. It applies to the whole selected row, so SELECT DISTINCT city, state removes only rows where both values repeat. And it is not free: the engine must sort or hash the result to find the duplicates, so on a large result set the cost is real.

Q: SQL can be used to:

Correct answer: All of the above can be done by SQL.SQL is a complete database language and covers all three. Creating structures is its data definition half, through CREATE, ALTER and DROP; querying and modifying data is its manipulation half, through SELECT, INSERT, UPDATE and DELETE.A third part, data control, grants and revokes permissions. That breadth is precisely what made SQL displace the earlier database models, which needed separate languages for schema definition and for data access.

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

Correct answer: Both IN and NOT INA chain of OR conditions on the same column collapses into a single IN: state = 'VA' OR state = 'MD' OR state = 'DC' becomes state IN ('VA','MD','DC'), and its negation becomes NOT IN.The gain is more than brevity. Long AND and OR chains need careful parenthesising, since AND binds tighter than OR and a missing bracket changes the meaning silently. IN removes the precedence question entirely. LIKE is for patterns and does not combine value lists.

Q: Select * from employee What type of statement is this?

Correct answer: DMLSELECT reads data from a relation without altering any structure, so it is a Data Manipulation Language statement.DML has four members - SELECT, INSERT, UPDATE and DELETE - and SELECT is the only one that does not modify anything, which is why some texts place it in a query sublanguage of its own. A view would be created by a DDL statement, and an integrity constraint is a rule declared as part of a table definition.

Q: The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Correct answer: FalseThe SQL-92 wildcard for "any sequence of characters" is the percent sign %, used with LIKE, and the underscore _ matches exactly one character.The asterisk does appear in SQL, but in the SELECT list, where SELECT * means all columns - a different construct entirely. It serves as a wildcard character in Microsoft Access, which departs from the standard, and a pattern written for Access silently returns nothing elsewhere because * is then matched literally.

101.

ON UPDATE CASCADE ensures which of the following?

A.Normalization
B.Data Integrity
C.Materialized Views
D.All of the above.

Answer: B

Correct answer: Data Integrity

ON UPDATE CASCADE is part of a foreign key definition. When the referenced key changes in the parent table, the change is propagated automatically to every matching row in the child table.

That preserves referential integrity: without it, changing a parent key would either be refused or leave child rows pointing at a value that no longer exists. Normalization is a matter of table design rather than of runtime behaviour, and materialized views are a storage feature. The related clause ON DELETE CASCADE does the same work for deletions.

Discuss in Forum

102.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

A.True
B.False

Answer: A

Correct answer: True

GROUP BY collects rows sharing the same value in the named column or columns into a single group, and the aggregate functions in the SELECT list are then computed once per group.

Two rules follow. Every column in the SELECT list must either appear in the GROUP BY or be inside an aggregate, since anything else has no single value per group. And filtering on the aggregates belongs in HAVING, which runs after the grouping, rather than in WHERE, which runs before it.

Discuss in Forum

103.

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

A.True
B.False

Answer: A

Correct answer: True

A plain SELECT returns every row that matches, duplicates included, because SQL tables are multisets rather than true sets. To collapse repeats, DISTINCT must be stated explicitly.

Two details are worth knowing. It applies to the whole selected row, so SELECT DISTINCT city, state removes only rows where both values repeat. And it is not free: the engine must sort or hash the result to find the duplicates, so on a large result set the cost is real.

Discuss in Forum

104.

The HAVING clause does which of the following?

A.Acts like a WHERE clause but is used for groups rather than rows.
B.Acts like a WHERE clause but is used for rows rather than columns.
C.Acts like a WHERE clause but is used for columns rather than groups.
D.Acts EXACTLY like a WHERE clause.

Answer: A

Correct answer: Acts like a WHERE clause but is used for groups rather than rows.

HAVING filters after aggregation, WHERE before it, and the order is what makes them different rather than redundant.

WHERE decides which rows enter the groups; GROUP BY forms them; HAVING then decides which groups survive, and it may test aggregate values. So HAVING COUNT(*) > 5 is legal and WHERE COUNT(*) > 5 is not, because at the time WHERE runs no group exists to count. That is also why filtering on plain columns belongs in WHERE, where it reduces the work.

Discuss in Forum

105.

SQL can be used to:

A.create database structures only.
B.query database data only.
C.modify database data only.
D.All of the above can be done by SQL.

Answer: D

Correct answer: All of the above can be done by SQL.

SQL is a complete database language and covers all three. Creating structures is its data definition half, through CREATE, ALTER and DROP; querying and modifying data is its manipulation half, through SELECT, INSERT, UPDATE and DELETE.

A third part, data control, grants and revokes permissions. That breadth is precisely what made SQL displace the earlier database models, which needed separate languages for schema definition and for data access.

Discuss in Forum

106.

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

A.LIKE only.
B.IN only.
C.NOT IN only.
D.Both IN and NOT IN.

Answer: D

Correct answer: Both IN and NOT IN

A chain of OR conditions on the same column collapses into a single IN: state = 'VA' OR state = 'MD' OR state = 'DC' becomes state IN ('VA','MD','DC'), and its negation becomes NOT IN.

The gain is more than brevity. Long AND and OR chains need careful parenthesising, since AND binds tighter than OR and a missing bracket changes the meaning silently. IN removes the precedence question entirely. LIKE is for patterns and does not combine value lists.

Discuss in Forum

107.

Select * from employee What type of statement is this?

A.DML
B.DDL
C.View
D.Integrity constraint

Answer: A

Correct answer: DML

SELECT reads data from a relation without altering any structure, so it is a Data Manipulation Language statement.

DML has four members - SELECT, INSERT, UPDATE and DELETE - and SELECT is the only one that does not modify anything, which is why some texts place it in a query sublanguage of its own. A view would be created by a DDL statement, and an integrity constraint is a rule declared as part of a table definition.

Discuss in Forum

108.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

A.True
B.False

Answer: B

Correct answer: False

The SQL-92 wildcard for "any sequence of characters" is the percent sign %, used with LIKE, and the underscore _ matches exactly one character.

The asterisk does appear in SQL, but in the SELECT list, where SELECT * means all columns - a different construct entirely. It serves as a wildcard character in Microsoft Access, which departs from the standard, and a pattern written for Access silently returns nothing elsewhere because * is then matched literally.

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