ISDS 3110 FINAL EXAM | FREQUENTLY TESTED QUESTIONS WITH CORRECT ANSWERS | BRAND NEW!

Page 1 of 9


ISDS 3110 FINAL EXAM | FREQUENTLY TESTED
QUESTIONS WITH CORRECT ANSWERS |
BRAND NEW!




Pattern Match Search Condition - *LIKE / NOT LIKE* - ✔✔✔ Correct
Answer > *%*

- Represents any sequence of zero or more characters
(wildcard)


*_*(underscore)
- Represents any single character


Subqueries - ✔✔✔ Correct Answer > A query within a query


*Multi-Table Join with Selection Predicates* example.


List the fname and lname of clients who are registered in
branches in 'London'. - ✔✔✔ Correct Answer > *SELECT DISTINCT*
c.fName, c.lName *FROM* Client c, Registration r, Branch b
*WHERE* c.clientNo = r.clientNo *AND* r.branchNo = b.branchNo
*AND* b.city = 'London'

, Page 2 of 9




Motivation for Normalization - ✔✔✔ Correct Answer > Problem 1. Data
Redundancy


Problem 2. Update Anomalies


Update Anomaly - ✔✔✔ Correct Answer > Relations that contain
redundant information may potentially suffer from update
anomalies


Types of Update Anomalies - ✔✔✔ Correct Answer > - *Insertion*
anomaly


- *Deletion* Anomaly


- *Modification* Anomaly


Solution to Avoid Update Anomalies - ✔✔✔ Correct Answer >
Decomposition


Decomposition must satisfy 2 properties: - ✔✔✔ Correct Answer > 1.
*lossless-join* property