SNHU DAD 220 COMPREHENSIVE EXAM QUESTIONS AND
SOLUTIONS 2025/2026 RATED A+
✔✔What does the INT data type store? - ✔✔This store INT values. This would include
any value needing numbers.
✔✔What does the DECIMAL data type store? - ✔✔Stores fractional numerical values.
Ex: Any table needing to store a dollar value.
✔✔What does the VARCHAR data type store? - ✔✔Stores textual values. Any table
need a piece of text like column name, storing first and last names, business names,
etc.
✔✔What does the DATE data type store? - ✔✔This data type stores the year, month,
and day of the year. For example, you would use this if you wanted to display the
current date that user logged in on.
✔✔True or False: Do you put a ';' at the end of the statements? - ✔✔True
✔✔What are the 3 big steps of Database Design? - ✔✔1. Analysis
2. Logical Design
3. Physical Design
✔✔What is an entity? - ✔✔An entity is a person, place, activity, or thing that is used in a
table. Ex: Column names such as 'Author','Book','Sale','Customer'.
✔✔What is a relationship? - ✔✔A relationship is the link between two entities. Ex: An
'Author' writes a 'Book'.
✔✔What is an attribute? - ✔✔A descriptive property of an entity. Ex: When you have the
entity of a 'Book', its attributes are things like ('Title','Category','Price').
✔✔What is a key? - ✔✔A column used to identify individual rows of a table. Ex: Key
columns could include Primary Keys and Foreign Keys.
✔✔What is data independence? - ✔✔It has the ability to modify the data of one schema
without ruining the total data store on the physical design.
✔✔What is an Application Programming Interface (API)? - ✔✔A library of procedures or
classes that link a host programming language to a database.
✔✔What is Structured Query Language (SQL)? - ✔✔A type of computer language used
for storing, manipulation, and retrieving data.
, ✔✔What is Data Definition Language (DDL)? - ✔✔Defines structures of a database.
✔✔What is Data Query Language (DQL)? - ✔✔Retrieves data from the database?
✔✔What is Data Manipulation Language (DCL)? - ✔✔Manipulates data stored in a
database.
✔✔What is Data Control Language (DCL)? - ✔✔Controls database user access.
✔✔What is Data Transaction Language (DTL)? - ✔✔The managing of database
transactions.
✔✔What is a database model and what are the components of a database model? -
✔✔A database model is a conceptual framework for databases.
1. Data structures (Prescribes how data is organized).
2. Operations (Manipulates data structures)
3. Rules (Governs valid data)
✔✔What is a relational database? - ✔✔A model based on a tabular data structure.
✔✔What does the JOIN command do? - ✔✔Combines two tables by comparing related
columns.
EX: SELECT Department.Name AS Group.employeeName AS Supervisor
FROM Department
INNER JOIN Employee
ON Manager = ID;
✔✔What does the INNER command do? - ✔✔Combines rows from two or more tables
based on related columns between them.
Ex:
SELECT Department.Name AS Group.employeeName AS Supervisor
FROM Department
INNER JOIN Employee
ON Manager = ID;
✔✔What does the INTERSECT command do? - ✔✔Combines two select statements
and returns only the dataset that is common in both the statements.
Ex:
SELECT supplier_ID
FROM suppliers
INTERSET SELECT supplier_ID
SOLUTIONS 2025/2026 RATED A+
✔✔What does the INT data type store? - ✔✔This store INT values. This would include
any value needing numbers.
✔✔What does the DECIMAL data type store? - ✔✔Stores fractional numerical values.
Ex: Any table needing to store a dollar value.
✔✔What does the VARCHAR data type store? - ✔✔Stores textual values. Any table
need a piece of text like column name, storing first and last names, business names,
etc.
✔✔What does the DATE data type store? - ✔✔This data type stores the year, month,
and day of the year. For example, you would use this if you wanted to display the
current date that user logged in on.
✔✔True or False: Do you put a ';' at the end of the statements? - ✔✔True
✔✔What are the 3 big steps of Database Design? - ✔✔1. Analysis
2. Logical Design
3. Physical Design
✔✔What is an entity? - ✔✔An entity is a person, place, activity, or thing that is used in a
table. Ex: Column names such as 'Author','Book','Sale','Customer'.
✔✔What is a relationship? - ✔✔A relationship is the link between two entities. Ex: An
'Author' writes a 'Book'.
✔✔What is an attribute? - ✔✔A descriptive property of an entity. Ex: When you have the
entity of a 'Book', its attributes are things like ('Title','Category','Price').
✔✔What is a key? - ✔✔A column used to identify individual rows of a table. Ex: Key
columns could include Primary Keys and Foreign Keys.
✔✔What is data independence? - ✔✔It has the ability to modify the data of one schema
without ruining the total data store on the physical design.
✔✔What is an Application Programming Interface (API)? - ✔✔A library of procedures or
classes that link a host programming language to a database.
✔✔What is Structured Query Language (SQL)? - ✔✔A type of computer language used
for storing, manipulation, and retrieving data.
, ✔✔What is Data Definition Language (DDL)? - ✔✔Defines structures of a database.
✔✔What is Data Query Language (DQL)? - ✔✔Retrieves data from the database?
✔✔What is Data Manipulation Language (DCL)? - ✔✔Manipulates data stored in a
database.
✔✔What is Data Control Language (DCL)? - ✔✔Controls database user access.
✔✔What is Data Transaction Language (DTL)? - ✔✔The managing of database
transactions.
✔✔What is a database model and what are the components of a database model? -
✔✔A database model is a conceptual framework for databases.
1. Data structures (Prescribes how data is organized).
2. Operations (Manipulates data structures)
3. Rules (Governs valid data)
✔✔What is a relational database? - ✔✔A model based on a tabular data structure.
✔✔What does the JOIN command do? - ✔✔Combines two tables by comparing related
columns.
EX: SELECT Department.Name AS Group.employeeName AS Supervisor
FROM Department
INNER JOIN Employee
ON Manager = ID;
✔✔What does the INNER command do? - ✔✔Combines rows from two or more tables
based on related columns between them.
Ex:
SELECT Department.Name AS Group.employeeName AS Supervisor
FROM Department
INNER JOIN Employee
ON Manager = ID;
✔✔What does the INTERSECT command do? - ✔✔Combines two select statements
and returns only the dataset that is common in both the statements.
Ex:
SELECT supplier_ID
FROM suppliers
INTERSET SELECT supplier_ID
