To retrieve data from a table
To describe the structure of a database
To create a new table
To show the structure of a table
To filter rows based on a condition
To perform conditional logic within a query
To join tables based on a condition
LIKE
MATCH
CONTAINS
COMPARE
Commits the changes made in the transaction
Undoes the changes made in the transaction and restores the data to its original state
Saves the changes temporarily
Clears the transaction log
AND
OR
NOT
XOR
To display the structure of a table
To display a list of all tables in the current database
To show the relationships between tables
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 and matching rows from the second table
To retrieve rows from the second table and matching rows from the first table
NOW()
CURRENT_DATE()
GETDATE()
SYSDATE()
To automatically execute a set of SQL statements when a specific event occurs
To create a temporary table
To delete records from a table
To modify the structure of a table
Reducing the redundancy and dependency of data in a database
Adding redundancy to improve data integrity
Increasing the dependency of data between tables
Modifying the structure of a table
GRANT ALL PRIVILEGES
GRANT SELECT
GRANT PERMISSION
GRANT ROLE
To concatenate two or more strings
To count the number of characters in a string
To find the position of a substring in a string
To convert a string to uppercase
DROP PRIMARY KEY
REMOVE PRIMARY KEY
ALTER TABLE
DELETE PRIMARY KEY
Atomicity, Consistency, Isolation, Durability
Aggregate, Consistency, Isolation, Durability
Atomic, Consistent, Isolated, Durable
Association, Consistency, Isolation, Durability
DROP FOREIGN KEY
REMOVE FOREIGN KEY
DELETE FOREIGN KEY
To round a numeric value to the nearest integer
To generate a random number
To retrieve a random record from a table
To rank rows based on a specified column
To sort the result set in ascending order
To provide subtotals and grand totals in the result set
To limit the number of rows in the result set
To lock a table for read access only
To lock a table for write access only
To lock one or more tables for specific operations
To unlock all tables in the database
TOUPPER()
LOWER()
LCASE()
CONVERT()
To find the maximum value among a set of values
To find the minimum value among a set of values
To concatenate strings
To calculate the average value of a set of values