question What does SQL stand for

Database

What does SQL stand for?

A. Structured Language
B. Standard Query Language
C. Sequential Query Language
D. Simple Question Language

SQL stands for Standard Query Language.

What does SQL stand for in the context of Oracle Database?

A. Structured Question Language
B. Standard Query Language
C. Sequential Query Language
D. Structured Query Language

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

In Oracle, which data type is used to store fixed-length character strings?

A. VARCHAR2
B. CHAR
C. CLOB
D. VARCHAR

Which Oracle clause is used to add an index to an existing table?

A. ADD INDEX
B. CREATE INDEX
C. INDEX TABLE
D. ALTER INDEX

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

Which MySQL command is used to retrieve the definition of a table?

A. DESCRIBE
B. SHOW TABLE
C. DISPLAY TABLE
D. INFO TABLE

Which MySQL statement is used to delete a database?

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

Which SQL statement is used to change the value of an existing record in a table?

A. MODIFY
B. CHANGE
C. UPDATE
D. SET

In SQL Server, what is the purpose of the SQL Server XML data type method value()?

A. Extract a single value from an XML string
B. Combine multiple XML values
C. Concatenate XML strings
D. Validate XML structure

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