Basics Flashcards
1
Q
SQL stands for
A
Structured Query Language
2
Q
sql allows us to do what
A
access and manipulate db
3
Q
rdbms stands for
A
relational database management system
4
Q
table
A
collection of related data entries
5
Q
tables contain
A
records (rows) with data
6
Q
keywords are/aren’t case sensitive?
A
not case sensitive
7
Q
primary key
A
field/col in table that uniquely id’s table records
8
Q
primary key properties (3)
A
must contain unique value for each row, can’t contain NULL values, table has 1 primary key
