« previous next »

Author Question: Which type of index is commonly used in data warehousing environments? A) Joint index B) ... (Read 122 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?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

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?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

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.

Protoneuridae is a family of damselflies. Most species are commonly known as threadtails, while othe Protoneuridae is a family of damselflies. Most species are commonly known as threadtails, while othe
Basal cell carcinoma, a frequent type of skin cancer that rarely metastasizes. Basal cell carcinoma, a frequent type of skin cancer that rarely metastasizes.
Paternity Determination by Blood Type Paternity Determination by Blood Type
Effects of Estradiol and Testosterone on Interfemale Aggression in Rats (Based on data from van de P Effects of Estradiol and Testosterone on Interfemale Aggression in Rats (Based on data from van de P
Electronic service information is available from aftermarket sources, such as All-Data and ... Electronic service information is available from aftermarket sources, such as All-Data and ...
The Joint Implementation Mechanism The Joint Implementation Mechanism
Video: Mechanics of Sound Animation

For a complete list of videos, visit our video library