Chapter 5: Database

In a relational database, what is a table?

• Field

• Record

• Collection of related records

• A database schema

What is a record in the context of a database?

• a table

• a field

• a collection of related database

• a single row in a table representing a complete set of related data

What is a field in a database?

• A record

• A table

• A column in a table representing a specific attribute or piece of data

• a collection of related records.

In a relational database, what does a relationship define?

• The physical location of data on the disk

• The connection between different tables

• The order of records in a table

• The primary key of a table

Which type of database is optimized for handling complex queries and transactions?

• Relational Database

• NoSQL Database

• Graph Database

• Graph Database

What is data warehousing?

• Storing data in a distributed manner

• Real-time processing of data

• A centralized repository for storing and analyzing historical data from various sources

• Managing data integrity in a database

What is the primary focus of operational databases?

• Analyzing historical data

• • Handling day-to-day transactions and queries

  
  

• Storing data for business intelligence

• Optimizing complex queries

Which type of database is best suited for handling unstructured and semi-structured data?

• Relational Database

• NoSQL Database

• In-Memory Database

• Columnar Database

What is ETL in the context of data warehousing?

• Extract, Transfer, Load - the process of cleaning data

• Extract, Transform, Load - the process of loading data into a data warehouse after processing

• Extract, Transfer, Link - the process of linking data across multiple tables

• Extract, Transform, Link - the process of transforming data for real-time processing

What is the goal of Business Intelligence (BI)?

• To focus on day-to-day operational tasks

• To analyze historical data for informed decision-making

• To optimize complex database queries

• To store and manage large volumes of unstructured data