D426 Data Management Foundations - Set 3 - Part 1

Correct Answer: DROP DATABASE

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

Correct Answer: ALTER TABLE

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

Correct Answer: CREATE TABLE

The CREATE TABLE command is used to define a new table and its columns within the database.

Correct Answer: HAVING

The HAVING clause is used to filter groups of records after the aggregation has been performed with the GROUP BY clause.

Correct Answer: UPDATE

The UPDATE command is used to modify existing records in a table based on specified conditions.

Correct Answer: To uniquely identify each row in a table

A primary key uniquely identifies each row in a table, ensuring that no two rows have the same value in the primary key column(s).

Correct Answer: MIN()

The MIN() function returns the smallest value from a specified column in SQL.

Correct Answer: INNER JOIN

An INNER JOIN returns only the rows that have matching values in both tables involved in the join.

Correct Answer: TRUNCATE

The TRUNCATE command removes all rows from a table without affecting the table's structure.

Correct Answer: Values must be unique across the column

The UNIQUE constraint ensures that all values in a specified column are distinct from each other.

Correct Answer: IN

The IN operator is used to determine if a value matches any value in a specified list.

Correct Answer: CREATE

The CREATE command is followed by the specification of column names and their data types when creating a new table.

Correct Answer: NOW()

The NOW() function retrieves the current date and time from the system clock.

Correct Answer: CREATE VIEW

The CREATE VIEW statement is used to define a new view based on a SELECT query, allowing for simplified data retrieval.

Correct Answer: ORDER BY

The ORDER BY clause sorts the result set based on one or more columns in ascending order by default.

Correct Answer: To enforce data integrity

A foreign key establishes a link between two tables, ensuring that the data remains consistent and valid.

Correct Answer: AVG()

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

Correct Answer: WHERE

The WHERE clause is applied to filter rows before they are grouped in a GROUP BY operation.

Correct Answer: CREATE USER

The CREATE USER command is used to establish a new user account in the database management system.

Correct Answer: UPDATE

The UPDATE statement is used to modify existing records in a table.