SQL Flashcards
1
Q
What does a Select statement do
A
Searches for and returns data
2
Q
What does the * character mean
A
Tells the database to return all fields. It can be replaced by specific fields
3
Q
What is a wildcard
A
Used to find records which match some sort of pattern.
The % symbol can be used to represent anything.
4
Q
What is SQL
A
A language used to tell databases what to do
5
Q
What can SQL be used for
A
Selecting, Updating and Deleting data
6
Q
What does the where clause do
A
A where clause filters the data