SQL Development quiz medium level

Test description

This test checks the knowledge of developers who are up-to-date with SQL features at a medium level.
Topics: select conditions, indexes, transactions, CTE, set operators, joins, datatypes, SQL functions.

Sample questions

1
Consider a table InternalParts with the structure Id, Description, Attrib1, Attrib2, Attrib3 and the next query: Which of the following statements is true?

SELECT * FROM InternalParts WHERE 'Description' IN (Attrib1, Attrib2, Attrib3)

The query will throw an exception.

The query will select all rows which have the value of columns Attrib1, Attrib2 and Attrib3 equal to 'Description'.

The query will select all rows where the value of at least one of the columns Attrib1, Attrib2 or Attrib3 equals to 'Description'.

The query will select all rows where the value of the column Description equals to 'Attrib1' or 'Attrib2' or 'Attrib3'.

Results between 1-5 / 20	33.7%
Results between 6-10 / 20	47.58%
Results between 11-15 / 20	15.86%
Results between 16-20 / 20	2.86%
Average results 8 / 20

SQL Development quiz medium level

Test description

Sample questions

Related tests

PostgreSQL quiz medium level

PostgreSQL DBA quiz medium level

SQL Server DBA quiz medium level

SQL quiz advanced level

MySQL Development quiz advanced level