Two Dimensions of Data Model

Which of the following best describes the structural dimension of a data model?

• The way data is stored physically

• The operations that can be performed on data

• The way data is organized logically

• The algorithms used for querying data

In the relational model, the structural component is represented by:

• Tables (relations)

• Trees

• Graphs

• Objects

Which element is NOT a part of the structural dimension?

• Entities

• Attributes

• Relationships

• SELECT statement

The structural dimension in an ER diagram includes all EXCEPT:

• Primary keys

• Entity sets

• Data Manipulation Language

• Relationship sets

In a dimensional data model (used in data warehousing), the structural design uses:

• Algorithms

• Star or Snowflake schema

• Classes

• Transactions

What is the manipulative dimension of a data model responsible for?

• Displaying database schemas

• Defining storage devices

• Querying and updating data

• Managing network protocols

In the relational model, manipulative operations are performed using:

• UML

• SQL

• XML

• HTML

Which of the following is an example of a manipulative operation?

• CREATE TABLE

• SELECT * FROM Students

• Defining relationships

• Creating keys

Which SQL command is most related to the manipulative dimension?

• ALTER

• UPDATE

• CREATE

• DROP

The manipulative dimension allows users to:

• Only define tables

• Only modify database structure

• Insert, delete, and retrieve data

• Configure database hardware