« previous next »

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

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Killer whales, like this one spotted near Alaska, commonly breach, often lifting their entire bodies Killer whales, like this one spotted near Alaska, commonly breach, often lifting their entire bodies
Palpation of the Temporomandibular Joint Palpation of the Temporomandibular Joint
Applying a surgical type of mask Applying a surgical type of mask
How to find the quartiles and percentiles for a data set How to find the quartiles and percentiles for a data set
Position sense of joint movement Position sense of joint movement
Data management short answer q Data management short answer q
Video: Muscle cell structures - actin, myosin and titin filaments

For a complete list of videos, visit our video library