WorksheetsDatabase Technologies Quiz
Total questions: 25
Worksheet time: 25mins
An organized collection of data that allows for efficient storage, retrieval, and management of informatio
(a)
a type of database management system that organizes data into structured tables with rows and columns.
(a)
Define the type of data stored in each row.
(a)
A unique identifier for each row in a table.
(a)
A field in one table that refers to the primary key of another table, establishing a link between them.
(a)
Suitable for unstructured or semi-structured data.
NoSQL
NewSQL
Combines the scalability of NoSQL with the structure of RDBMS.
(a)
Stores data in main memory for fast access.
(a)
The relational model organizes data into hierarchical structures.
True
False
SQL is a programming language specifically designed for database management.
True
False
Data modeling is the process of creating a visual representation of a database.
True
False
Primary keys uniquely identify records within a table.
True
False
Foreign keys establish relationships between different tables.
True
False
NoSQL databases use the relational model.
True
False
Data integrity ensures the accuracy and consistency of data.
True
False
Data modeling is the process of creating a visual representation of an entire information system or parts of it to communicate connections between data points and structures.
True
False
Data modeling is only useful for database design.
True
False
A conceptual data model is the most detailed type of data model.
True
False
Logical data models focus on how data will be physically stored.
True
False
Physical data models are specific to a particular database management system (DBMS).
True
False
Data modeling helps improve data quality.
True
False
What type of data model organizes data into one or more tables (or "relations") of columns and rows, with a unique key identifying each row?
(a)
What is the term for a row in a relational database table?
(a)
What is the term for a column in a relational database table?
(a)
What is the term for a column in one table that refers to the primary key of another table, establishing a link between them?
(a)
