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

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

For a complete list of videos, visit our video library