Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

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
{"name":"Database Management system from unit 2 and unit 3 for FYBSC(CS)", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is a primary key in a database?, Which of the following is not a type of database model?, What is the purpose of a foreign key in a database?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Preview Quiz-Week 5
12618
Valerie quiz
13616
Is Inbound Marketing Right for Your Business?
1160
ALLSAFE Certification Quiz
15815
Friend Aplication
10534
Chi vuol essere sub?
1169
Sirah of Prophet Muhammad (SAW)
10510
IV TEAM
420
Yenox 2019
11611
Wowow
1050
Binary
520
Fire safety
420
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker