Understanding Database Management Systems

What is a Relational Database?

• A relational database is a software used for graphic design.

• A relational database is a collection of unstructured data.

• A relational database is a database that organizes data into tables with defined relationships between them.

• A relational database is a type of cloud storage service.

Which of the following is a NoSQL database?

• PostgreSQL

• SQLite

• MongoDB

• MySQL

What does SQL stand for?

• Structured Query List

• Structured Query Language

• Simple Query Language

• Standard Query Language

Which property ensures data consistency in a database?

• Availability

• Consistency

• Isolation

• Durability

What is the main purpose of database normalization?

• To increase data redundancy for faster access.

• The main purpose of database normalization is to reduce data redundancy and improve data integrity.

• To simplify database queries by merging tables.

• To enhance the visual representation of data in reports.

Which of the following is a characteristic of NoSQL databases?

• Supports only SQL queries

• Relational data storage

• Fixed schema requirements

• Schema-less data storage

What does ACID stand for in database management?

• Addition, Consistency, Isolation, Durability

• Atomicity, Consistency, Integration, Durability

• Atomicity, Consistency, Isolation, Durability

• Atomicity, Concurrency, Isolation, Durability

Which of the following is a feature of Relational Databases?

• Use of tables to store data with relationships between them.

• Data is organized in a hierarchical structure with no tables.

• Data stored in a single flat file without relationships.

• Use of complex data types like JSON and XML exclusively.

What type of database uses tables to store data?

• Graph database

• Object-oriented database

• Relational database

• NoSQL database

Which query language is used for relational databases?

• SQL

• HTML

• XML

• NoSQL