MySQL Exam Questions with Correct Answers

MySQL Exam Questions with Correct Answers A SELECT statement that includes aggregate functions is often called a/an ____________ query. - Answer-Summary All of the aggregate functions ignore null values, except for the _________ function. - Answer-COUNT By default, all duplicate values are included in the aggregate calculation, unless you specify the ______________ keyword - Answer-DISTINCT Write an aggregate expression for the number of entries in the vendor_name column - Answer-SELECT COUNT(vendor_name) FROM vendors When coding a query, you can add one or more summary rows to a result set that uses grouping and aggregates by coding the ______________ operator - Answer-with rollup A subquery can be coded in a _______________ - Answer-WHERE, FROM, SELECT or HAVING clause. A subquery can return a list of values, ________. - Answer-a table of values or a single value You can use the _________ keyword in a WHERE clause to test whether a condition is true for one or more of the values returned by the subquery - Answer-ANY When you code a subquery in a FROM clause, you must assign a/an _______ to it. - Answer-table alias When you code a subquery in a FROM clause, it returns a result set that can be referred to as an _____________. - Answer-inline view Write the code for converting the DATE data type in a column named invoice_date to the DATETIME data type - Answer-SELECT invoice_date