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"}

More Quizzes

Kentucky Snakes (Pt. 2)

1169

Which Voltron Character are You?