Database Management system from unit 2 and unit 3 for FYBSC(CS)

What is a primary key in a database?

A unique identifier for each record

A field that stores numbers

A field that stores text

A field that stores dates

Which of the following is not a type of database model?

Relational model

Hierarchical model

Network model

Object-oriented model

What is the purpose of a foreign key in a database?

Which SQL keyword is used to retrieve data from a database table?

SELECT

UPDATE

DELETE

INSERT

What is the purpose of normalization in database design?

Which of the following is an example of a relational database management system?

MySQL

MongoDB

Oracle

SQLite

What is the purpose of an index in a database?

To improve query performance

To store large binary files

To enforce data constraints

To create backup copies of data

Which of the following is not a type of database constraint?

Primary key constraint

Foreign key constraint

Unique constraint

Backup constraint

What is the purpose of a transaction in a database?

Which SQL keyword is used to add new rows to a database table?

INSERT

SELECT

UPDATE

DELETE

What is the purpose of a view in a database?

Which of the following is an example of a NoSQL database?

MongoDB

MySQL

Oracle

Cassandra

What is the purpose of a stored procedure in a database?

To encapsulate a set of SQL statements for reuse

To store large binary files

To enforce data constraints

To create backup copies of data

Which SQL keyword is used to modify existing data in a database table?

UPDATE

SELECT

INSERT

DELETE

What is the purpose of a database index?

Which of the following is not a type of database relationship?

One-to-one relationship

One-to-many relationship

Many-to-many relationship

Many-to-one relationship

What is the purpose of a database trigger?

To automatically execute a set of actions in response to a specific event

To store large binary files

To enforce data constraints

To create backup copies of data

Which SQL keyword is used to delete data from a database table?

DELETE

SELECT

UPDATE

INSERT

What is the purpose of a database schema?

Which of the following is an example of a database management system?

Oracle

Microsoft Excel

PostgreSQL

Adobe Photoshop

Database Management system from unit 2 and unit 3 for FYBSC(CS)

More Quizzes