Illustrate the five SQL built-in functions
Illustrate the five SQL built-in functions.
Expert
COUNT: calculates the num of lines in a table.
SUM: totals numeric columns.
AVG: calculates the average value in SQL.
MAX: receives the maximum value of a column in a table.
MIN: receives the minimum value of a column in a table.
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Describe briefly the difference between identifier and attributes?
Provide a brief introduction of the term ‘Data warehousing ’?
Give a brief introduction of the term real time data-warehousing?
Illustrates the types of Data Independence?
Briefly explain continuous and discrete data in data mining?
Specify the options in the target session of the update strategy transformation?
Explain the term intelligent binning?
Explain about the stored-procedures and its advantages.
Described the impact of signed numbers upon the memory by using Data Structures?
18,76,764
1953741 Asked
3,689
Active Tutors
1449864
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!