1.3.2 Database Concepts

Which of the following best defines 'data'?

• Facts and statistics collected for reference or analysis

• Information processed and organized in a meaningful way

• Knowledge derived from study, experience, or instruction

• None of the above

What distinguishes 'information' from 'data'?

• Information is unprocessed raw facts

• Information is data processed in a meaningful way

• Information is less useful than data

• Information cannot be stored in a database

What is 'knowledge' in the context of data processing?

• Knowledge is the same as data

• Knowledge is the insight gained from processing information

• Knowledge is the raw facts without context

• Knowledge is the physical storage of data

What is a flat file database?

• A) A database where data is stored in multiple interconnected tables.

• B) A database where all the data is stored in a single table.

• C) A database that requires constant internet connectivity.

• D) A database used exclusively for multimedia files.

When might a flat file database be considered sufficient?

• A) When the database needs to handle complex queries and multiple users.

• B) When the database stores data that changes frequently.

• C) When there is only a small amount of data.

• D) When the data needs to be highly secure.

What is a relational database?

• A database where data is stored without any structured format

• A database where data is held in a single table

• A database where data is held in more than one table linked by relationships

• A database that does not support relationships between tables

Which of the following are components of relational databases?

• Tables, Keys, Relationships

• Files, Folders, Directories

• Nodes, Edges, Graphs

• Classes, Objects, Methods

What is a table in the context of databases?

• A) A collection of related data arranged in a tabular format consisting of columns and rows.

• B) A graphical representation of statistical data.

• C) A set of commands used in database management.

• D) A programming language for creating and managing databases.

What are fields in a database table?

• A) The tools used to input data into the database.

• B) The individual entries or data items in a table.

• C) The categories of data being stored, such as customer surname.

• D) The physical storage space where data is saved.

What does a row in a database table represent?

• A) A collection of related fields.

• B) The header or title of a table.

• C) A command in SQL.

• D) The collection of data for a specific entry in the table.