SQL as the query language in Intro to Computing - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does SQL stand for?

SQL stands for Structured Query Language. It is a language used to communicate with databases.

beginner

What is the main purpose of SQL?

SQL is used to retrieve, insert, update, and delete data in a database. It helps users ask questions and get answers from data stored in tables.

beginner

Explain the SELECT statement in SQL.

The SELECT statement is used to get data from one or more tables. For example, SELECT * FROM Students; means get all data from the Students table.

beginner

What is a database table?

A database table is like a spreadsheet with rows and columns. Each row is a record, and each column is a field or attribute.

beginner

How does SQL help in real life?

SQL helps businesses and apps by organizing and finding information quickly. For example, a store uses SQL to find all customers who bought a product last month.

What SQL command is used to get data from a database?

A INSERT

B SELECT

C UPDATE

D DELETE

The SELECT command is used to retrieve data from a database table.

Which of these is NOT a basic SQL operation?

A Retrieve data

B Delete data

C Update data

D Paint data

SQL does not have a 'paint data' operation; it is used for data management like retrieve, delete, and update.

In SQL, what does a table represent?

A A collection of rows and columns

B A list of commands

C A programming language

D A type of software

A table is a collection of rows (records) and columns (fields) in a database.

Which SQL command adds new data to a table?

A SELECT

B UPDATE

C INSERT

D DELETE

The INSERT command is used to add new records to a table.

What does the '*' symbol mean in the query: SELECT * FROM Students;

A Select all columns

B Select no columns

C Select only one column

D Delete all data

The '*' means select all columns from the table.

Explain in your own words what SQL is and why it is useful.

Think about how you ask questions to a database.

Describe what a database table looks like and how SQL interacts with it.

Imagine a spreadsheet and how you get or change data in it.