Database management system

What is a primary key in a database?
A unique identifier for each record
A field that stores numeric values
A table that contains all the data
A query that retrieves information
Which of the following is an example of a relational database management system?
MySQL
MongoDB
Oracle Database
SQLite
PostgreSQL
What does SQL stand for?
What is the purpose of a foreign key in a database?
To establish relationships between tables
To store numeric values
To perform calculations
To retrieve data from multiple tables
Which of the following is not a type of database model?
Hierarchical
Relational
NoSQL
Object-Oriented
Linear
What is the purpose of normalization in database design?
To eliminate data redundancy and improve data integrity
To increase database performance
To add more tables to the database
To simplify query writing
Which SQL statement is used to retrieve data from a database?
SELECT
INSERT
UPDATE
DELETE
What is the purpose of an index in a database?
To improve query performance by allowing faster data retrieval
To store large binary objects
To enforce data constraints
To create relationships between tables
Which of the following is an example of a non-relational database management system?
MongoDB
MySQL
Oracle Database
SQLite
Cassandra
What is the purpose of a transaction in a database?
To ensure data consistency and integrity
To store large binary objects
To create relationships between tables
To improve query performance
{"name":"Database management system", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is a primary key in a database?, Which of the following is an example of a relational database management system?, What does SQL stand for?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Powered by: Quiz Maker