Why are aggregate functions called so? Name some aggregate functions. -Technology

Why are aggregate functions called so? Name some aggregate functions. -Technology
by

1 Answer

Answer :

Recruits support aggregate functions. These are ao called because they accept a record set and a field name as inputs and generate a single result. The supported aggregate functions are the following: 1) Count (FIELD) - Counts the number of occurences of a field. 2) Avg (FIELD) - Calculates the average (mean) of the numerical values of a field. 3) Sum (FIELD) - Calculates the sum of the numerical values. 4) Min (FIELD) - Calculates the minimum numerical value of a field. 5) Max (FIELD) - Calculates the maximum numerical value of a field. The aggregate functions are to be invoked in the field expressions in rescel. By default they are applied to the totality of the records in a record set.
by

Related questions

The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Last Answer : (d)Aggregate Function

What are the functions of an interpreter? -Technology

Description : What are the functions of an interpreter? -Technology

Last Answer : Interpreter is very useful for debugging and suitable for novice programmer. This is a slow process and consumes less memory space.Some basic functions of an interpreter are as follows:1. Translates one instruction at a time.2. It checks the execution of the instructions line-by-line.

What is an operating system? Explain its functions with an examples. -Technology

Description : What is an operating system? Explain its functions with an examples. -Technology

Last Answer : It is a program that acts as an interface between the user and the hardware (i.e. for all computer resources). An operating system is an important component of a computer system, which controls and ... users cannot access the system e.g. MS-DOS, Windows 95, Windows XP, Windows Vista etc.

Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Description : Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware and application softwares to be loaded; gives prompts and error reports to the users.2. Antivirus and compression tool.

State any two functions of operating system,. -Technology

Description : State any two functions of operating system,. -Technology

Last Answer : 1. Device managementIn a computer system, there is a tremendous speed mismatch between the CPU and the I/O devices. The job of an operating system is to maintain a balance between the CPU and I/O ... execution, a process needs certain resources such as CPU time, memory space, files and I/O devices.

Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Description : Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware, enables applications, software to be loaded; gives prompts and error reports to the users.2. Command-driven user interface means CUI, by which a user gives instructions via typing command onto the computer.

Write all the functions of Minimize button. -Technology

Description : Write all the functions of Minimize button. -Technology

Last Answer : The Minimize button is among the three buttons at the right end of the title bar. This button has a small dash (or minus sign). It shrinks the window and places it on the taskbar while leaving the program running. To go back to this window, click on taskbar where it is shrinked.

What is a File? Explain its functions. -Technology

Description : What is a File? Explain its functions. -Technology

Last Answer : FilesThese are the collection of information. In fact, almost all type of information is stored into the files. There are many types of files stored in different formats including operating system files, program ... period ( )).e.g. A document created using WordPad might have the filename John.rtf.

Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Description : Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Last Answer : The three functions that can be performed in Slide Sorter view are as follows:1. We can see the entire presentation.2. We can move slide from one place to another using click-drag method. Also, we can rearrange the order of slides.3. We can insert, rename and delete slides.

State three functions of the Slides Pane. -Technology

Description : State three functions of the Slides Pane. -Technology

Last Answer : Three functions of the Slides Pane are as follows:1. New slides may be added to the presentation.2. Allows marking a slide as hidden for not showing it during a slide show.3. Deleting a slide from the presentation in case it is no longer neede

……… is a program that appears harmless but actually performs malicious functions. -Technology

Description : ……… is a program that appears harmless but actually performs malicious functions. -Technology

Last Answer : Trojan horse is a program that appears harmless but actually performs malicious functions.

Suggest the appropriate functions for the following situations: -Technology

Description : Suggest the appropriate functions for the following situations: -Technology

Last Answer : 1. = MIN(A1 : C5)2. = IF(D5>5,000, “Discount”, “NoDiscount”)

Explain any five functions that can be used in a worksheet. -Technology

Description : Explain any five functions that can be used in a worksheet. -Technology

Last Answer : 1. SUM FunctionThis function, as clear from the name, is used to add all the values provided as an argument and to display the result in the cell containing the function.Argument Type All ... 0 (zero).Arguments that are error values or text that cannot be translated into numbers cause errors.

What are the main functions related to information? -Technology

Description : What are the main functions related to information? -Technology

Last Answer : Following are the three main functions related to information:1. Collecting information2. Storing information3. Distributing information

Elaborate the various functions of Multimedia. -Technology

Description : Elaborate the various functions of Multimedia. -Technology

Last Answer : Various functions of Multi Media - can be used as a great support in planning and executing any project, can be used to explain or propose a concept, using multimedia while preparing content ... topic makes the process more organized and precise, the teaching and learning can be more interactive.

Evaluate the various functions of advertising. -Technology

Description : Evaluate the various functions of advertising. -Technology

Last Answer : Various functions of advertising are - it introduces a new product into the market, it helps distinguish a product from its competitors, through persistent message and associations, it creates a brand identity, it ... it creates new demand, it creates a buzz and keeps the idea of the product going.

What is Pivoting? Name any two functions of Pandas which support pivoting. -Technology

Description : What is Pivoting? Name any two functions of Pandas which support pivoting. -Technology

Last Answer : Pivoting means to use unique values from specifiedindex/columns to form apex of the resulting dataframe.Pivot() and pivot_table() methods

Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Lakshmi works for a school. She wishes to create controls on a form for the following functions. -Technology

Description : Lakshmi works for a school. She wishes to create controls on a form for the following functions. -Technology

Last Answer : S.No.control used tocontrol1.Enter Admission numberText Field2.select StreamCombo Box3.select StreamCheck Box4.Clear the FromButton

State any two differences between single row functions and multiple row functions. -Technology

Description : State any two differences between single row functions and multiple row functions. -Technology

Last Answer : Differences between single row functions and multiple row functions.(i) Single row functions work on one row only whereas multiple row functions group rows(ii) Single row functions return one output per row whereas multiple row functions return only one output for a specified group of rows.

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

In explaining the level of unemployment, Keynes emphasized,- (a) Changes in technology. (b) Aggregate demand. © Inflationary expectations. (d) Lending by financial institutions.

Description : In explaining the level of unemployment, Keynes emphasized,- (a) Changes in technology. (b) Aggregate demand. © Inflationary expectations. (d) Lending by financial institutions.

Last Answer : (b) Aggregate demand.

Can you use two functions on your iPhone at the same time?

Description : Can you use two functions on your iPhone at the same time?

Last Answer : The ONLY thing you can do with another application open is listen to music. And no, in no way will this damage your iphone. It’ll just drain the battery a little bit faster.

An aggregate of people who, as individuals, have needs for products in a product class and have the ability, willingness and authority to purchase such products is called a : 1. market segment 2. target market 3. customer group 4. market 5. none of these

Description : An aggregate of people who, as individuals, have needs for products in a product class and have the ability, willingness and authority to purchase such products is called a : 1. market segment 2. target market 3. customer group 4. market 5. none of these

Last Answer : market

Pick up the correct statement from the following: (A) The ratio of total volume of voids in soil aggregates to the total volume of aggregate, is called Porosity (B) Water retained by the interstices due to molecular attraction, is called pellicular water (C) Sum of the percentage of specific yield and specific retention is 100 (D) All the above

Description : Pick up the correct statement from the following: (A) The ratio of total volume of voids in soil aggregates to the total volume of aggregate, is called Porosity (B) Water retained by the interstices ... (C) Sum of the percentage of specific yield and specific retention is 100 (D) All the above

Last Answer : Answer: Option D

