Chapter 2 Flashcards

1
Q

When was SQL developed and by whom?

A

1970, IBM

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

What was the first company to implement SQL commercially?

A

Relational Software Inc. (Now Oracle)

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

What does DBMS stand for>

A

Database Management System

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

What is “set-oriented” in terms of SQL?

A

the way SQL processes data in groups rather than as individual units

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

What are keywords?

A

special words reserved only for querying, that cannot be used as a name of anything in the program

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

What does the SELECT statement do?

A

commands the database to retrieve data and return it to the user

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

What is a query?

A

a quest or command we pose concerning data from the database

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

What is syntax?

A

the rules governing how a programming language should be written

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