WorksheetsTwo Dimensions of Data Model
Total questions: 10
Worksheet time: 5mins
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
