База данных

What is a database?

• A database is a type of software used for web browsing.

• A database is a physical storage device for files.

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

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

What is the purpose of a database management system (DBMS)?

• To manage user interface design

• To create and design websites

• The purpose of a database management system (DBMS) is to manage and organize data in a structured way.

• To perform complex mathematical calculations

Name three types of databases.

• Object-oriented

• Graph

• Flat-file

• Relational, NoSQL, In-memory

What is SQL and what is it used for?

• SQL is a markup language for designing websites.

• SQL is used for creating web applications.

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

• SQL is a type of spreadsheet software.

What does the acronym ACID stand for in database management?

• Accessibility, Compatibility, Integrity, Durability

• Atomicity, Consistency, Isolation, Accessibility

• Accuracy, Clarity, Integrity, Stability

• Atomicity, Consistency, Isolation, Durability

What is a primary key in a database?

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

• A primary key is a type of foreign key.

• A primary key can be duplicated across records.

• A primary key is used to store large amounts of data.

What is a foreign key?

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

• A foreign key is a type of primary key.

• A foreign key is a field that contains only null values.

• A foreign key is a field in a table that links to the primary key of another table.

Explain the difference between a relational and a non-relational database.

• Relational databases are faster than non-relational databases.

• Non-relational databases only store images and videos.

• Relational databases use structured tables and SQL, while non-relational databases use flexible formats and do not require fixed schemas.

• Relational databases do not support transactions.

What is normalization in databases?

• Normalization in databases is the process of organizing data to minimize redundancy and dependency.

• A technique for data encryption

• A way to visualize database relationships

• A method to increase data redundancy

What is a database schema?

• A database schema is the structure that defines the organization of data in a database.

• A database schema is a programming language for databases.

• A database schema is a type of database management system.

• A database schema is a backup of the database data.