Databases

Question 1

A collection of related data items, stored in a table as a row, representing a single instance of an entity.

Answer 1

record

Question 2

An object or concept about which data is stored in a database, often corresponding to a table.

Answer 2

entity

Question 3

Software that enables the creation, management, and use of databases, providing users with tools to add, update, delete, and retrieve data.

Answer 3

Database Managment System (DBMS)

Question 4

A type of DBMS based on the relational model, which uses tables to store data and relationships between data entities.

Answer 4

Relational Database Managment System (RDBMS)

Question 5

A standardized programming language used to manage relational databases and perform various operations on the data in them.

Answer 5

Structured Query Language (SQL)

Question 6

The four basic operations of persistent storage, representing the ways in which data is commonly managed in a database.

Answer 6

Create, Read, Update, Delete (CRUD)

Question 7

A collection of related data held in a structured format within a database, consisting of rows and columns.

Answer 7

table

Question 8

A column in a table, representing a property of the entity that the table describes.

Answer 8

attribute

Question 9

A classification that specifies the type of data that a particular column can hold (e.g., integer, text, date).

Answer 9

data type

Question 10

A single, horizontally-aligned set of fields in a table, representing a single record.

Answer 10

row

Question 11

A vertical set of data in a table, representing a specific attribute of all records in the table.

Answer 11

column

Question 12

A unique identifier for each record in a table, ensuring that no two rows have the same value in this column.

Answer 12

primary key

Question 13

A column (or columns) that establishes a relationship between data in two tables, typically a primary key from one table that appears as a column in another table.

Answer 13

foreign key

Question 14

A database model based on the idea of storing data in tables and the relationships between those tables.

Answer 14

relational model

Question 15

A connection between two or more tables in a database, based on one or more columns in these tables.

Answer 15

relationship

Question 16

A graphical representation of entities and their relationships to each other, typically used in designing or understanding a database structure.

Answer 16

Entity-Relationship Diagram (ERD)

Question 17

The structure of a database defined in a formal language, including tables, columns, data types, and relationships.

Answer 17

schema

Question 18

Data that describes other data, such as the structure, descriptions, and configuration of database objects.

Answer 18

metadata

Question 19

A centralized collection of information about database objects, including names, types, and descriptions of data

Answer 19

data dictionary

Question 20

A marker in a database that indicates missing, unknown, or inapplicable data in a column.

Answer 20

null value

Question 21

A database structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space.

Answer 21

index

Question 22

The division of a database or its elements into distinct independent parts to improve manageability, performance, or availability.

Answer 22

partitioning