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

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

IgA antibodies protect body surfaces exposed to outside foreign substances. IgG antibodies are found in all body fluids. IgM antibodies are the first type of antibody made in response to an infection. IgE antibody levels are often high in people with allergies. IgD antibodies are found in tissues lining the abdomen and chest.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

For a complete list of videos, visit our video library