D426 Data Management Foundations - Set 2 - Part 2

Correct Answer: COUNT

The COUNT function returns the number of non-NULL values in a specified column.

Correct Answer: WHERE

The WHERE clause is used to specify the conditions that must be met for a row to be updated in a table.

Correct Answer: To retrieve data from a table

The SELECT statement is used to retrieve data from one or more tables in a database.

Correct Answer: FROM

The FROM clause specifies the table(s) from which the data is being retrieved in a SQL query.

Correct Answer: AND

The AND operator is used to combine two or more conditions in a SQL query, where all conditions must be true for the result to be returned.

Correct Answer: AS

The AS keyword is used to assign an alias to a column or table, allowing for more readable result sets.

Correct Answer: TRIM

The TRIM function removes leading and trailing spaces from a string in SQL.

Correct Answer: Composite Key

A Composite Key consists of two or more columns that together uniquely identify each row in a table.

Correct Answer: WHERE

The WHERE clause filters rows before they are grouped in a GROUP BY query, applying conditions to individual rows.

Correct Answer: DROP TABLE

The DROP TABLE command is used to delete a table and all its data and structure permanently from the database.

Correct Answer: INSERT

The INSERT command adds a new row to a table, specifying the values to be added for each column.

Correct Answer: FULL JOIN

A FULL JOIN returns all rows from both the left and right tables, filling in NULL values where there is no match.

Correct Answer: ABS

The ABS function returns the absolute (positive) value of a given number in SQL.

Correct Answer: To speed up query performance

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

Correct Answer: NOW

The NOW function returns the current date and time based on the system's clock in SQL.

Correct Answer: ALTER TABLE

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

Correct Answer: LIKE

The LIKE operator is used to match patterns in strings using wildcard characters, such as % and.

Correct Answer: UNIQUE

The UNIQUE constraint ensures that values in a column or set of columns are unique across all rows in a table.

Correct Answer: SELECT

The SELECT keyword is used to retrieve data from one or more tables in a database.

Correct Answer: ORDER BY

The ORDER BY clause sorts rows in ascending order by default, unless the DESC keyword is used to specify descending order.