DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
OLAP.
|
|
|
OLTP.
|
|
|
SMTP.
|
|
|
FTP.
|
Detailed explanation-1: -The data is stored, retrieved and updated in . Answer-D) The data is stored, retrieved, and updated in OLTP.
Detailed explanation-2: -Databases are used to store, retrieve and update data.
Detailed explanation-3: -State whether True or False: Data warehouse is generally updated in real-time. Answer-B) False. The Data warehouse is not generally updated in real-time.
Detailed explanation-4: -OLTP stands for online transaction processing (OLTP), whereas OLAP stands for online analytical processing. Both OLTP and OLAP are online processing systems. The basic difference between OLTP and OLAP is that OLTP works with the processing of transactions, and OLAP is more focused on analytical processing.
Detailed explanation-5: -You must update your data warehouse on a regular basis to ensure that the information derived from it is current. The process of updating the data is called the refresh process, and this chapter describes the following topics: About Refreshing Your Data Warehouse.