can produce a table with several different analytical calculations such as a count, sum and average can PIVOT (slice) a dimension into sections based on each value of the measure produce a table with a hierarchy in the dimensions condense a large amount of data into a succinct table

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

As demonstrated, which of the following capabilities can SQL Pivot queries perform?    
 

can produce a table with several different analytical calculations such as a count, sum and average

can PIVOT (slice) a dimension into sections based on each value of the measure

produce a table with a hierarchy in the dimensions

condense a large amount of data into a succinct table

 

Which of the following is not true about PIVOT() queries

 

the base query can retrieve data using an extensive set of INNER JOINS

the base query can JOIN a maximum of three tables

the base query can be used to pre-process data such as using a GROUP BY()

the base query can be used to change the column names that will be displayed

 

Which of the following was taught as a requirement about using PIVOT() queries

 

place the higher cardinality dimension on the columns

you must use all the values of the dimension that specifies the columns

you must specify only three columns of data in the base SELECT query

You can use dates such as months, but not textual dimensions in the columns

 

Regarding the results of a PIVOT() query
 

the descriptive categorization can also be formatted with percentiles

the processing can improve the presentation of data when the granularity of the data is too high

the results are best used in a pie-chart

the will be close but not exactly the same as results yielded from using an Excel Pivot table

 

Which of the following is not a reason to use categories to analyze data? 
 

using a crosstab to analyze a metric by region can give strong insight

putting data into months can help to identify trends

data with high granularity is difficult to understand because there is so much of it

all are reasons to use categories to analyze data

 

Which SQL function below puts an equal amount of rows of data into each category?
 

NTILE() statements

CASE () statements

GROUP BY() statements

none of the options.

 

Which SQL function below puts data into programmer-defined categories
 

NTILE() statements

CASE () statements

GROUP BY() statements

none of the options.

 

 

 

Subject: MYSQL

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education