Lesson 3 (MIDTERM)

Question 1

Creating a basic table involves naming the table and defining its columns and each column’s data type.
The SQL _______ ______ statement is used to create a new table

Answer 1

CREATE TABLE

Question 2

The SQL _________ command is used to add, delete or modify columns in an existing table.

Answer 2

ALTER TABLE

Question 3

You would also use ________ command to add and drop various constraints on an existing table.

Answer 3

ALTER TABLE

Question 4

To change the name of an existing table

Answer 4

ALTER TABLE - ALTER/RENAME TABLE

Question 5

To change the data type of a column in a table

Answer 5

ALTER TABLE - ALTER/MODIFY COLUMN

Question 6

is used to remove database objects, such as tables, indexes, or views, from a database.

Answer 6

The DROP command

Question 7

in SQL is used to retrieve data from one or more tables. It is one of the fundamental and most commonly used statements in SQL

Answer 7

SELECT Statement

Question 8

Optional. Filter the rows based on a specified condition. It restricts the result set to only include rows that satisfy the condition

Answer 8

Where Clause

Question 9

Optional. Sorts the result set based on one or more columns. Default is ascending (ASC), but you can specify descending (DESC)

Answer 9

ORDER BY Clause

Question 10

Used with aggregate functions to group and filter data.

Answer 10

GROUP BY and HAVING CLAUSES

Question 11

SELECT AVG(salary) FROM employees;

Answer 11

Aggregate Functions (SUM, AVG, MIN, MAX, COUNT): Perform calculations on data