Most DBMS packages contain data definition, data manipulation, and data query languages. For each of the following situations, match to which language would be used and why.

Question $1$ options:

The DQL $-$ another example of a task that involves querying the database.

The DQL $-$ this is an example of a query.

The DDL and the DML $-$ the former to alter the structure, the latter to make the change.

The DDL and the DML $-$ the former to add the field, the latter to enter data in it$.$

The DQL $$ this listing can be produced by a query.

The DDL $-$ this is the language used to define the database

The DML $-$ this is the language used to actually process transaction data and update the database.

$1.$

A database administrator defines the logical structure of the database

$2.$

The controller requests a cost accounting report containing a list of all employees being paid for more than $10$ hours overtime in a given week.

$3.$

A programmer develops a program to update the fixed$-$assets records stored in the database.

$4.$

The human resources manager requests a report noting all employees who are retiring within five years.

$5.$

The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than $10$ digits.

$6.$

A user develops a program to print out all purchases made during the past two weeks.

$7.$

An additional field is added to the fixed$-$asset records to record the estimated salvage value of each asset.