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 DataStage and Informatica?
What are a Database system and its advantages?
Briefly describe the term a Cube and Linked Cube with reference to data warehouse?
Explain Data Only Page Locking in Sybase.
Describe in brief some of the criticism regarding Sybase IQ?
Write down brief note on the issues for database performance?
How can I partition any table in Sybase? Explain.
Write a short note on the difference between embedded and dynamic SQL?
Explain the loops?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
18,76,764
1959153 Asked
3,689
Active Tutors
1444924
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!