B. To group rows based on a column's values
C. To sort the result set in ascending or descending order
D. To perform arithmetic operations
Answer: C. To sort the result set in ascending or descending order
B. MIN()
C. AVG()
D. SUM()
Answer: A. MAX()
B. A unique identifier for a record in a table
C. A key used for encryption
D. A key used for joining tables
Answer: B. A unique identifier for a record in a table
C. To filter groups based on a condition
D. To sort the result set
Answer: C. To filter groups based on a condition
B. DELETE TABLE
C. REMOVE TABLE
D. ERASE TABLE
Answer: A. DROP TABLE
B. To limit the number of columns in the result set
C. To limit the types of data in the result set
D. To limit the number of records in a table
Answer: A. To limit the number of rows in the result set
To concatenate two or more strings
To combine the results of two or more SELECT statements
To join tables based on a condition
To filter out NULL values from the result set
AVG()
MEDIAN()
AVERAGE()
SUM()
To enforce unique constraints on a column
To define a primary key for a table
To speed up the retrieval of rows by creating a data structure
To create a virtual table
To automatically sort rows in ascending order
To automatically insert values into a column based on a specified pattern
To automatically generate unique values for a column as records are inserted
To automatically update records in a table
MODIFY TABLE
RENAME TABLE
CHANGE TABLE
ALTER TABLE
To remove all records from a table without deleting the table structure
To delete a specific record from a table
To remove a specific column from a table
To delete the table structure
VARCHAR
TEXT
CHAR
LONGTEXT
Grants the user permission to select data from the specified table in the specified database
Grants the user permission to create a new table
Grants the user permission to delete records from the specified table
Grants the user permission to modify the structure of the specified table
Automatically updates the foreign key value in the child table if the referenced key is updated
Automatically deletes the foreign key value in the child table if the referenced key is deleted
Automatically inserts a new foreign key value in the child table if the referenced key is inserted
Automatically modifies the foreign key value in the child table if the referenced key is modified
CREATE VIEW
MAKE VIEW
VIEW TABLE
DEFINE VIEW
To retrieve all rows from both tables, even if there is no match
To retrieve only the common rows between two tables based on a related column
To retrieve rows from the first table only
To retrieve rows from the second table only
DROP CONSTRAINT
REMOVE CONSTRAINT
DELETE CONSTRAINT
To calculate the sum of values in a column
To calculate the average value of numeric column values
To count the number of records in a table
To find the maximum value in a column
CREATE INDEX
MAKE INDEX
INDEX TABLE
DEFINE INDEX