INTRODUCTION TO SQL

What does SQL stand for?

Structured Query Language

What is the primary goal of SQL?

To manage and manipulate relational databases

What is a collection of organized data stored electronically called?

Database

What is the smallest unit of data in a table representing a single attribute?

Field (Column)

What is a set of related fields representing one entity?

Record (Row)

What software stores, accesses, and manipulates data?

Database Management System (DBMS)

What type of database organizes data into tables with rows and columns?

Relational Database (RDBMS)

What program allows users to create, update, and manage relational databases?

Relational Database Management System (RDBMS)

Which SQL command is used to retrieve data?

SELECT

Which SQL command adds new data to a table?

INSERT

Which SQL command modifies existing data in a table?

UPDATE

Which SQL command deletes data from a table?

DELETE

Which SQL command creates a new table or database?

CREATE

Which SQL component defines and manages database structures?

Data Definition Language (DDL)

Which SQL component manipulates existing data?

Data Manipulation Language (DML)

Which SQL component controls access and permissions?

Data Control Language (DCL)

Which SQL component manages database transactions?

Transaction Control Language (TCL)

Which SQL component retrieves and organizes data?

Data Query Language (DQL)

What SQL operation combines data from multiple tables?

JOIN

What ensures that data is accurate, consistent, and follows rules?

Data Integrity

What uniquely identifies each record in a table?

Primary Key

What links two tables by referencing a shared column?

Foreign Key

What software ensures data consistency, backup, and security?

Database Management System (DBMS)

What is SQL’s main role in business applications?

Data retrieval and management

What is the key advantage of SQL in data handling?

Efficient, accurate, and secure management of information