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.
What will be an ideal response?
Answer:
1. A, H, G
2. A, H, B, D, G
3. A, H, I, C, B
4. A, E, H, F
You might also like to view...
What are some of the entities that an exporter should be familiar with?
Describe and explain the role played by each of these entities, separating those that have responsibilities from exporters from those that have no responsibilities from the exporters.
Which of the following is true regarding television advertising?
A) It is good for factual (informational) copy. B) It is the best medium for action and image advertising. C) It is easy to narrowly target an audience with the help of television advertising. D) TV advertising is time consuming and reaches limited number of people.