Mastering SQL Concepts

What does DML stand for in SQL?

• Data Model Language

• Data Management Language

• Data Manipulation Language

• Database Manipulation Language

Which SQL command is used to insert data into a table?

• SELECT * FROM

• DELETE FROM

• INSERT INTO

• UPDATE

What is the purpose of the SELECT statement in SQL?

• To retrieve data from a database.

• To delete data from a database.

• To update existing records in a database.

• To create new tables in a database.

Which clause is used to filter records in a SQL query?

• HAVING

• WHERE

• JOIN

• SELECT

What does DDL stand for in SQL?

• Data Design Language

• Data Distribution Language

• Data Definition Language

• Data Description Language

Which SQL command is used to create a new table?

• INSERT TABLE

• CREATE TABLE

• ADD TABLE

• MODIFY TABLE

What is the function of the WHERE clause in a SQL query?

• The WHERE clause sorts the results of a query.

• The WHERE clause defines the database connection parameters.

• The WHERE clause groups records by specified fields.

• The WHERE clause filters records based on specified conditions.

What is an aggregate function in SQL?

• An aggregate function in SQL is used to modify data in a table.

• An aggregate function in SQL is a function that computes a single result from a set of values.

• An aggregate function in SQL retrieves individual records from a database.

• An aggregate function in SQL is a command to delete records from a table.

Which SQL function counts the number of rows in a result set?

• AVG()

• COUNT()

• MAX()

• SUM()

What is the purpose of the GROUP BY clause in SQL?

• To group rows that have the same values in specified columns and perform aggregate calculations on them.

• To sort the results of a query in ascending or descending order.

• To create new tables in the database.

• To filter rows based on a specified condition.