D075 Information Technology Management Essentials - Set 5 - Part 2

Correct Answer: CREATE TABLE

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

Correct Answer: Removes duplicate records

The DISTINCT keyword ensures that the result set contains only unique records, eliminating any duplicates.

Correct Answer: A column that uniquely identifies each row in a table

A primary key is a unique identifier for each row in a table, ensuring that no two rows have the same value in the primary key column(s).

Correct Answer: CONCAT()

The CONCAT() function combines two or more strings into one single string in SQL.

Correct Answer: WHERE

The WHERE clause specifies the criteria that must be met for records to be included in the result set of a query.

Correct Answer: To add new rows to a table

The INSERT INTO statement is used to add new records to a specified table in the database.

Correct Answer: COMMIT

The COMMIT command is used to save all changes made during the current transaction to the database permanently.

Correct Answer: Checks if a value is missing or undefined

The IS NULL condition checks whether a value in a column is NULL, indicating the absence of data.

Correct Answer: SELECT

The SELECT statement retrieves data from one or more tables, and can be combined with JOIN clauses to access multiple tables.

Correct Answer: To combine the results of two SELECT queries into one

The UNION operator is used to combine the result sets of two or more SELECT queries into a single result set, eliminating duplicates.

Correct Answer: ALTER COLUMN

The ALTER TABLE command with ALTER COLUMN is used to change the name of an existing column in a table.

Correct Answer: MIN()

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

Correct Answer: HAVING

The HAVING clause is used to filter groups of records based on conditions applied to aggregated values.

Correct Answer: To delete an entire table or database

The DROP command is used to permanently remove a table or database from the database management system.

Correct Answer: CREATE TABLE

The CREATE TABLE command is used to define a new table along with its columns and data types.

Correct Answer: COUNT()

The COUNT() function counts the number of rows that meet specified conditions in a SQL query.

Correct Answer: Deletes all rows from a table without logging individual row deletions

The TRUNCATE command removes all rows from a table while preserving its structure, and it does not log individual row deletions.

Correct Answer: SUM()

The SUM() function calculates the total of all values in a specified numeric column in SQL.

Correct Answer: UPDATE

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

Correct Answer: Filters records based on multiple values

The IN operator is used to specify multiple values in a WHERE clause, allowing records to be filtered based on whether a column's value matches any value in the specified list.