ICT200 topic 1

What is data?

• Processed information

• Raw facts

• Metadata

Which of the following is an example of a DBMS?

• MySQL

• Microsoft Excel

• Google Docs

A well-designed database leads to:

• Bad decisions

• Accurate and valuable information

• Complex management

Which database type supports a small group of users or a single department?

• Workgroup database

• Enterprise database

• Desktop database

Metadata refers to:

• Historical data

• Data about data

• Raw facts

What does a data warehouse store?

• Programming scripts

• Historical data optimized for decision support

• Current transactions

Which type of data is stored in its raw form?

• Structured data

• Unstructured data

• Semistructured data

Data redundancy occurs when:

• The same data is stored unnecessarily in multiple places

• Metadata is used in a database

• Security protocols are applied

The role of a DBMS includes:

• Security enforcement

• Application programming

• System hardware design

A cloud database is:

• Distributed across multiple physical locations

• Stored in a single physical location

• Used only for unstructured data