DEPI

What is a database?

• a) A collection of algorithms

• b) A collection of data organized in a structured way

• c) A type of computer software

• d) A programming language

Which of the following is a popular relational database management system (RDBMS)?

• MongoDB

• CouchDB

• MySQL

• Redis

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Sequential Query Language

• Standard Query Language

Which command is used to retrieve data from a database?

• SELECT

• INSERT

• UPDATE

• DELETE

What is a primary key in a database table?

• A field that can contain duplicate values

• A unique identifier for each record in a table

• A key used to encrypt data

• A field that stores large binary data

Which type of database is designed to store data in a hierarchical structure?

• Relational database

• Network database

• Hierarchical database

• Object-oriented database

What is normalization in a database?

• The process of encrypting data

• The process of organizing data to reduce redundancy

• The process of backing up data

• The process of indexing data

Which of the following is NOT a type of SQL join?

• INNER

• OUTER

• CROSS

• PARALLEL

What does ACID stand for in the context of databases?

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Integrity, Durability

• Atomicity, Confidentiality, Isolation, Durability

• Accuracy, Consistency, Isolation, Distribution

Which command is used to remove a table from a database?

• DELETE

• DROP

• REMOVE

• CLEAR