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

Ankieta - Franczyzobiorcy Aviva dla Rodziny
28140
Civil War Quiz
1050
Test-fulger !
14712
KODATE’S BEHAVIOURAL INDEX - SHORT VERSION
40200
Pls take my quiz
1585
Самопреценка
21100
Food and Nutrition PreTest
10590
How do you score on the Birthie Scale?
105110
The English Grammar Quiz - take the quiz
2412174
Vocabulary 1
420
Kindergarten ELA: Understanding and Analysis of Literary texts
520
Primary 4 Mathematics SW2 Day 2 CBT 2 (tklesson.com)
1050
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker