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

Database

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

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

'TEXT' is used to store large text values in MySQL.

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

Which MySQL statement is used to grant all privileges to a user?

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

In Oracle, what is the purpose of the GROUP BY clause?

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

Which SQL statement is used to remove a table from a database?

A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. DELETE FROM TABLE

In SQL Server, what is the purpose of the PARSE() function?

A. Concatenate multiple columns
B. Parse a string into a specified data type
C. Calculate the average value
D. Generate a sequence of numbers

Which Oracle statement is used to grant all privileges to a user?

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

Which SQL Server statement is used to remove an index from a table?

A. DELETE INDEX
B. REMOVE INDEX
C. DROP INDEX
D. ERASE INDEX

What is the purpose of the SQL COALESCE() function?

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

Which SQL Server function is used to find the difference between two dates?

A. DIFFDATEDAYS()
B. DATEDIFF()
C. DIFFDATE()
D. DATE_DIFF()

In MySQL, what is the purpose of the DESC keyword in an ORDER BY clause?

A. Sort in descending order
B. Specify a description
C. Sort in ascending order
D. Display columns