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?

• 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

Software that allows users to define, manipulate, retrieve, and manage data stored in a database.

• Operational Data

• Data Modeling

• Database Management System (DBMS)

• Table

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

• Records must be either complete or not complete - no partials.

• Data is all 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.

• Changes made in the database are applied consistently, not referring to anything which has been edited/removed.

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

Which of the following statements about relational databases and NoSQL databases is true?

• Relational and NoSQL databases are both typically ACID compliant.

• Relational databases operate under the principle of strong consistency, while NoSQL databases operate under the principle of eventual consistency.

• Complex join operations are supported by both relational and NoSQL databases.

• Relational databases do not have to follow a strict schema like NoSQL databases.