OLAP and OLTP
Explain the following term: a) OLAP b) OLTP
Explain the following term:
a) OLAP
b) OLTP
Expert
OLTP:
In case, an on-line operational database system is utilized for the proficient retrieval and storage and management of the huge amounts of data, then the system is known as on-line transaction processing.
OLAP:
Data warehouse systems serves users (or) knowledge workers within the role of data analysis and decision-making. Such systems may organize and represent the data in several formats. These systems are called as the on-line analytical processing systems.
State functionality of the repository manager?
Define the Quick Sort.
Explain what is meant by the repository and what does it consists of?
What do you understand by the term foreign key in DBMS, and why is it employed for?
In what manner SAS so well-liked?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
What are the utilities Oracle gives, which are utilize for backup and recovery?
In Sybase does table Partitioning needs user-defined segments?
Briefly describe EDW?
State the term Sybase 365.
18,76,764
1930641 Asked
3,689
Active Tutors
1431494
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!