Font size
WorksheetsjsakDSAKDhJ!@#i(DBMS)
Total questions: 26
Worksheet time: 31mins
What is a Data Model?
A collection of unrelated files
A graphical representation of real-world data structures
A type of data anomaly
A backup procedure in DBMS
Which of the following is a problem with file-based systems?
Data independence
Data redundancy
Built-in security
No data anomalies
What does Data Redundancy lead to?
Improved data security
Data inconsistency
Faster data retrieval
Better data modeling
Business Rules are:
Technical instructions for DBMS
Brief, precise descriptions of organizational policies
Graphical representations of entities
Types of data anomalies
In an ER Diagram, what does a diamond represent?
Entity
Attribute
Relationship
Primary key
Which key uniquely identifies a row in a relational table?
Foreign Key
Candidate Key
Primary Key
Secondary Key
A Foreign Key must match the ______ of another table.
Candidate Key
Attribute
Primary Key
Entity
Which of the following is NOT a DBMS function?
Data dictionary management
Data redundancy creation
Multiuser access control
Backup and recovery
What is an Insertion Anomaly?
Difficulty deleting records
Difficulty updating records
Difficulty entering new records
Difficulty querying records
The Relational Model was developed by:
Chen
Codd
Newton
Turing
Which term describes a characteristic of an entity?
Relationship
Attribute
Constraint
Key
What is a Candidate Key?
A key that references another table
A key that may contain NULL values
A key that can qualify as a Primary Key
A key that is always composite
The Data Dictionary contains:
User passwords
Metadata about tables and attributes
Business rules
Backup files
Which data model uses a tree-like structure?
Network Model
Relational Model
Hierarchical Model
Entity Relationship Model
What does Referential Integrity ensure?
No NULLs in primary keys
Foreign keys match existing primary keys
Every table has a candidate key
Data is always redundant
True/False: A file system is better than a DBMS for avoiding data redundancy.
True/False: Business rules can be derived from nouns and verbs in organizational language.
True/False: In the relational model, how data is physically stored is important to the user.
True/False: An ERD is used to model database components graphically.
True/False: Data redundancy is always undesirable in a database.
Match the term with its description:
The ______ model was introduced by Chen in 1976.
(a) occurs when the same data is stored in multiple places.
A (a) is a restriction placed on data.
In a relational table, a row is also called a (a) .
The (a) contains detailed information about all tables in a database.
