IS 410 Exam 2 Questions with Correct Answers Latest Update 2025/2026
________ is a component of the relational data model included to specify business rules to
maintain the integrity of data when they are manipulated. - Answers Data integrity
A rule that states that each foreign key value must match a primary key value in the other
relation is called the: - Answers referential integrity constraint
A primary key is an attribute that uniquely identifies each row in a relation. - Answers True
An attribute in a relation of a database that serves as the primary key of another relation in the
same database is called a: - Answers foreign key
data structure - Answers Tables (relations), rows, columns
Data Manipulation - Answers Powerful SQL operations for retrieving and modifying data
Data Integrity - Answers Mechanisms for implementing business rules that maintain integrity of
manipulated data
Relation - Answers A named two-dimensional table of data.
Simple Key - Answers A single key field
Composite Key - Answers More than one key field
Domain Constraint - Answers Allowable values for an attribute (includes data types and
restrictions on values)
Entity Integrity - Answers No primary key attribute may be null. All primary key fields MUST
contain data values.
Referential Integrity - Answers Rules that maintain consistency between the rows of two related
tables.
Data is represented in the form of: - Answers tables
A referential integrity constraint is a rule that maintains consistency among the rows of two
relations. - Answers True
The CHECK statement allows you to constrain attributes to specific values. - Answers True
Which of the following is not a data integrity restriction? - Answers Inserts of primary records
What does the following SQL statement do?
UPDATE Product_T
SET Unit_Price = 775
, WHERE Product_ID = 7 - Answers Changes the unit price of Product 7 to 775
What does the following SQL statement do?
SELECT * From Customer WHERE Cust_Type = "Best" - Answers Selects all the fields from the
Customer table for each row with a customer labeled "Best"
Referential integrity are constraints that ensures that foreign key values of a table must match
primary key values of a related table in 1:M relationships. - Answers True
What result set will the following query return?
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200; - Answers The Item_No and description for all items
weighing between 101 and 199
When creating a database, you define the database in the ________, you load the database in the
______ and you control the database in the ________ - Answers When creating a database, you
define the database in the [DDL], you load the database in the [DML] and you control the
database in the [DCL].
SQL stands for Structured Query Language - Answers True
What are the steps for developing a relational database in the proper order. - Answers 1.
Understand Business Need for the Database
2. Create an ER Diagram
3. Create an EER Diagram
4. Create a Relational & SQL Schema
5. Create the Database using SQL Programming
What does the following SQL statement do?
DELETE FROM Customer_T
WHERE state = 'HI'; - Answers Deletes all records from Customer_t where the state is equal to HI
What result will the following SQL statement produce?
SELECT Avg(Standard_Price) as average from Product_V; - Answers The average
Standard_Price of all products in Product_V
SELECT - Answers Lists the columns (and expressions) to be returned from the query
________ is a component of the relational data model included to specify business rules to
maintain the integrity of data when they are manipulated. - Answers Data integrity
A rule that states that each foreign key value must match a primary key value in the other
relation is called the: - Answers referential integrity constraint
A primary key is an attribute that uniquely identifies each row in a relation. - Answers True
An attribute in a relation of a database that serves as the primary key of another relation in the
same database is called a: - Answers foreign key
data structure - Answers Tables (relations), rows, columns
Data Manipulation - Answers Powerful SQL operations for retrieving and modifying data
Data Integrity - Answers Mechanisms for implementing business rules that maintain integrity of
manipulated data
Relation - Answers A named two-dimensional table of data.
Simple Key - Answers A single key field
Composite Key - Answers More than one key field
Domain Constraint - Answers Allowable values for an attribute (includes data types and
restrictions on values)
Entity Integrity - Answers No primary key attribute may be null. All primary key fields MUST
contain data values.
Referential Integrity - Answers Rules that maintain consistency between the rows of two related
tables.
Data is represented in the form of: - Answers tables
A referential integrity constraint is a rule that maintains consistency among the rows of two
relations. - Answers True
The CHECK statement allows you to constrain attributes to specific values. - Answers True
Which of the following is not a data integrity restriction? - Answers Inserts of primary records
What does the following SQL statement do?
UPDATE Product_T
SET Unit_Price = 775
, WHERE Product_ID = 7 - Answers Changes the unit price of Product 7 to 775
What does the following SQL statement do?
SELECT * From Customer WHERE Cust_Type = "Best" - Answers Selects all the fields from the
Customer table for each row with a customer labeled "Best"
Referential integrity are constraints that ensures that foreign key values of a table must match
primary key values of a related table in 1:M relationships. - Answers True
What result set will the following query return?
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200; - Answers The Item_No and description for all items
weighing between 101 and 199
When creating a database, you define the database in the ________, you load the database in the
______ and you control the database in the ________ - Answers When creating a database, you
define the database in the [DDL], you load the database in the [DML] and you control the
database in the [DCL].
SQL stands for Structured Query Language - Answers True
What are the steps for developing a relational database in the proper order. - Answers 1.
Understand Business Need for the Database
2. Create an ER Diagram
3. Create an EER Diagram
4. Create a Relational & SQL Schema
5. Create the Database using SQL Programming
What does the following SQL statement do?
DELETE FROM Customer_T
WHERE state = 'HI'; - Answers Deletes all records from Customer_t where the state is equal to HI
What result will the following SQL statement produce?
SELECT Avg(Standard_Price) as average from Product_V; - Answers The average
Standard_Price of all products in Product_V
SELECT - Answers Lists the columns (and expressions) to be returned from the query
