SQL Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What does a Select statement do

A

Searches for and returns data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does the * character mean

A

Tells the database to return all fields. It can be replaced by specific fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is SQL

A

A language used to tell databases what to do

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What can SQL be used for

A

Selecting, Updating and Deleting data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does the where clause do

A

A where clause filters the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly