DML and DDL (Module 4)

Question 1

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

Accepted Answer

Data Definition Language (DDL)

Answer

Data Manipulation Language (DML)

Answer

Data Control Language (DCL)

Question 2

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

Accepted Answer

Data Manipulation Language (DML)

Answer

Data Definition Language (DDL)

Answer

Data Control Language (DCL)

Question 3

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

Answer

true

Question 4

Select All the DDL Statements

Accepted Answer

CREATE

Accepted Answer

ALTER

Accepted Answer

DROP

Accepted Answer

TRUNCATE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 5

Select All DML Statements

Accepted Answer

SELECT

Accepted Answer

INSERT

Accepted Answer

DELETE

Answer

CREATE

Answer

ALTER

Answer

DROP

Question 6

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

Answer

true

Question 7

[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.

Accepted Answer

WHERE

Question 8

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

Answer

true

Question 9

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

Accepted Answer

DISTINCT

Answer

WHERE

Answer

UNIQUE

Answer

ONLY

Question 10

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

Answer

true

Question 11

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?

Accepted Answer

SELECT * FROM Presidents WHERE lname = 'Adams'

Answer

SELECT lname FROM Presidents WHERE lname = 'Adams'

Answer

SELECT ALL FROM Presidents where lname = 'Adams'

Answer

SELECT * FROM Presidents where lname = Adams

Answer

SELECT * FROM Presidents where lastname = 'Adams'

Question 12

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

Answer

true

Question 13

The WHERE clause can be used after the ORDER BY clause

Answer

true

Question 14

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]

Accepted Answer

ORDER BY start_date desc

DML and DDL (Module 4)

Questions in this quiz (14)

Information

Feedback

What do you think of the new look?