DH20x - Databases Quiz 1

What is a data model?

• A physical database server

• An abstract representation of data organization and relationships

• A single attribute of an entity

• An approach to representation of data types with the help of a markup language

What type of model is it?

• Conceptual

• Logical

• Physical

What does "structure" refer to in information systems?

• The physical hardware of a database system

• The organized framework or arrangement of data

• A random collection of unrelated data points

• A type of database query

What is an entity in a database context?

• A programming function that processes data

• A distinct object or concept about which data is stored

• A type of relationship between two tables

• A visual representation of a database structure

In databases, what is an object?

• A specific instance of a data entity or class

• A rule that governs data integrity

• A type of relationship between tables

• A software tool for designing schemas

What does hierarchy mean in data modeling?

• A flat structure with no levels

• A system of organizing data in ranked levels or parent-child relationships

• A method for normalizing data

• A type of database table

What is a table in a relational database?

• A collection of rows and columns representing data about an entity

• A visual diagram of relationships

• A programming script for data retrieval

• A type of attribute

What is redundancy in a database?

• The process of optimizing queries

• Unnecessary duplication of data

• A method for linking tables

• A type of data hierarchy

In object-oriented databases, what is a class?

• A template defining properties and behaviors of objects

• A single row in a table

• A type of relationship cardinality

• A redundant data structure

What is a schema in a database?

• A physical storage device

• The overall structure or blueprint of a database

• A specific data entry

• A type of query language