Database Management Systems

This is a category of software technology that enables analysts, managers and executes to gain insight into data through fast, consistent and interactive manner.

This form of data warehouse provides views of operational databases that are materialised for efficient access.

This method is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.

This is the data quality tool that provides a single environment that seamlessly integrates data quality within the data integration process.

This form of data allows data to be modeled and viewed in multiple dimensions.

This method in physical design structures should be used with highly redundant data such as tables with many foreign keys.

This task in data transformation includes the types of data manipulation a user need to perform on the selected parts of source records.

This type of logical extraction method extracts only the data that has changed, since a well defined event back in history.

This data model describes data from a high level and defines the problem rather than the solution from the business point of view.

This schema in data warehouse is a method of normalising the dimension tables in a star schema.

This property of data warehouse is not correct as data warehouses can be indexed to optimise performance.

This system model is a distributed system model which shows how data and processing is distributed across a range of processors.

Oracle allows a maximum of 20 database write processes.

PMON performs process recovery when user process fails.

This option is correct.