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.
Illustrates the term tkprof and how is this used?
In which case the functional dependencies are not equations? Describe briefly?
States the term Star Schema?
Briefly explain the functional differentiations between COGNOs and BO?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Write a short on the differences of the two principal types of packaged data models.
Define the Fully Functional dependency.
Illustrate in brief some of the products of the Sybase?
Write down a short note on the term concurrency transparency?
Name four applications which are employing for triggers in DBMS?
18,76,764
1944115 Asked
3,689
Active Tutors
1460958
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!