FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The data administration subsystem helps you perform all of the following, except ____
A
backups and recovery.
B
query optimization.
C
security management.
D
create, change, and delete information.
Explanation: 

Detailed explanation-1: -The data administration subsystem of a DBMS helps users manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management.

Detailed explanation-2: -15. Identify the most common source of change data in refreshing a data warehouse. Answer-C) Queryable change data is the most common source of change data in accessing a data warehouse.

Detailed explanation-3: -Business meta data, which contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse.

Detailed explanation-4: -2. In which of the following, data are stored, retrieved and updated? Online Transaction Processing (OLTP) is a type of data processing in information systems that typically facilitate transaction oriented applications.

There is 1 question to complete.
Previous
Next