Author Question: Sorting on multiple columns in Oracle SQL script involves which of the following? A) Placing the ... (Read 66 times)

tth

  • Hero Member
  • *****
  • Posts: 579
Sorting on multiple columns in Oracle SQL script involves which of the following?
 
  A) Placing the fields in order in which they should be sorted in Order by command
  B) Listing all the fields that need to be shown in Select command
  C) Placing keyword desc at the end of Order by command for Z->A sort or leaving it blank
  for ascending sort
  D) All of the above

Question 2

In Microsoft Access, which of the following would be used to sort the client list consisting of
  contacts and emails, alphabetically from Z to A, by contact?
 
  A) Select  From client Order by contact
  B) Select contact, email Order by contact desc
  C) Select contact, email From client Order by contact
  D) Select contact, email From client Order by contact desc



Mochi

  • Sr. Member
  • ****
  • Posts: 300
Answer to Question 1

D

Answer to Question 2

D



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

For a complete list of videos, visit our video library