« previous next »

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

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Arthroscopic surgery involves the surgery of a joint with the use of a flexible arthroscope and othe Arthroscopic surgery involves the surgery of a joint with the use of a flexible arthroscope and othe
False-color imagery of the Sun, a G-type main-sequence star, the closest to Earth. False-color imagery of the Sun, a G-type main-sequence star, the closest to Earth.
Optical microscopes are commonly configured for bright-field (transmitted), phas Optical microscopes are commonly configured for bright-field (transmitted), phas
Example of Index entry with Main Term and indented subterms. Example of Index entry with Main Term and indented subterms.
Structure of a complex of a type II DNA methylase with DNA Structure of a complex of a type II DNA methylase with DNA
World Regions in Global Context: Peoples, Places, and Environments World Regions in Global Context: Peoples, Places, and Environments
Video: Miller's reaction chamber experiment Animation

For a complete list of videos, visit our video library