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 what are the roles performed by the SQL?
Illustrate the use and application of the DB Miner.
Explain the way to shrink a Database?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Explain the linked universes?
Name four applications which are employing for triggers in DBMS?
Give a brief differentiation between metadata and data dictionary?
Explain the ways to controlling Cursor Behavior.
Specify different types of transformations available in the Informatica?
Determine the concept of Relation Schema and a Relation?
18,76,764
1950856 Asked
3,689
Active Tutors
1435727
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!