0
What else can I help you with?
Why is it that weight batching of aggregate is more preferable to volume batching of aggregate?
why is batching of aggregate by weight is preferable than batching by volume
What is the use of nulls in a database?
Usually there is no use of nulls but in some case there might be some use. Like consider a case a persons address has been changed but the new address is not known. In this case it is prefer to left the field null instead of wrong address.
List two reasons why null values might be introducedin database?
1. special requirements for its use in SQL joins. 2. special handling required by aggregate functions and SQL grouping operators
What are statistical reports?
Statistics is a mathematical science pertaining to the collection, analysis, interpretation or explanation, and presentation of data.It also provides tools for prediction and forecasting based on data. Statistical methods can be used to summarize or describe a collection of data. To create statistical reports aggregate are used.Aggregate functions compute a single result value from a set of input values.
Functions of data warehouse?
A data warehouse functions as a repository for all the data held by an organisation. The main functions are to reduce cost of data storage, facilitate data mining, and facilitate ability to back up data at an organisational level.
Do Group functions include nulls in calculations?
FALSE
Are Count and Sum are types of aggregate functions?
Yes, they are aggregate functions. They are also statistical functions.
What is aggregate demand and what are the factors that affect aggregate demand?
nothing
What common fields contain?
aggregate functions.
Why interest rate has no affect on the aggregate demand?
The interest rate does affect aggregate demand. As the interest rate falls, aggregate demand increases and vice-versa.
Calculations that are performed on a group of records?
aggregate functions
What button do you click to use aggregate functions in your query?
Sigma
What is Nulls partner?
Zero
What is the key difference between the classical and Keynesian aggregate supply functions?
Classical Aggregate Supply function is vertical whereas the Keynesian Aggregate Supply function is positively sloped.
What restrictions apply to the use of aggregate function within the select?
Aggregate functions: COUNT, SUM, MIN, MAX, AVG NOTE: It can be used only in the SELECT list and in the HAVING clause. Using it anywhere else will be incorrect; also you cannot nest aggregate functions.
How would a rise in business affect the aggregate demand curve?
The aggregate demand curve shifts to the right
What are the factors that would affect the aggregate demand?
Consumption, investment, government spending, net exports, and aggregate expenditures.
