Introduction to Databases

What is a database management system (DBMS)?

• A DBMS is the set of rules that defines how to write queries to access data in a database.

• A DBMS is the software layer that sits on top of the physical database storage and allows you to manage and interact with the data.

• A DBMS is a graphical user interface that illustrates the database content.

• A DBMS is an API that standardizes the connection to any type of database.

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

• A) Relational

• B) Graph

• C) Key-Value

• E) Musical

What is a key characteristic of a relational database?

• A) Data is organized into tables

• B) Data is organized into hierarchies

• C) Data is organized into objects

• D) Data is organized into files

The software that allows users to define, manipulate, retrieve, and manage data stored in a database is called...

• Operational Data System

• Data File

• Database Management System (DBMS)

• Table Structure

For ACID transaction properties, "Atomic" means...

• Operations on records must either complete or not complete - no partials.

• Data remains valid according to the defined rules of the databases

• Transactions do not affect any other transactions.

• Changes made within the database will remain in the system, even if it crashes immediately afterwards.

Which of the following represents a source system that contains structured Data ?

• A video file of a lecture.

• A collection of customer feedback saved in a text file.

• A JSON file containing user profiles, where each profile lists attributes like "firstName", "lastName", and "address" in a key-value format.

• A relational database containing customer information, where each row represents a customer and each column represents a customer attribute such as name, address, and phone number.

What does CRUD stand for?

• Create, Read, Update, Delete

• Compute, Retrieve, Upload, Download

• Copy, Replace, Undo, Destroy

• Connect, Receive, Utilize, Disconnect

In a distributed system facing a network partition,

which two guarantees must it choose between,

according to the CAP theorem?

• Consistency and Latency

• Availability and Throughput

• Consistency and Availability

• Latency and Partition Tolerance