Fundamentals of Database Systems

What is a database?

• A database is a physical storage device for files.

• A database is a type of software used for graphic design.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a collection of random files without structure.

What is the purpose of a DBMS?

• To enhance the performance of computer hardware.

• To provide a platform for web hosting services.

• The purpose of a DBMS is to provide a systematic way to store, manage, and retrieve data.

• To create graphical user interfaces for applications.

What are the different types of databases?

• Object-oriented

• Flat-file

• Graph

• Relational, NoSQL, In-memory, Time-series

What is SQL?

• SQL is a programming language used for managing and manipulating relational databases.

• SQL is a markup language for web development.

• SQL is a programming language for creating mobile applications.

• SQL is a type of spreadsheet software.

What is a primary key?

• A primary key is a type of foreign key.

• A primary key can be duplicated in a table.

• A primary key is a unique identifier for a record in a database table.

• A primary key is used to store large text data.

What is a foreign key?

• A foreign key is a field that links two tables in a relational database.

• A foreign key is a field that stores data types.

• A foreign key is a unique identifier for a table.

• A foreign key is a type of primary key.

What is normalization?

• Normalization is a method for increasing data redundancy.

• Normalization refers to the process of data encryption.

• Normalization is a database design technique that minimizes redundancy and dependency by organizing fields and table relationships.

• Normalization is a technique for data visualization.

What are the ACID properties?

• Accuracy, Clarity, Integrity, Reliability

• Atomicity, Concurrency, Isolation, Timeliness

• Atomicity, Consistency, Isolation, Accessibility

• Atomicity, Consistency, Isolation, Durability

What is a relational database?

• A relational database is a collection of unrelated documents.

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

• A relational database stores data in a single file without relationships.

• A relational database is a type of spreadsheet software.

What is a NoSQL database?

• A NoSQL database is a non-relational database designed for large-scale data storage and flexible data models.

• A NoSQL database requires a fixed schema for data storage.

• A NoSQL database is primarily used for small-scale applications.

• A NoSQL database is a type of SQL database for structured data.