SQL Flashcards

1
Q

what does SQL stand for

A

structured query language

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

how is sql similar to other programming languages

A

it has its own syntax and keywords

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

what are some of the different functions performed by sql

A

it can add, delete, select items items

it can also create, insert and drop tables

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

what is join used for

A

combine rows from two or more tables based on a related column

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

what is order used for

A

sort the table

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

what is set used for

A

used with update to specify the columns and values getting updated

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

what is or used for

A

used with the where function to include rows where either condition is true

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

what is like used for

A

used with where to search for a specific pattern in a column

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