Database Models Quiz

Which of the following best describes the primary purpose of a data model?

• To store data in tables

• To create user interfaces

• To describe the structure, relationships, semantics, and constraints of data

• To optimize database performance

At which levels does database design occur according to the video?

• Physical, logical, and view levels

• Conceptual, implementation, and user levels

• Hardware, software, and network levels

• Data, information, and knowledge levels

Which of the following is NOT mentioned as one of the four main categories of data models discussed in the presentation?

• Relational model

• Entity-relationship model

• Object-based data model

• Hierarchical data model

In the relational model, how are relationships between data represented?

• As separate objects

• As tables

• As attributes

• As hierarchies

Why is the relational model referred to as a "record-based model"?

• Because it only stores historical records

• Because it uses fixed format records with several data types

• Because it records all database transactions

• Because it is based on audio recordings

What is the primary use of the Entity-Relationship (ER) model in database management?

• For data storage

• For query optimization

• For database design

• For user authentication

In an ER model, what represents the relationship between entities?

• Attributes

• Tables

• Fields

• Connecting lines or verbs (e.g., "works for", "manages")

What is a key characteristic of the object-based data model?

• It uses only tables to represent data

• It combines ER model features with object-oriented concepts

• It is primarily used for data transfer between applications

• It is the most widely used model in current database systems

What is a distinguishing feature of the semi-structured data model?

• It always uses a fixed schema

• It is used primarily for relational databases

• Individual data items of the same type may have different sets of attributes

• It cannot be used for data transfer between applications

Which language is mentioned as supporting the semi-structured data model?

• SQL

• Java

• HTML

• XML