SQL - Session 4

When will an implication result in a False value? (i.e. when is p => q False)

• 0 => 0

• 0 => 1

• 1 => 0

• 1 => 1

In a SQL query, you can select specific rows (records) using...

• SELECT

• FROM

• WHERE

• USE

What will the result be of the following query?

(you can assume the student table has a lot of names in it, including Pascal, and Anne)

SELECT *

FROM student

WHERE [name] = '_a%'

• an error

• an empty table

• all info in student, from students who's name have the letter a in them

• all info in student, from students who's name has an a as the second letter

The UPDATE command is part of SQL's...

• DML

• DCL

• DDL

• DHL

The referential integrity states that a foreign key refers to a primary key or is.....