Chapter 2 Flashcards
1
Q
When was SQL developed and by whom?
A
1970, IBM
2
Q
What was the first company to implement SQL commercially?
A
Relational Software Inc. (Now Oracle)
3
Q
What does DBMS stand for>
A
Database Management System
4
Q
What is “set-oriented” in terms of SQL?
A
the way SQL processes data in groups rather than as individual units
5
Q
What are keywords?
A
special words reserved only for querying, that cannot be used as a name of anything in the program
6
Q
What does the SELECT statement do?
A
commands the database to retrieve data and return it to the user
7
Q
What is a query?
A
a quest or command we pose concerning data from the database
8
Q
What is syntax?
A
the rules governing how a programming language should be written