This Quiz contains totally 25 Questions each carry 1 point for you.
1. What is the DISTINCT statement used for in SQL?
Sum all values in a column
Eliminate duplicate rows in the result
Join two tables together
Delete records from a table
Correct!
Wrong!
2. What does the COUNT function do in SQL?
Returns the total sum of a numeric column
Returns the average value of a numeric column
Returns the number of rows that matches a specified criterion
Joins two tables
Correct!
Wrong!
3. What does the AVG function do in SQL?
Returns the average value of a numeric column
Joins two tables
Returns the total sum of a numeric column
Returns the number of rows that matches a specified criterion
Correct!
Wrong!
4. What does the SUM function do in SQL?
Returns the number of rows that matches a specified criterion
Returns the average value of a numeric column
Joins two tables
Returns the total sum of a numeric column
Correct!
Wrong!
5. What does the LIKE operator do in SQL?
Returns the average value of a numeric column
Searches for a specified pattern in a column
Joins two tables
Returns the total sum of a numeric column
Correct!
Wrong!
6. What does the BETWEEN operator do in SQL?
Joins two tables
Returns the total sum of a numeric column
Selects values within a range
Returns the average value of a numeric column
Correct!
Wrong!
7. What is the function of the INNER JOIN in SQL?
Returns rows where there is a match in both tables
Returns all rows from the left table, and the matched rows from the right table
Returns all rows from the right table, and the matched rows from the left table
Returns all rows when there is a match in either left or right table
Correct!
Wrong!
8. What is the function of the LEFT JOIN in SQL?
Returns rows where there is a match in both tables
Returns all rows from the left table, and the matched rows from the right table
Returns all rows from the right table, and the matched rows from the left table
Returns all rows when there is a match in either left or right table
Correct!
Wrong!
9. What is the function of the RIGHT JOIN in SQL?
Returns rows where there is a match in both tables
Returns all rows from the left table, and the matched rows from the right table
Returns all rows from the right table, and the matched rows from the left table
Returns all rows when there is a match in either left or right table
Correct!
Wrong!
10. What is the function of the FULL JOIN in SQL?
Returns rows where there is a match in both tables
Returns all rows from the left table, and the matched rows from the right table
Returns all rows from the right table, and the matched rows from the left table
Returns all rows when there is a match in either left or right table
Correct!
Wrong!
11. What does the UNION operator do in SQL?
Joins two tables
Returns the total sum of a numeric column
Returns the average value of a numeric column
Combines the result of two or more SELECT statements
Correct!
Wrong!
12. What does the GROUP BY statement do in SQL?
Joins two tables
Groups rows that have the same values in specified columns into aggregated data
Returns the total sum of a numeric column
Searches for a specified pattern in a column
Correct!
Wrong!
13. What is the HAVING clause used for in SQL?
To filter records that have certain match in another table
To filter the results of a GROUP BY operation
To join two tables
To return the total sum of a numeric column
Correct!
Wrong!
14. What is the difference between the WHERE and the HAVING clause?
WHERE filters before data is grouped, HAVING filters after data is grouped
WHERE filters after data is grouped, HAVING filters before data is grouped
WHERE and HAVING can be used interchangeably
There is no difference between WHERE and HAVING
Correct!
Wrong!
15. Can the AVG function be used with non-numeric data types?
Yes
No
Correct!
Wrong!
16. Which of the following operators would you use to select all people with names starting with 'A'?
BETWEEN
LIKE
DISTINCT
UNION
Correct!
Wrong!
17. Which SQL statement is used to extract data from a database?
GET
PULL
SELECT
EXTRACT
Correct!
Wrong!
18. Which operator is used to combine the results of two select statements removing duplicates?
JOIN
UNION
MERGE
COMBINE
Correct!
Wrong!
19. Can UNION operator be used on tables with different number of columns?
Yes
No
Correct!
Wrong!
20. What does SQL stand for?
Structured Query Language
Simple Query Language
System Query Language
Sequential Query Language
Correct!
Wrong!
21. Is SQL case sensitive?
Yes
No
Correct!
Wrong!
22. Which SQL statement is used to update data in a database?
MODIFY
SAVE
UPDATE
REPLACE
Correct!
Wrong!
23. What operator tests whether a value falls within a range of values?
IN
LIKE
BETWEEN
AND
Correct!
Wrong!
24. In a LIKE clause, what is the use of underscore (_) character?
Matches any single character
Matches any sequence of characters
Doesn't have any special meaning
It's not used in a LIKE clause
Correct!
Wrong!
25. Which JOIN returns all the rows from the left table and the matched rows from the right table, and NULL if there is no match?
INNER JOIN
RIGHT JOIN
LEFT JOIN
FULL JOIN
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
MYSQL Advanced Queries – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...