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

͞어로의 물건들
1260
Get to Know Me Quiz
1478
Famous Historical Pictures
520
Non Dominant Genders In Tech Women's History Month Quiz
14730
Which football/soccer player am I talking about?
1580
Rejoin Quiz
1166
Which Former San Francisco Amusement Park Are You?
20100
SMART INSTITUTE NMDCAT ENGLISH GRAMMAR TS
2010103
Do you have any recommendations in new papers today?
100
    Buffering the Vampire Season 2 : Round 2 Sexual Tension Award Showdown
630
Are u a wizard?
420
Eyes that move when they shouldn't
1780
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker