The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Select an option to see the answer and solution.
Database · all questionsIntroduction to SQL
Introduction to SQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
69
Questions
4/4
Page
Pick an option on a question to see the right answer and solution.
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Select an option to see the answer and solution.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Select an option to see the answer and solution.
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Select an option to see the answer and solution.
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Select an option to see the answer and solution.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Select an option to see the answer and solution.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Select an option to see the answer and solution.
To establish a range of values, < and > can be used.
Select an option to see the answer and solution.
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
Select an option to see the answer and solution.