question In MySQL what is the purpose of the BLOB data type

Database

In MySQL, what is the purpose of the BLOB data type?

A. Binary Large Object
B. Basic Long Object
C. Binary Linked Object
D. Basic Linked Object

BLOB stands for Binary Large Object and is used to store binary data.

Which SQL function is used to find the total number of rows in a table?

A. COUNT()
B. TOTAL()
C. SUM()
D. ROWCOUNT()

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

Which SQL Server statement is used to add a new row to a table?

A. INSERT INTO
B. ADD ROW
C. NEW ROW
D. CREATE ROW

What is the purpose of the SQL HAVING clause?

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

Which command is used to select all columns from a table named "employees"?

A. SELECT * FROM employees;
B. SELECT ALL FROM employees;
C. SHOW COLUMNS FROM employees;
D. DISPLAY employees;

In Oracle, what is the purpose of the HAVING clause?

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

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

In MySQL, which storage engine supports transactions and ACID properties?

A. MyISAM
B. InnoDB
C. MEMORY
D. ARCHIVE

What is the purpose of the SQL Server ISNULL() function?

A. Combine multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows

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