Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

SQL is the de facto standard for querying relational databases.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A)   Relational
B)   Flat-file
C)   Ad-Hoc
D)   Object-relationalE) A) and C)
F) B) and C)

Question 4

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

Accepted Answer

A)   Select
B)   Where Clause
C)   Link
D)   JoinE) A) and B)
F) B) and D) D

Question 5

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

Accepted Answer

A)   Foreign key
B)   Primary key
C)   Index
D)   None of the aboveE) All of the above
F) B) and C)

Exam 12: Introducing Databases

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