An aggregate having all the pores are filled with water and also having its surface wet is called (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Description : An aggregate having all the pores are filled with water and also having its surface wet is called (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Last Answer : (b) Moist aggregate

An aggregate having all the pores filled with water but having dry surface is called . (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Description : An aggregate having all the pores filled with water but having dry surface is called . (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Last Answer : (c) Saturated surface dry aggregate

A service firm's aggregate plan A service firm's aggregate plan links the firm's st links the firm's strategic goals and objectives wit rategic goals and objectives with detailed h detailed operational plans called: a)Production plan b)Staffing plan c)Work-force schedule d) None of the above

Description : A service firm's aggregate plan A service firm's aggregate plan links the firm's st links the firm's strategic goals and objectives wit rategic goals and objectives with detailed h detailed operational plans called: a)Production plan b)Staffing plan c)Work-force schedule d) None of the above

Last Answer : c)Work-force schedule

An aggregate of people who, as individuals, have needs for products in a product class and have the ability, willingness and authority to purchase such products is called a: A)market segment B)target market C)customer group D)market

Description : An aggregate of people who, as individuals, have needs for products in a product class and have the ability, willingness and authority to purchase such products is called a: A)market segment B)target market C)customer group D)market

Last Answer : D)market

Which of the following statements is incorrect about materiality? a. The concept of materiality recognizes that some matters are important for fair presentation of financial statements in conformity with GAAP, while other matters are not important. b. An auditor considers materiality for planning purposes in terms of the largest aggregate level of misstatements that could be material to any one of the financial statements. c. Materiality judgments are made in light of surrounding circumstances and necessarily involve both quantitative and qualitative judgments. d. An auditor’s consideration of materiality is influenced by the auditor’s perception of the needs of a reasonable person who will rely on the financial statements

Description : Which of the following statements is incorrect about materiality? a. The concept of materiality recognizes that some matters are important for fair presentation of financial statements in conformity with ... s perception of the needs of a reasonable person who will rely on the financial statements

Last Answer : An auditor considers materiality for planning purposes in terms of the largest aggregate level of misstatements that could be material to any one of the financial statements

