DBMS Quiz 4CSE1 2025 LAB-4

DBMS Quiz 4CSE1 2025 LAB-4

12th Grade

10 Qs

quiz-placeholder

Similar activities

T Level OccSpec 4.3 Databases

T Level OccSpec 4.3 Databases

12th Grade

15 Qs

SQL - Basic concepts

SQL - Basic concepts

11th - 12th Grade

10 Qs

@tbinh1768/TIN ĐS HK1

@tbinh1768/TIN ĐS HK1

11th Grade - University

11 Qs

Câu hỏi về SQL

Câu hỏi về SQL

11th Grade - University

12 Qs

RDBMS - 1

RDBMS - 1

12th Grade

15 Qs

Intro to Databases

Intro to Databases

12th Grade - University

12 Qs

PF 3.06 Lifelong Employment

PF 3.06 Lifelong Employment

9th - 12th Grade

10 Qs

L.3. DBMS -2

L.3. DBMS -2

12th Grade

10 Qs

DBMS Quiz 4CSE1 2025 LAB-4

DBMS Quiz 4CSE1 2025 LAB-4

Assessment

Quiz

Computers

12th Grade

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?