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

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

For a complete list of videos, visit our video library