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

Jeffrey Quiz
1058
Nicolas cage
7425
Montana 1948
1580
Severe Pancreatitis
10518
100
Cherry's questions
210
Managing change at the workplace
7419
What Animal Are You??! Hello??!!!!
4218
How Well You Know Orleans
12624
KVÍZ - Tour de France
740
Consolidating the Soviet Union against our reminding enemies vote here!
100
Luxarmy kin test idk
1059
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker