What are the 4 DDL command statements most commonly used? Describe each briefly.

SELECT – to query data in the database.
INSERT – to insert data into a table.
UPDATE – to update data in a table.
DELETE – to delete data from a table.

When and why would you use a “LIKE” clause?

The “LIKE” clause would be used when specified portions of character strings is needing to be selected.

Because it needs specific information is needing to be selected.

Describe a scenario of when an INSERT and DELETE commands are used.

A scenario for “INSERT” would be to add a book record to a publisher’s Authors table

A scenario for “DELETE” would be if an employee was fired from their job and the company needed to delete their information.

Create an Employee table in a new database Company.