Below Are Four Situations in Which the DML Component of SQL

question 119

Short Answer

Below are four situations in which the DML component of SQL can be used to manipulate and/or extract data.Indicate on the line beside each situation the letter(s)of the SQL statement,command,or condition which will allow a user to manipulate and/or extract the requested data and information.An answer may be used more than once,but not all answers will be used.
A.SELECT
B.WHERE
C.ON
D.OR
E.COUNT AS
F.GROUP BY
G.ORDER BY
H.FROM
I.INNER JOIN
J.IN
________ 1.The query calls for selecting certain names and zip codes,sorted by zip code.
________ 2.The query calls for selecting certain companies found in the USA and Canada tables and grouping them by country
________ 3.The query calls for appending the company name for company 12 to the topics located in the notes table.
________ 4.The query calls for summarizing the count of companies by country.

---

Definitions:

Reasonable Identification

The process of sufficiently identifying an individual through the use of valid and reliable means or documents.

Fraud In The Factum

A liability defense available to a party who signs a negotiable instrument without knowing that it is a negotiable instrument.

Negotiable Instrument

A written assurance for the remittance of a fixed sum of money, payable either on demand or at a future date, with the document clearly stating the name of the individual making the payment.

Liability

A legal responsibility or obligation.