Author Question: Sorting on multiple columns in Oracle SQL script involves which of the following? A) Placing the ... (Read 51 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?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

For a complete list of videos, visit our video library