Database Management System (DBMS) Concepts Quiz

Test your knowledge on database management system concepts with questions on SQL, normalization, NoSQL, and more. Perfect for database enthusiasts!

Practice Learn Test

Which of the following is not a type of database management system?

Relational DBMS

NoSQL DBMS

Hierarchical DBMS

Analytical DBMS

Which SQL statement is used to extract data from a database?

GET

EXTRACT

SELECT

PULL

1 answered

What is a primary key?

A key that uniquely identifies each row in a table

A key that is primary to all tables

A main key used for multiple tables

A key that unlocks the primary data

What is the purpose of the SQL 'JOIN' clause?

To concatenate strings

To combine rows from two or more tables, based on a related column between them

To insert a new record into a table

To update data in a database

What does the term 'OLTP' stand for?

Online Transaction Processing

Online Translation Process

Operational Transaction Processing

Operational Translation Procedure

Which of the following is NOT a valid SQL aggregate function?

SUM

COUNT

MAX

CREATE

What does ACID stand for in the context of databases?

Atomicity, Consistency, Isolation, Durability

Atomicity, Consistency, Integration, Durability

Association, Consistency, Isolation, Durability

Atomicity, Connection, Isolation, Durability

Which of the following best describes the concept of 'Data Encapsulation' in DBMS?

Combining data and methods into a single unit

Encrypting data to protect it from unauthorized access

The process of data backup and recovery

Separating data into packets for network transmission

Which of the following is not a characteristic of NoSQL databases?

Fixed schema

Scalability

Flexibility in storing unstructured data

Distributed computing

#10

Which of the following is an example of a Document-Oriented NoSQL database?

MongoDB

Redis

MySQL

Oracle

#11

In the context of database indexing, what is a 'B-tree'?

A binary tree structure optimized for disk storage

A balanced tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time

A basic tree structure used for hierarchical data representation

A binary tree that is unbalanced and used for database testing

#12

Which of the following is true about 'Triggers' in a database?

They are special types of stored procedures that are defined to execute automatically in place or after data modifications

They can only be used to validate data during inserts and updates

They are used to speed up the process of retrieving data from the database

They are primarily used for data backup and recovery processes

#13

In database normalization, which normal form is concerned with removing transitive dependency?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

#14

What does the term 'Sharding' refer to in database management?

Encrypting database files on disk

Duplicating data across multiple servers

Breaking a database into smaller, faster, more easily managed parts called shards

Creating a backup of a database

#15

Which one of the following best describes 'CAP Theorem' in distributed database systems?

It states that a distributed computer system cannot simultaneously guarantee consistency, availability, and partition tolerance.

It describes the capacity of a database to handle growth in the amount of data and transactions.

It outlines the principles for constructing and administering databases.

It defines the criteria for database security and data encryption.

#16

What is 'Two-phase Commit' protocol in databases?

A backup protocol that ensures data is saved in two different locations for safety

A data replication method that involves two different phases for data consistency

A synchronization protocol for ensuring that all participants in a distributed transaction either commit or roll back changes

A security protocol that requires two forms of identification from the user