BIS245 FINAL REVIEW (LATEST UPDATE
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
When data is produced and stored as numeric, textual, or visual information, it varies
in _____. - correct answer format
When using a SQL statement to create a table, which data type is used to store a
fractional value? - correct answer DECIMAL
What does a user that interacts with a database use to read and write data? - correct
answer Query Language
Which principle defines data independence? - correct answer Physical design never
affects query results.
If a database system is processing three queries as part of a transaction and the third
query fails, what happens to the transaction? - correct answer The successful query
results are reversed, and the transaction is canceled.
When using the MySQL Workbench GUI, which icon will execute an SQL statement? -
correct answer Lightning bolt
How does a database system protect data when concurrent transactions occur? -
correct answer Preventing multiple transactions with the same data at the same time.
, BIS245 FINAL REVIEW (LATEST UPDATE
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
In terms of database architecture, which component translates the query processor
instructions into low-level file-system commands and is responsible for indexing the
data? - correct answer Storage manager
A database designer installs MySQL Community Edition to create a database. Which
account does the designer use to gain full control of MySQL? - correct answer root
A foreign key in which all columns are NULL is known as a _____ foreign key? - correct
answer fully NULL
A _____ is a collection of values with no inherent order. - correct answer set
In a relational database model, an attribute refers to which concept? - correct answer
A uniquely named tuple position
When only one value exists in each cell, a table is known to be _____. - correct answer
normalized
A _____ is a collection of values that are of the same type. - correct answer column
, BIS245 FINAL REVIEW (LATEST UPDATE
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
A database administrator creates a new relational database, and a primary key is
assigned within a table to assist with governing data. What does the administrator
accomplish with this structural rule? - correct answer Unique identification of
individual rows in the table
What data type stores binary values? - correct answer BLOB
Refer to the Teacher and Class tables. To maintain referential integrity, which foreign
key action rejects the deletion of the row containing Rosa Lopez? - correct answer a.)
RESTRICT
b.) CASCADE
c.) SET NULL
d.) SET DEFAULT
RESTRICT
A relational database uses _____ to structure all data. - correct answer tables
A value that is used in a computation is known as a/an _____. - correct answer
operand
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
When data is produced and stored as numeric, textual, or visual information, it varies
in _____. - correct answer format
When using a SQL statement to create a table, which data type is used to store a
fractional value? - correct answer DECIMAL
What does a user that interacts with a database use to read and write data? - correct
answer Query Language
Which principle defines data independence? - correct answer Physical design never
affects query results.
If a database system is processing three queries as part of a transaction and the third
query fails, what happens to the transaction? - correct answer The successful query
results are reversed, and the transaction is canceled.
When using the MySQL Workbench GUI, which icon will execute an SQL statement? -
correct answer Lightning bolt
How does a database system protect data when concurrent transactions occur? -
correct answer Preventing multiple transactions with the same data at the same time.
, BIS245 FINAL REVIEW (LATEST UPDATE
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
In terms of database architecture, which component translates the query processor
instructions into low-level file-system commands and is responsible for indexing the
data? - correct answer Storage manager
A database designer installs MySQL Community Edition to create a database. Which
account does the designer use to gain full control of MySQL? - correct answer root
A foreign key in which all columns are NULL is known as a _____ foreign key? - correct
answer fully NULL
A _____ is a collection of values with no inherent order. - correct answer set
In a relational database model, an attribute refers to which concept? - correct answer
A uniquely named tuple position
When only one value exists in each cell, a table is known to be _____. - correct answer
normalized
A _____ is a collection of values that are of the same type. - correct answer column
, BIS245 FINAL REVIEW (LATEST UPDATE
2026-2027) REAL QUESTIONS AND
VERIFIED ANSWERS 100% CORRECT
ALREADY {GRADE A} - DeVry University
A database administrator creates a new relational database, and a primary key is
assigned within a table to assist with governing data. What does the administrator
accomplish with this structural rule? - correct answer Unique identification of
individual rows in the table
What data type stores binary values? - correct answer BLOB
Refer to the Teacher and Class tables. To maintain referential integrity, which foreign
key action rejects the deletion of the row containing Rosa Lopez? - correct answer a.)
RESTRICT
b.) CASCADE
c.) SET NULL
d.) SET DEFAULT
RESTRICT
A relational database uses _____ to structure all data. - correct answer tables
A value that is used in a computation is known as a/an _____. - correct answer
operand
