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

tfester

  • Hero Member
  • *****
  • Posts: 534
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?


cloud

  • Sr. Member
  • ****
  • Posts: 343
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

cloud

  • Sr. Member
  • ****
  • Posts: 343

 

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?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

For a complete list of videos, visit our video library