Chapter 1: Relational Databases and SQL

Pataasin ang iyong marka sa homework at exams ngayon gamit ang 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


Kaugnay na mga set ng pag-aaral

Ch. 1: Government of the People, By the People, and For the People

View Set

Total Compensation Chapter 5 Quiz

View Set

Use I = Increase, D = Decrease, or N = No effect, to indicate the effect on retained earnings for each of the listed transactions.

View Set