Introduction to SQL Quiz

What command is used to add new rows to a table?

• INSERT

• SELECT

• UPDATE

• DELETE

What is the syntax for inserting values into a table?

• INSERT INTO table_name (columns) VALUES (values);

• INSERT INTO table_name VALUES (values);

• INSERT table_name (columns) VALUES (values);

• INSERT table_name VALUES (values);

How do you retrieve all columns from a table?

• SELECT * FROM table_name;

• SELECT columns FROM table_name;

• SELECT ALL FROM table_name;

• SELECT table_name;

What operator is used with SELECT to retrieve unique values?

• DISTINCT

• UNIQUE

• FILTER

• WHERE

What is the purpose of the WHERE clause in SQL?

• To filter rows based on criteria

• To sort the results

• To group rows

• To join tables

What does the LIKE operator do in SQL?

• Matches a string pattern

• Filters numeric values

• Retrieves unique values

• Sorts results

What is the syntax for checking if a column is NULL?

• SELECT columns FROM table_name WHERE column IS NULL;

• SELECT columns FROM table_name WHERE column = NULL;

• SELECT columns FROM table_name WHERE column IS EMPTY;

• SELECT columns FROM table_name WHERE column NOT NULL;

What does the IN operator do in SQL?

• Checks if a value matches any value in a list

• Filters results based on a condition

• Retrieves unique values

• Sorts results

What is the syntax for using BETWEEN in SQL?

• SELECT columns FROM table_name WHERE column BETWEEN value1 AND value2;

• SELECT columns FROM table_name WHERE column IN (value1, value2);

• SELECT columns FROM table_name WHERE column > value1 AND column < value2;

• SELECT columns FROM table_name WHERE column BETWEEN value1 OR value2;

What command is used to modify existing records in a table?

• UPDATE

• INSERT

• DELETE

• SELECT