Database Management

Question 1

What is a database in SQL?

Answer 1

is a structured collection of data that is stored, managed, and retrieved using a database management system (DBMS).

Question 2

What are SQL databases designed to handle?

Answer 2

large volumes of data efficiently and support various operations, including data insertaion, querying, updating, and deletion.

Question 3

In SQL databases, what is a Table?

Answer 3

the primary structure within a database, where data is organized into rows and columns. Each table represents a specific entity, such as customers, products, or orders.

Question 4

In SQL databases, what is a Schema?

Answer 4

the blueprint or architecture of the database that defines how data is organized, including tables, fields, relationships, and constraints.

Question 5

In SQL databases, what are Columns (Fields)?

Answer 5

The attributes or properties of the entity, where each column has a specific data type and holds a particular type of information.

Question 5

In SQL databases, what are Rows (Records)?

Answer 5

Individual entries in a table, where each row represents a single instance of the entity

Question 6

In SQL databases, what is a Primary Key?

Answer 6

A unique identifier for each record in a table, ensuring that each row can be uniquely identified.

Question 7

In SQL databases, what is a Foreign Key?

Answer 7

A field in one table that uniquely identifies a row of another table, used to establish a relationship between the two tables.

Question 8

In SQL databases, what are Indexes?

Answer 8

Structures that improve the sped of data retrieval operations on a database table at thecost of additional storage space and potentially slower data modification operations.

Question 9

In SQL databases, what are Views?

Answer 9

Virtual tables that provide a way to present data from one or more tables in a specific format without storing the data sepereately.

Question 10

In SQL databases, what are Stored Procedures?

Answer 10

Precompiled SQL statements that can be executed on the database server, encapsulating complex queries and operations for reuse and efficiency.

Question 11

In SQL databases, what are Triggers?

Answer 11

SQL code that automatically executes in response to certain events on a particular table or view, such as insertions, updates, or deletions.

Question 12

What does SQL stand for?

Answer 12

Structured Query Language

Question 13

What is a Relational Database?

Answer 13

are a type of database that organizes data into tables, which are structured in a way that allows them to be easily related to each other. Each table in a relational database represents a specific entity (like customers, products, or orders) and consists of rows (records) and columns (fields). The relational model is based on the concept of relation, where data is stored in relations (tables), and relationships between the tables are defined through foreign keys.

Question 14

What are some common Relational Database Management Systems?

Answer 14

MySQL
PostgreSQL
Oracle Database
Microsoft SQL Server
SQLite

Question 15

What is SQL?

Answer 15

is a standard programming language used for managing and manipulating relational databases. SQL is essential for tasks such as querying data, updating records, and managing database structures.

Question 16

What are a few SQL commands that define the structure of the database?

Answer 16

CREATE
ALTER
DROP

Question 17

CREATE, ALTER, DROP are a few commands from what SQL language?

Answer 17

Data Definition Language

Question 18

What commands in SQL manipulate the data within the databse?

Answer 18

SELECT
INSERT
UPDATE
DELETE

Question 19

SELECT, INSERT, UPDATE, DELETE are commands for what SQl language?

Answer 19

Data Manipulation Language

Question 20

What SQL commands control access to the data within the database?

Answer 20

GRANT
REVOKE