SQL Fundamentals for Beginners

What does SQL stand for?

• Structured Query List

• Structured Query Language

• Simple Query Language

• Structured Query Logic

Which SQL statement is used to retrieve data?

• DELETE

• UPDATE

• SELECT

• INSERT

How do you insert a new record in a table?

• Use the SQL UPDATE statement.

• Use the SQL SELECT statement.

• Use the SQL DELETE statement.

• Use the SQL INSERT statement.

What is the purpose of the WHERE clause?

• To join multiple tables together.

• To filter records based on specified conditions.

• To sort records in ascending order.

• To group records by a specific field.

Which SQL command is used to update existing data?

• INSERT

• DELETE

• SELECT

• UPDATE

What is a primary key?

• A primary key is a type of foreign key.

• A primary key is a unique identifier for a record in a database table.

• A primary key can have duplicate values.

• A primary key is used to store images in a database.

How do you delete a record from a table?

• Use the SELECT statement in SQL.

• Use the UPDATE statement in SQL.

• Use the INSERT statement in SQL.

• Use the DELETE statement in SQL.

What is the difference between INNER JOIN and LEFT JOIN?

• INNER JOIN returns all rows regardless of matches; LEFT JOIN returns only matched rows from the left table.

• INNER JOIN returns matched rows only; LEFT JOIN returns all left rows with matched right rows.

• INNER JOIN includes all rows from the left table; LEFT JOIN excludes unmatched rows from the right table.

• INNER JOIN returns all rows from both tables; LEFT JOIN returns only unmatched rows.

What does the COUNT() function do?

• Calculates the average of a dataset.

• Counts the number of rows in a dataset.

• Retrieves unique values from a dataset.

• Finds the maximum value in a dataset.

How can you sort the results of a query?

• Use the ORDER BY clause in your query.

• Sort results by using the SELECT statement.

• Use the GROUP BY clause in your query.

• Filter results with the WHERE clause.