SQL Quiz

Which of the following is the correct order of occurrence in a typical SQL statement?

• select, group by, where, having

• select, where, group by, having

• select, where, having, group by

• select, having, where, group by

Which of the following is TRUE about SQL Concatenate?

• It is also possible to combine more than two strings into one string.

• Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.

• When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.

• All of the above

To connect strings, which function is used -

• CONNECT

• ADD

• COMBINE

• CONCAT

Which of the following is not a valid aggregate function?

• COUNT

• COMPUTE

• SUM

• MAX

Which data manipulation command is used to combine the records from one or more tables?

• SELECT

• PROJECT

• JOIN

• PRODUCT

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

• DESC

• ASC

• There is no default value

• None of the mentioned

Which of the following is true about the HAVING clause?

• Similar to the WHERE clause but is used for columns rather than groups.

• Similar to WHERE clause but is used for rows rather than columns.

• Similar to WHERE clause but is used for groups rather than rows.

• Acts exactly like a WHERE clause.

Which of the following is true about the SQL AS clause?

• The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.

• The SQL AS clause can only be used with the JOIN clause.

• The AS clause in SQL is used to define a search condition.

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

• UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

• MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

• MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

• UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

A CASE SQL statement is _______?

• A way to establish a loop in SQL.

• A way to establish an IF-THEN-ELSE in SQL

• A way to establish a data definition in SQL

• All of the above.