Data and Knowledge management

What does the term 'data redundancy' refer to?

• The security of data

• The ability to share data easily

• The presence of duplicate data in multiple files

• The absence of duplicate data

What is the main advantage of using a Database Management System (DBMS)?

• It enhcaned the data security

• It centralizes data and controls redundancy

• It requires more manual data entry

• It only supports unstructured data

What is the purpose of normalization in database design?

• To streamline complex data groupings

• To eliminate strange data

• To decrease data redundancy

• To create more complex relationships

What does the term 'big data' refer to?

• Massive sets of structured data

• Massive sets of unstructured/semi-structured data

• Massive sets of unstructured data

• Massive sets of structured/semi-structured data

What does OLAP stand for?

• Online Analytical Processing

• Offline Analytical Processing

• Operational Linear Analytical Processing

• Online Linear Analytical Processing

What is a primary key in a relational database?

• A field that links to a key in another table

• A field used to uniquely identify each record

• A field that contains only numeric data

• A field that can be duplicated

What is the purpose of a data warehouse?

• To maintain data redundancy for analysis

• To store only real-time data for analysis

• To consolidate and standardize information for analysis

• To eliminate unused data for analysis

What is a foreign key in a relational database?

• A field that uniquely identifies a record

• A field that links to a key in another table

• A field that contains only numeric data

• A field that can be duplicated

Which of the following best describes data mining?

• The process of storing data to discover patterns

• The analysis of large datasets to discover patterns

• The creation of new data to discover patterns

• The designing of data to discover patterns

Which of the following is a characteristic of NoSQL databases?

• They use fixed schemas

• They are designed for unstructured data

• They require SQL for data manipulation

• They are only suitable for small datasets