Deck 12: Introducing Databases

Question 1

Which of the following is NOT a valid type of database?

A) Relational
B) Flat-file
C) Ad-Hoc
D) Object-relational

Answer 1

Ad-Hoc

Question 2

SQL is the de facto standard for querying relational databases.

Answer 2

True

Question 3

A _____ in your query allows you to express a relationship between one or more tables.

A) Select
B) Where Clause
C) Link
D) Join

Answer 3

Join

Question 4

A "where" clause is not recommended when using the DELETE statement.

Question 5

A _____________ consists of one or more columns in a table that contain a value that is unique across all records.

A) Foreign key
B) Primary key
C) Index
D) None of the above