CSE 360 EVALUATION EXAM 2026 QUESTIONS AND
SOLUTIONS RATED A+
✔✔Normalization - ✔✔Breaks tables into related tables to reduce redundancy.
✔✔Black-box Testing - ✔✔Based on requirements.
✔✔White-box Testing - ✔✔Based on code.
✔✔Cyclomatic Complexity - ✔✔Formula: CC = Edges - Nodes + 2.
✔✔CREATE TABLE - ✔✔name (col TYPE CONSTRAINT);
✔✔SELECT - ✔✔cols FROM table WHERE condition;
✔✔INSERT INTO - ✔✔table (cols) VALUES (vals);
✔✔UPDATE - ✔✔table SET col=val WHERE condition;
✔✔DELETE FROM - ✔✔table WHERE condition;
✔✔DROP TABLE/DATABASE - ✔✔name;
✔✔JOIN - ✔✔SELECT * FROM t1 INNER JOIN t2 ON t1.id=t2.id;
✔✔PRIMARY KEY - ✔✔Unique, not null, prevents duplicates.
✔✔FOREIGN KEY - ✔✔References primary key in another table.
✔✔DDL - ✔✔CREATE, ALTER, DROP.
✔✔DML - ✔✔SELECT, INSERT, UPDATE, DELETE.
✔✔E-R Model - ✔✔Graphical database design.
✔✔DCL - ✔✔GRANT, REVOKE.
✔✔TCL - ✔✔COMMIT, ROLLBACK, SAVEPOINT.
✔✔Aggregation Functions - ✔✔COUNT(), SUM(), AVG(), MAX(), MIN(), GROUP BY,
HAVING.
✔✔Cardinality 1 to 1 - ✔✔Each X to one Y.
SOLUTIONS RATED A+
✔✔Normalization - ✔✔Breaks tables into related tables to reduce redundancy.
✔✔Black-box Testing - ✔✔Based on requirements.
✔✔White-box Testing - ✔✔Based on code.
✔✔Cyclomatic Complexity - ✔✔Formula: CC = Edges - Nodes + 2.
✔✔CREATE TABLE - ✔✔name (col TYPE CONSTRAINT);
✔✔SELECT - ✔✔cols FROM table WHERE condition;
✔✔INSERT INTO - ✔✔table (cols) VALUES (vals);
✔✔UPDATE - ✔✔table SET col=val WHERE condition;
✔✔DELETE FROM - ✔✔table WHERE condition;
✔✔DROP TABLE/DATABASE - ✔✔name;
✔✔JOIN - ✔✔SELECT * FROM t1 INNER JOIN t2 ON t1.id=t2.id;
✔✔PRIMARY KEY - ✔✔Unique, not null, prevents duplicates.
✔✔FOREIGN KEY - ✔✔References primary key in another table.
✔✔DDL - ✔✔CREATE, ALTER, DROP.
✔✔DML - ✔✔SELECT, INSERT, UPDATE, DELETE.
✔✔E-R Model - ✔✔Graphical database design.
✔✔DCL - ✔✔GRANT, REVOKE.
✔✔TCL - ✔✔COMMIT, ROLLBACK, SAVEPOINT.
✔✔Aggregation Functions - ✔✔COUNT(), SUM(), AVG(), MAX(), MIN(), GROUP BY,
HAVING.
✔✔Cardinality 1 to 1 - ✔✔Each X to one Y.
