D426 Data Management Foundations - Set 4 - Part 1

Correct Answer: CREATE INDEX

The CREATE INDEX statement is used to create an index on one or more columns of a table to improve query performance.

Correct Answer: To modify an existing table's structure

The ALTER TABLE statement is used to change the structure of an existing table, such as adding or dropping columns.

Correct Answer: COUNT()

The COUNT() function counts the number of rows that satisfy a given condition in a SQL query.

Correct Answer: ORDER BY DESC

The ORDER BY clause with DESC sorts the result set in descending order based on the specified column(s).

Correct Answer: Structured Query Language

SQL stands for Structured Query Language, which is used for managing and manipulating relational databases.

Correct Answer: TRUNCATE

The TRUNCATE command deletes all rows from a table while keeping the table structure intact for future use.

Correct Answer: WHERE

The WHERE clause is used to specify conditions that filter which rows are returned by a query.

Correct Answer: MAX()

The MAX() function returns the maximum value from a specified column in a table.

Correct Answer: Removes duplicates from the result set

The DISTINCT keyword is used to ensure that the result set contains only unique records, eliminating duplicates.

Correct Answer: DROP DATABASE

The DROP DATABASE command is used to permanently remove a database and all its tables from the database management system.

Correct Answer: A reference to a primary key in another table

A foreign key is a column or group of columns that establishes a link between two tables, referencing the primary key of another table.

Correct Answer: CONCAT()

The CONCAT() function is used to join two or more strings together in SQL.

Correct Answer: FROM

The FROM clause indicates the table(s) from which data will be retrieved in a SQL query.

Correct Answer: CURDATE()

The CURDATE() function returns the current date, excluding the time portion.

Correct Answer: ALTER COLUMN

The ALTER TABLE command is used with the ALTER COLUMN clause to change the data type of an existing column.

Correct Answer: SELECT DISTINCT

The SELECT DISTINCT statement retrieves unique values from a specified column, removing duplicates.

Correct Answer: GRANT

The GRANT command is used to assign specific privileges to a user or role in the database.

Correct Answer: Removes specific rows from a table

The DELETE command is used to remove specific rows from a table based on specified conditions.

Correct Answer: AVG()

The AVG() function computes the average value of a specified numeric column in SQL.

Correct Answer: GROUP BY

The GROUP BY clause groups rows that share the same values in specified columns, allowing for aggregate functions to be applied.