« previous next »

Author Question: Which type of index is commonly used in data warehousing environments? A) Joint index B) ... (Read 120 times)

tfester

  • Hero Member
  • *****
  • Posts: 534
on: Jul 7, 2018
Which type of index is commonly used in data warehousing environments?
 
  A) Joint index
  B) Bit-mapped index
  C) Secondary index
  D) Tri-dex

Question 2

Discuss when to use the GROUP BY clause.
 
  What will be an ideal response?
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


cloud

  • Sr. Member
  • ****
  • Posts: 343
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

The GROUP BY clause is useful when you have a set of values for one column (such as a salesperson ID) and you would like to then calculate something like total sales for each salesperson. Rather than having to use the sum function with one salesperson's ID in the WHERE clause (and run multiple queries) you can use the GROUP BY to get the same results in one query.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

tfester

  • Hero Member
  • *****
  • Posts: 534
Reply #2 on: Jul 7, 2018
Thank you :)


cloud

  • Sr. Member
  • ****
  • Posts: 343
Reply #3 on: Jul 7, 2018
Happy to help you


« previous next »
 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Jaguar F-type back Jaguar F-type back
The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust
A beam-type torque wrench that displays the torque reading on the face of the dial. The beam display ... A beam-type torque wrench that displays the torque reading on the face of the dial. The beam display ...
A typical fuel pulsator used mostly with roller vane-type pumps to help even out the pulsation in ... A typical fuel pulsator used mostly with roller vane-type pumps to help even out the pulsation in ...
Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila Sturtevant’s Recombination Data for Five X-Linked Genes in Drosophila
For each chromosome type in the body, there are two copies. One is from the mother, and one is from For each chromosome type in the body, there are two copies. One is from the mother, and one is from
Video: Condensation and Hydrolysis Animation

For a complete list of videos, visit our video library