SQL - Structured Query Language

Question 1

What is a database?

Answer 1

A database can store multiple tables which hold data. This data can be stored, edited, sorted and searched to find records containing specific criteria.t

Question 2

What is record?

Answer 2

A record is multiple fields of data linked to one specific subject, e.g. the rows in the table, completed for each unique entry into the table .

Question 3

What are the 3 SQL commands?

Answer 3

SELECT
FROM
WHERE

Question 4

For SELECT, in the database table, what is it referring to?

Answer 4

Selecting which fields should be displayed, e.g. the columns

Question 5

For SELECT, how are two fields separated?

Answer 5

With a comma, e.g. SELECT name, age

Question 6

For FROM, in the database table, what is it referring to?

Answer 6

The table name, e.g. FROM studentstbl

Question 7

For WHERE, in the database table, what is it referring to?

Answer 7

The condition that needs to be met, e.g. WHERE age > 18

Question 8

In WHERE, how would you show multiple conditions?

Answer 8

AND (boolean logic)

Question 9

What is the purpose of SQL?

Answer 9

A strucured query language that searches for data in a database table.

Question 10

What is a query?

Answer 10

When the user is searching for specific data in a table, e.g. meets specific criteria such as age limit.