question What is the purpose of the SQL GROUP BY clause

Database

What is the purpose of the SQL GROUP BY clause?

A. Filter rows
B. Sort the result set
C. Combine rows into groups
D. Join multiple tables

The GROUP BY clause is used to combine rows into groups based on a column.

Which SQL statement is used to create a new table in a database?

A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE

What is the purpose of the SQL DISTINCT keyword?

A. Sort the result set
B. Filter rows
C. Eliminate duplicate values
D. Combine rows into groups

What is the purpose of the SQL ORDER BY clause?

A. Filter rows
B. Group rows
C. Sort the result set
D. Combine tables

Which MySQL data type is used to store large text values?

A. VARCHAR
B. TEXT
C. BLOB
D. CHAR

Which MySQL statement is used to delete a database?

A. DELETE DATABASE
B. DROP DATABASE
C. REMOVE DATABASE
D. DESTROY DATABASE

Which MySQL data type is used to store a fixed-length string?

A. VARCHAR
B. CHAR
C. TEXT
D. BLOB

Which statement is used to remove all records from a table in MySQL?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

What does the SQL NOT NULL constraint do?

A. Allows NULL values
B. Prevents NULL values
C. Sorts values in descending order
D. Groups values

What is the purpose of the SQL LIMIT clause?

A. Filter rows
B. Sort the result set
C. Limit the number of rows returned
D. Join multiple tables

What is the purpose of the SQL WHERE clause?

A. Specify the columns to be selected
B. Filter rows based on a condition
C. Sort the result set
D. Join multiple tables