Skill Checkpoint: See Where You Stand

Category: MySQL

MySQL

MySQL

1 / 19

What does SQL stand for?

2 / 19

Which keyword is used to retrieve unique values from a column?

3 / 19

Which command is used to remove all records from a table in SQL?

4 / 19

Which of these is used to combine the results of two SELECT statements?

5 / 19

What type of JOIN returns all rows when there is a match in either table?

6 / 19

Which of the following is NOT a valid SQL data type?

7 / 19

Which wildcard is used for multiple characters in a LIKE clause?

8 / 19

What is the output of SELECT LENGTH(SQL?)?

9 / 19

Which SQL function gives the current date?

10 / 19

What is a foreign key?

11 / 19

Which SQL clause is used to rename a column in output?

12 / 19

Which data type stores variable-length character data?

13 / 19

What does a PRIMARY KEY do?

14 / 19

Which SQL clause is used to rename a column in a result set?

15 / 19

Which of these statements is used to create an index?

16 / 19

Which keyword is used to remove duplicates in a SELECT statement?

17 / 19

Which type of join returns the Cartesian product of two tables?

18 / 19

Which keyword is used for a comment in SQL?

19 / 19

Which type of join will include unmatched rows with NULLS from the left table?

Your score is

The average score is 52%

0%