An aggregate which may contain some moisture in the pores but having dry surface is known as. (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Description : An aggregate which may contain some moisture in the pores but having dry surface is known as. (a) Dry aggregate (b) Moist aggregate (c) Saturated surface dry aggregate (d) All the above

Last Answer : (a) Dry aggregate

What is the difference in outcome in baking cookies, if you use butter in different aggregate phases?

Description : What is the difference in outcome in baking cookies, if you use butter in different aggregate phases?

Last Answer : The softer the butter, the more they will spread when being baked.

Aggregate of Adventurous World Records?

Description : Aggregate of Adventurous World Records?

Last Answer : Guinness Book of World Records. They are the authority on World Records.

Would a wage increase affect aggregate demand or supply?

Description : Would a wage increase affect aggregate demand or supply?

Last Answer : I don’t know much about economics, but the third option is that the effects might cancel out, meaning no change.

Is there an aggregate site for all of the weekly ad flyer deals?

Description : Is there an aggregate site for all of the weekly ad flyer deals?

Last Answer : Southern Savers is what I look at.

What are aggregate fruits? -Biology

Description : What are aggregate fruits? -Biology

Last Answer : answer:

What is the opposite of aggregate ?

Description : What is the opposite of aggregate ?

Last Answer : The opposite of the sum is 6

When the speed is included in the aggregate, even when it is excluded what it can be

Description : When it takes what speed a strange sound comes from the unit, what can it be on Peugeot3008 1.6 and 81kw diesel

Last Answer : Need Answer

What is aggregate supply exceeds aggregate demand what is likely to result?

Description : What is aggregate supply exceeds aggregate demand what is likely to result?

Last Answer : Need answer

What if your new material may aggregate or bring together pieces of information that are not in themselves classified but when you present them together they render your new material classified?

Description : What if your new material may aggregate or bring together pieces of information that are not in themselves classified but when you present them together they render your new material classified?

Last Answer : Your new material may aggregate, or bring together, pieces of information that are not individually classified, but when presented together they render your new material classified. This classification concept is called _______.Revealed byContained inDirected byClassification by Compilation

How does the nominal and real values of things affect the aggregate behavior of a society?

Description : How does the nominal and real values of things affect the aggregate behavior of a society?

Last Answer : In Economics, the nominal values of something are its moneyvalues in different years

How many wheelbarrows of aggregate are in 1 cubic metre of concrete?

Description : How many wheelbarrows of aggregate are in 1 cubic metre of concrete?

Last Answer : Feel Free to Answer

Going from left to right on the aggregate demand curve, real GDP _____.?

Description : Going from left to right on the aggregate demand curve, real GDP _____.?

Last Answer : rises as price level falls

According to the aggregate supply curve, what happens as the price level increases?

Description : According to the aggregate supply curve, what happens as the price level increases?

Last Answer : Firms have more of an incentive to increase output.

Concern about an international crisis has caused consumers to save their money and postpone big purchases. What is the effect on aggregate demand and aggregate supply?

Description : Concern about an international crisis has caused consumers to save their money and postpone big purchases. What is the effect on aggregate demand and aggregate supply?

Last Answer : aggregate demand will decrease, lowering both real GDP and the price level

What might happen to aggregate supply curve if there was a significant increase in the cost of foreign oil?

Description : What might happen to aggregate supply curve if there was a significant increase in the cost of foreign oil?

Last Answer : The aggregate supply curve shifts to the left as the price of key inputs rises, making a combination of lower output, higher unemployment, and higher inflation possible. When an economy experiences stagnant growth and high inflation at the same time it is referred to as stagflation.

Inflation occurs when aggregate supply is - (1) more than aggregate demand (2) less than aggregate demand (3) equal to aggregate demand (4) None of these

Description : Inflation occurs when aggregate supply is - (1) more than aggregate demand (2) less than aggregate demand (3) equal to aggregate demand (4) None of these

Last Answer : (2) less than aggregate demand Explanation: If the supply is less than the demand, the price will increase. Inflation, the persistent increase in the average price level, can be ... Translating this to the macro-economy suggests that inflation occurs when aggregate demand exceeds aggregate supply.

Aggregate net value of the output in one year is the - (1) National income at factor cost (2) Gross Domestic Product at market prices (3) Net. National Product at market prices (4) Gross National Product at market prices

Description : Aggregate net value of the output in one year is the - (1) National income at factor cost (2) Gross Domestic Product at market prices (3) Net. National Product at market prices (4) Gross National Product at market prices

Last Answer : (3) Net. National Product at market prices Explanation: Net national product at market price is the market value of the output of final goods and services produced at current price in ... at market price, Net national product at market price=Gross national product at market priceDepreciation.

The Keynesian consumption function shows a relation between - (1) aggregate consumption and total population. (2) aggregate consumption and general price level. (3) aggregate consumption and aggregate income (4) aggregate consumption and interest rate

Description : The Keynesian consumption function shows a relation between - (1) aggregate consumption and total population. (2) aggregate consumption and general price level. (3) aggregate consumption and aggregate income (4) aggregate consumption and interest rate

Last Answer : (3) aggregate consumption and aggregate income Explanation: According to Keynesian Theory of consumption, the current real disposable income is the most important determinant of consumption in the short run. It bases consumption on current income.

Acording to Keynesian theory of income determination, at full employment, a fall in aggregate demand causes - (1) a fall in prices of output and resources (2) a fall in real gross National product and employment (3) a rise in real gross National product and investment (4) a rise in prices of output and resources

Description : Acording to Keynesian theory of income determination, at full employment, a fall in aggregate demand causes - (1) a fall in prices of output and resources (2) a fall in real gross National product ... a rise in real gross National product and investment (4) a rise in prices of output and resources

Last Answer : (1) a fall in prices of output and resources Explanation: In 1936, John Maynard Keynes published the book "The General Theory of Employment, Interest and Money to explain the prolonged and ... at a below-full-employment equilibrium. Suppose that the economy is at the full-employment equilibrium.