Chapter 1: Relational Databases and SQL
Ace your homework & exams now with Quizwiz!
A_____ uniquely identifies each row in a table
Primary key
To retrieve or update the data in a database, the client sends a ______ to the database
Query
When a column in a table is defined, it's given a data _____ that determines what kind of data it can store
Type
To relate one table to another, a ______ in one table is used to point to the primary key in another table.
Foreign key
A relational database consists of one or more
tables
True or False: A NULL value is the same thing as a space or blank
False
SQL statements that define the tables in a database are referred to as ________ statements
DDL