What is Aggregate Awareness
Explain the Aggregate Awareness?
Expert
Aggregate awareness refers to the characteristic of the DESIGNER which makes the use of aggregate tables within the database. These are tables which consist of the pre-calculated data. The aim of these tables is to improve the performance of the SQL transactions; they are therefore used in order to speed up the execution of queries.
Illustrates the properties of Cursors in brief?
Explain for what the Supervisor module is used?
Explain, why we use the lookup transformations?
What is OLAP? Briefly define it.
Write a short note on the differences between vertical and horizontal portioning?
Explain what is database connection?
What do you understand by the term cascading update in DBMS?
Specify the types of connections we use while connecting with the database?
What is the archtetype or instance pattern?
18,76,764
1926732 Asked
3,689
Active Tutors
1451852
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!