
DBMS Quiz 4CSE1 2025 LAB-4

Quiz
•
Computers
•
12th Grade
•
Medium
Sharfuddin Mohammed
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an entity in an Entity-Relationship model?
An entity is a random collection of data without any specific attributes.
An entity is a type of relationship between two objects.
An entity is a process that describes how data is manipulated.
An entity is a distinct object or thing in the real world that can be identified and has attributes.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Define the term 'relationship' in the context of ER diagrams.
A relationship in ER diagrams is a type of entity.
A relationship in ER diagrams represents the association between entities.
A relationship in ER diagrams is a graphical representation of data storage.
A relationship in ER diagrams defines the attributes of an entity.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of normalization in database design?
To increase data duplication for faster access.
To simplify complex queries by merging tables.
The purpose of normalization is to reduce data redundancy and improve data integrity.
To enhance the visual representation of data in reports.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the difference between primary key and foreign key.
A primary key is always a string, while a foreign key is always an integer.
A primary key is used for indexing, while a foreign key is used for sorting records.
A primary key can be duplicated across tables, while a foreign key cannot.
A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the role of a composite key in a database?
A composite key is used to encrypt data in a database.
The role of a composite key in a database is to uniquely identify a record using multiple columns.
A composite key is a single column that can be used to identify records.
A composite key is a type of index that speeds up database queries.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
List and explain any two types of data integrity constraints.
Check Constraint
Primary Key Constraint, Foreign Key Constraint
Unique Key Constraint
Not Null Constraint
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does relational algebra differ from SQL?
Relational algebra is a theoretical framework; SQL is a practical implementation with a specific syntax.
Relational algebra is used for data visualization; SQL is used for data storage.
Relational algebra requires a database connection; SQL does not.
Relational algebra is a programming language; SQL is a query language.
Create a free account and access millions of resources
Similar Resources on Wayground
8 questions
Big Data 2 starter

Quiz
•
9th - 12th Grade
10 questions
Basis data

Quiz
•
12th Grade
11 questions
Internet Gateway dan NAT

Quiz
•
12th Grade
15 questions
Blockchain Basics

Quiz
•
12th Grade
11 questions
Database Systems Planning, Design and Administration

Quiz
•
12th Grade
11 questions
1.3.2. Databases

Quiz
•
12th Grade
10 questions
Understanding Cybersecurity

Quiz
•
5th Grade - Professio...
15 questions
Understanding Relational Concepts

Quiz
•
12th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade