SQL Basics

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

What is the purpose of  *?

• Selects ALL fields from the table
• Selects only the first field in the table
• Selects the last field in the table
• Shows only the first row in the table

True/False?
SQL table names are case sensitive

• True
• False

What does SQL stand for?

•  Structured Query Language
•  Structured Question Language
•  Strong Question Language
•  Strong Query Language

Which SQL statement is used to insert new data in a database?

•  ADD NEW
•  ADD RECORD
•  INSERT NEW
•  INSERT INTO

A column in a database

• record
• row
• field
• data

Boolean Data is?

• True or False
• Numbers
• Letters
• Special Characters

In a database, records of data are kept in tables.

• True

• False

In a table, a record is

• a group of data about one thing, one person or one event.

• a compilation of songs to play

• a plastic sheet with data on it

Schools use SIMS database to store information about students. Which will not be inside the student_details table?

• name

• gender

• colour of hair

• date_of_birth