INF2603
OCT/NOV PORTFOLIO 2024
UNIQUE NO.
DUE DATE: 31 OCTOBER 2024
, INF2603
October/November Exam 2024
Unique Number:
Due Date: 31 Octoer 2024
Databases I
Question 1
1. (a) True
2. (b) False
3. (a) True
4. (a) True
5. (b) False
6. (a) CHECK
7. (c) EXISTS
8. (b) HAVING
9. (d) UPDATE
10. (e) LIKE
Question 2
a. Difference between a column constraint and a table constraint:
A column constraint applies only to a single column within a table and is used
to enforce data integrity specific to that column (e.g., NOT NULL or UNIQUE
constraints on a column).
A table constraint applies to multiple columns within the table or even the entire
table, allowing more complex integrity checks (e.g., PRIMARY KEY, FOREIGN
KEY, or CHECK constraints that might involve multiple columns).