ISYS 209 FINAL EXAM NEWEST 2026
ACTUAL EXAM| COMPLETE 250 REAL
EXAM QUESTIONS AND CORRECT
VERIFIED ANSWERS/ ALREADY GRADED
A+| ISYS 209 FINAL EXAM REVIEW
(MOST RECENT!!)
Section 1: Multiple Choice & Conceptual Questions
1. What is the primary purpose of a Database Management System (DBMS)?
A) To replace Microsoft Excel for simple lists.
B) To create and manage data visualizations for presentations.
C) To provide a systematic way to create, retrieve, update, and manage data.
D) To compile Java or Python code.
2. In a relational database, a "Foreign Key" is:
A) A key that is imported from an external system.
B) A primary key of another table that has been deleted.
C) An attribute in one table that refers to the primary key in another table.
D) A key that uniquely identifies each row in its own table.
3. Which of the following represents the correct order of the Data Hierarchy from
smallest to largest?
A) Database, Table, Record, Field, Byte
B) Field, Record, Table, Database
C) Byte, Record, Field, Table, Database
, D) Byte, Field, Record, Table, Database
4. The acronym ACID (Atomicity, Consistency, Isolation, Durability) refers to:
A) The four main data types in SQL.
B) The properties that guarantee database transactions are processed
reliably.
C) A NoSQL database model.
D) The steps of the SDLC (Systems Development Life Cycle).
5. Which SQL statement is used to change the data in an existing row?
A) INSERT
B) UPDATE
C) ALTER
D) MODIFY
6. What is a data warehouse?
A) A small database used for daily transactional processing (OLTP).
B) A large repository designed to hold massive amounts of historical data for
analysis and reporting (OLAP).
C) The physical location where server hard drives are stored.
D) A backup of your transactional database.
Section 2: SQL Query Writing
Scenario: You are working with a database for a small bookstore. It has the following
tables:
Books
,BookID (PK) Title AuthorID (FK) Price
101 The Lost City 501 19.99
102 Database Basics 502 45.00
103 The Silent Patient 501 12.99
Authors
AuthorID (PK) AuthorName Country
501 Sarah Jones USA
502 Mike Chen UK
503 Anna Lopez Spain
Write the SQL queries for the following requests:
7. Request: Show the Title and Price of all books priced above $15.
Correct Verified Answer:
sql
SELECT Title, Price
FROM Books
WHERE Price > 15;
8. Request: List all books and their authors' names by joining the two tables.
Correct Verified Answer:
sql
SELECT Books.Title, Authors.AuthorName
FROM Books
, INNER JOIN Authors ON Books.AuthorID = Authors.AuthorID;
9. Request: Count how many books are written by each author. Display
AuthorName and the BookCount.
Correct Verified Answer:
sql
SELECT Authors.AuthorName, COUNT(Books.BookID) AS BookCount
FROM Authors
LEFT JOIN Books ON Authors.AuthorID = Books.AuthorID
GROUP BY Authors.AuthorName;
(Note: LEFT JOIN is used to ensure authors with zero books are still listed with a count of
0).
10. Request: Find the average price of all books.
Correct Verified Answer:
sql
SELECT AVG(Price) AS AveragePrice
FROM Books;
Section 3: Normalization & Data Modeling
11. The table below is in which Normal Form?
OrderID | CustomerName | ProductID | ProductName | Quantity
Problem: ProductName depends only on ProductID, not on the full primary key
(OrderID + ProductID).
ACTUAL EXAM| COMPLETE 250 REAL
EXAM QUESTIONS AND CORRECT
VERIFIED ANSWERS/ ALREADY GRADED
A+| ISYS 209 FINAL EXAM REVIEW
(MOST RECENT!!)
Section 1: Multiple Choice & Conceptual Questions
1. What is the primary purpose of a Database Management System (DBMS)?
A) To replace Microsoft Excel for simple lists.
B) To create and manage data visualizations for presentations.
C) To provide a systematic way to create, retrieve, update, and manage data.
D) To compile Java or Python code.
2. In a relational database, a "Foreign Key" is:
A) A key that is imported from an external system.
B) A primary key of another table that has been deleted.
C) An attribute in one table that refers to the primary key in another table.
D) A key that uniquely identifies each row in its own table.
3. Which of the following represents the correct order of the Data Hierarchy from
smallest to largest?
A) Database, Table, Record, Field, Byte
B) Field, Record, Table, Database
C) Byte, Record, Field, Table, Database
, D) Byte, Field, Record, Table, Database
4. The acronym ACID (Atomicity, Consistency, Isolation, Durability) refers to:
A) The four main data types in SQL.
B) The properties that guarantee database transactions are processed
reliably.
C) A NoSQL database model.
D) The steps of the SDLC (Systems Development Life Cycle).
5. Which SQL statement is used to change the data in an existing row?
A) INSERT
B) UPDATE
C) ALTER
D) MODIFY
6. What is a data warehouse?
A) A small database used for daily transactional processing (OLTP).
B) A large repository designed to hold massive amounts of historical data for
analysis and reporting (OLAP).
C) The physical location where server hard drives are stored.
D) A backup of your transactional database.
Section 2: SQL Query Writing
Scenario: You are working with a database for a small bookstore. It has the following
tables:
Books
,BookID (PK) Title AuthorID (FK) Price
101 The Lost City 501 19.99
102 Database Basics 502 45.00
103 The Silent Patient 501 12.99
Authors
AuthorID (PK) AuthorName Country
501 Sarah Jones USA
502 Mike Chen UK
503 Anna Lopez Spain
Write the SQL queries for the following requests:
7. Request: Show the Title and Price of all books priced above $15.
Correct Verified Answer:
sql
SELECT Title, Price
FROM Books
WHERE Price > 15;
8. Request: List all books and their authors' names by joining the two tables.
Correct Verified Answer:
sql
SELECT Books.Title, Authors.AuthorName
FROM Books
, INNER JOIN Authors ON Books.AuthorID = Authors.AuthorID;
9. Request: Count how many books are written by each author. Display
AuthorName and the BookCount.
Correct Verified Answer:
sql
SELECT Authors.AuthorName, COUNT(Books.BookID) AS BookCount
FROM Authors
LEFT JOIN Books ON Authors.AuthorID = Books.AuthorID
GROUP BY Authors.AuthorName;
(Note: LEFT JOIN is used to ensure authors with zero books are still listed with a count of
0).
10. Request: Find the average price of all books.
Correct Verified Answer:
sql
SELECT AVG(Price) AS AveragePrice
FROM Books;
Section 3: Normalization & Data Modeling
11. The table below is in which Normal Form?
OrderID | CustomerName | ProductID | ProductName | Quantity
Problem: ProductName depends only on ProductID, not on the full primary key
(OrderID + ProductID).
