Font size
WorksheetsData Processing SS2
Total questions: 67
Worksheet time: 41mins
What is a data model?
A. A type of computer hardware
B. A collection of tools for describing data
C. A programming language
D. A file-saving format
Which of the following is NOT a type of data model?
Conceptual
Logical
Physical
Instructional
A conceptual data model mainly describes:
How data is stored on disk
The high-level structure of the data
File path addresses
CPU data flow
A logical data model focuses on:
Relationships and attributes
Physical storage format
File compression rules
Operating system processes
A physical data model deals with:
High-level user requirements
Hardware-level implementation
Logical table design
Data independence
Which data model is closest to how users understand data?
Physical
Conceptual
Logical
Mathematical
Which model translates conceptual designs into database structures?
Star schema
Logical model
Physical model
Data dictionary model
Indexes and partitions belong to which model?
Conceptual
Logical
Physical
Mathematical
Which model shows entities and relationships?
Conceptual
Physical
File model
Hardware model
Which model is most detailed in terms of storage?
Conceptual
Logical
Abstract
Physical
An ER model is mainly used to:
Produce computer graphics
Represent entities and their relationships
Store security passwords
Analyze CPU speed
In an ER diagram, an entity is represented as:
Circle
Rectangle
Triangle
Arrow
A relationship is represented as a:
Arrow
Diamond
Rectangle
Parallelogram
An attribute is represented using:
Oval
Rectangle
Hexagon
Diamond
15. ER diagrams are mostly associated with:
Which of the following is NOT part of an ER model?
Entity
Attribute
Relationship
Algorithm
In an ER model, a characteristic of an entity is called:
Field
Attribute
Tuple
Key
A weak entity depends on:
Operating system
Another entity
File system
Database size
ER modeling helps in:
Data visualization
Data structure planning
Memory management
Internet connection
ER modeling is mostly used during:
Maintenance stage
Implementation stage
System design stage
Testing stage
The relational model was proposed by:
Bill Gates
E. F. Codd
Charles Babbage
Larry Ellison
A table in a relational model is also known as a:
Relation
Field
Cell
Schema
A row in a table is called a:
Attribute
Tuple
Key
Domain
A column in a table is called a(n):
Entity
Attribute
Relationship
Index
A domain refers to:
Internet server
Valid values for an attribute
Memory address
Table name
The relational model is based on:
Hierarchical structure
Mathematical set theory
Network topology
File systems
A collection of relations is called a:
Cluster
Schema
Domain
Tuple
29. Relational databases enforce:
A relational database typically uses:
SQL
HTML
Python
XML exclusively
A star schema is commonly used in:
Web design
Data warehousing
Mobile app development
Network cabling
In a star schema, the central table is called:
Fact table
Entity table
Attribute table
Master table
Dimension tables in star schema provide:
Measures
Descriptive details
Passwords
Execution paths
Fact tables mainly store:
Usernames
Numeric measures
CSS files
Code libraries
A star schema looks like a star because of:
Network devices
Fact table at center connected to dimensions
Web links
Hardware nodes
Star schema simplifies:
complex queries
data redundancy
database normalization
data security
Which is usually larger?
Dimension table
Fact table
ER table
Physical table
Dimension tables are usually:
Deep and narrow
Wide and descriptive
Invisible
Numeric only
A star schema is ideal for:
Transaction processing
Reporting and analytics
File backup
Operating system installation
Facts are connected to:
SQL servers
Dimensions
Algorithms
Processes
Normalization is mainly used to:
Increase redundancy
Reduce redundancy
Delete data
Slow down queries
First Normal Form requires:
No partial dependency
No transitive dependency
No repeating groups
No foreign keys
Second Normal Form is built on:
1NF
3NF
Star schema
File paths
2NF removes:
Transitive dependency
Partial dependency
Atomicity
Primary keys
A table is in 2NF when:
It is in 1NF and has no partial dependency
It has no foreign keys
It has no rows
It has only numeric data
Third Normal Form removes:
Composite keys
Transitive dependencies
Primary keys
Stored procedures
A table is in 3NF if it is in 2NF and has:
No Useless columns
No transitive dependency
No attributes
No data
Normalization improves:
Storage cost only
Data integrity
System color theme
Computer graphics
Unnormalized tables usually contain:
Atomic
Composite
Redundant
Null
An entity is best described as:
A measurable quantity
An object of interest
A search query
A network device
An attribute is:
A table
A characteristic of an entity
A function
A database server
A relationship connects:
Attributes to domains
Entities to entities
Keys to CPUs
Tables to RAM
A primary key must be:
Unique
Redundant
Repeating
Null
A foreign key is used to:
Back up data
Link two tables
Encrypt tables
Delete relationships
A good primary key should NOT:
Be unique
Change frequently
Identify each record
Be stable
A foreign key refers to a:
A composite key consists of:
Many tables
Multiple attributes
External devices
Functions
A relationship type includes:
1:1
1:M
M:N
All of the above
Attributes that uniquely identify entities are called:
Foreign fields
Candidate keys
Null attributes
Dimensions
A table with 1NF still violates 2NF when it has:
Atomic values
Partial dependency
Foreign keys
Unique rows
The fact table primarily contains:
Transformed data only
Measurable facts
ER diagrams
Attributes only
A dimension table supports analysis by providing:
Context to facts
Backup drives
Machine code
Temporary folders
In star schema, fact tables connect to dimensions through:
Foreign keys
Algorithms
Software drivers
File extensions
Logical models include:
Tables and attributes
Cables
Operating systems
Videos
Physical models specify:
Database server storage details
User stories
Web icons
App colors
One benefit of normalization is:
Smaller disk drives
Reduced update anomalies
Colorful dashboards
Faster hardware boot
ER models help form the basis for:
Conceptual database designs
CSS files
Routers
Mobile networks
A schema describes:
The structure of a database
The size of an image
The RAM requirement
A software license
