DML and DDL (Module 4)

These are statements are used to define the database structure or schema.

These are statements are used for managing data within schema objects.

Every time you create table, views, and other database objects, a DDL statement is being executed on the background.

Select All the DDL Statements

Select All DML Statements

The AND operator requires both conditions to be true while the OR operator only needs one of the conditions to be true.

[blank_start]WHERE[blank_end] Specifies the conditions that must be met for a row to be included in the result set. This clause is optional and is used to filter the information returned.

When updating/deleting records in a table, it is recommended to include a where statement.

To eliminate the duplicates you can include the ________ keyword within your SELECT clause.

Aside from its arithmetic operation, you can also use the plus (+) symbol to concatenate string values

I want to retrieve ALL records from the table named "Presidents" where the last name is "Adams". The last name column is labeled as "lname". What is the correct query that I should use?

To check for a null value in a column, the WHERE clause should be : "...WHERE <Column name> IS NOT NULL"

The WHERE clause can be used after the ORDER BY clause

I want to order the results from the "Presidents" in descending order by the column, start_date. Complete the following query: SELECT * FROM Presidents [blank_start]ORDER BY start_date desc[blank_end]