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

How well do you know Rati
1165
FedEx virtual ATC test, pen and paper recommended, good luck!
1050
Ujian Akhir Matematika
210
Test Je Kennis met Onze Quiz!
840
Verbs 2 Test 1
12610
Each Private Static Method Is a Candidate for a New Class
100
Ususret državnoj maturi: Prepoznaj vrstu zavisnosložene rečenice
1580
Rocket League Quiz
520
Trabajos de Inmigración en los EEUU
1050
Should benamahoon get annoyed over this?
1160
Discover the Ultimate Pirate Adventure Quiz!
320
Black Tag - Black Belt Theory
15851
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker