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

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

For a complete list of videos, visit our video library