stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DATA Design Quiz Flashcards | StudBud
Explore
/
DATA Design Quiz
DATA Design Quiz
12 terms
·
StudBud Administration
·
10 plays
Imported from external platform
Flashcards
12 cards
F
Practice quiz
P
Host live
L
Questions
12
Answers
1
Which normal form requires that a table has no repeating groups and all fields contain atomic values?
Third Normal Form (3NF)
First Normal Form (1NF)
Second Normal Form (2NF)
Unnormalized Form (UNF)
2
Why is file processing still relevant?
It handles structured data with predictable formats efficiently
It encrypts structured data better than DBMS
It is required for mobile app development
It automatically eliminates redundancy
3
What issue does the unnormalized STUDENT table contain?
Duplicate primary keys
Repeating groups
Transitive dependencies
Missing primary keys
4
Which of the following is NOT a data control mechanism?
Crow’s foot notation
Subschemas
Encryption
Audit Trails
5
What does the term “data independence” refer to in the context of a DBMS?
Ability to access data without worrying about physical storage
Redundancy in the schema and subschema
Changes in data format requiring major application updates
Isolating employee records from payroll modules
6
In crow’s foot notation for ERDs, what symbol represents a "many" relationship?
A single bar
A double bar (
A circle
A crow’s foot
7
Which storage type is responsible for how data is physically written to hardware?
Logical storage
Physical Block Mapping
Physical storage
Write storage
8
In the DBMS environment, who is responsible for defining authorization procedures and backup strategies?
System Analyst
Database Handler
Middleware
Database Administrator
9
Why is a junction table required for a many-to-many (M:N) relationship?
To reduce the number of tables in the database
To encrypt relationship data for security
To combine two tables into a single table
To split the M:N relationship into two one-to-many (1:M) relationships
10
What is the role of middleware in web-based database systems?
It acts as a translator between web server and database
It protects the database from security attacks
It filters client-side CSS
It translates HTML to CSV
11
What is the primary purpose of a foreign key (FK) in a relational database?
To encrypt sensitive data in the database
To establish relationships between tables by referencing a primary key
To act as a unique identifier for each record in a table
To store multiple values for a single attribute
12
What is the primary benefit of using derivation codes?
They reveal meaningful data from combined attributes
They allow users to encode passwords
They reduce the size of binary storage
They are encrypted by default
