1. The Basics of SQL Flashcards
1
Q
What does SQL stand for?
A
Structured Query Language
2
Q
What is SQL?
A
SQL is a computer language used to communicate with databases.
3
Q
What can a primary key not contain?
A
NULL values.
4
Q
What is a SELECT statement?
A
A SELECT statement is used to select data from a database.
5
Q
What is a primary key?
A
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record
6
Q
What is a record?
A
It is a row of columns in a table.
7
Q
What is a NULL value?
A
NULL values represent missing / unknown / unavailable data.
8
Q
Which character is used to close a statement?
A
Semicolon or ;
9
Q
What SQL statement is used to extract/choose data from a database?
A
SELECT statement
