DATABASE DESIGN FINAL 2025
UPDATED QUESTIONS WITH
VERIFIED ANSWERS ALREADY
GRADED
which statement is NOT an advantage of using a view table? - CORRECT ANSWER>>>>the
creation of a new base table is always up to date
what does the following statement return? SELECT SUBSTRING('Excellent', 3, 4); -
CORRECT ANSWER>>>>'cell'
the following tables describes parts and companies that supply parts. the following query selects
all possible combinations of part names and supplier names. what ________ completes the
query? - CORRECT ANSWER>>>>CROSS JOIN Supplier
A/an _________ is a subquery that contains a reference to a table column that also appears in the
outer query - CORRECT ANSWER>>>>correlated subquery
SELECT DISTINCT Size
FROM Product; - CORRECT ANSWER>>>>ignores duplicates
An Inventory view table is defined with a WHERE clause that specifies ShelfNumber = 25. An
INSERT adds a new item to ShelfNumber 20. What happens when the WITH CHECK OPTION
is not specified in the CREATE VIEW statement? - CORRECT ANSWER>>>>the item appears
in the base table but not in the view table
a database administrator wants to correlate pairs of rows from the same table. which type of join
should the database administrator use? - CORRECT ANSWER>>>>Self join
how many rows are in the table defined by the following relational algebra expression? -
CORRECT ANSWER>>>>2
which relational algebra operation is denoted by the greek letter p? - CORRECT
ANSWER>>>>rename
a meaningless primary key contains no ________ - CORRECT ANSWER>>>>descriptive
information
when implementing a __________ relationship, a new table contains two foreign keys, refering
to the primary keys of the related tables - CORRECT ANSWER>>>>many-many
,The entity Book includes Paperback, Hardcover, and Digital books. The attribute ChapterCount
applies to both PaperBack and HardCover but not Digital. Digital has a TextToSpeech attribute.
Which entity type is Digital? - CORRECT ANSWER>>>>subtype
in a one-one relationship, the ______ key is often placed in the table with fewer rows, this
minimizes the number of _______ values - CORRECT ANSWER>>>>foreign, NULL
which table type do plural attributes become? - CORRECT ANSWER>>>>dependent
which of the following is a set of things in an entity-relationship modeling? - CORRECT
ANSWER>>>>entity
a database administrator normalizes a table to Boyce-Codd normal form. this involves
identifying dependencies on non-unique _________ - CORRECT ANSWER>>>>columns
a database contains several relationships. which is a valid relationship name? - CORRECT
ANSWER>>>>Toys-Contains-Dolls
Each value of a _____ attribute describes at most one entity instance. - CORRECT
ANSWER>>>>unique
a single level index is a file that contains column values and pointers to ______ containing the
column ______ - CORRECT ANSWER>>>>rows, value
in a multitable, a ______ column is available in all interleaved tables - CORRECT
ANSWER>>>>cluster key
a _______ partition requires a partition expression with positive integer values - CORRECT
ANSWER>>>>Hash
a column contains grades from 0 to 10, but a WHERE clause specifies values from 0 to 100. A
_______ index can be used to modify the column values and process the queries - CORRECT
ANSWER>>>>function
how are books read with a single level index scan? - CORRECT ANSWER>>>>a scan reads all
index to find table blocks that contain selected rows. The table blocks are then read
in a logical index, pointers to table blocks are replaced with _______ values - CORRECT
ANSWER>>>>primary key
the sort column in a sorted table determines the ________ row order - CORRECT
ANSWER>>>>physical
When a table is updated and the index block has no free space for a new index entry, what
happens? - CORRECT ANSWER>>>>the block splits
, in MySQL with InnoDB, tables with a primary key have a ______ structure, while those without
a primary key have a _____ structure - CORRECT ANSWER>>>>sorted, heap
Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after
the schedule executes? (look at #1) - CORRECT ANSWER>>>>2
a recovery system should manage which 3 failure scenarios? - CORRECT
ANSWER>>>>transaction failure, system failure, and storage media failure
the username and password for the database in the configuration file of a web application is
incorrect, so the web application cannot connect to the database. which failure scenario best
describes this example? - CORRECT ANSWER>>>>transaction failure
In the recovery log below, line 6 is a/an _____. - CORRECT ANSWER>>>>compensation
record
Refer to the sequence below. What is the isolation level of transaction E? - CORRECT
ANSWER>>>>repeatable read
In an online bank application that transfers funds from a checking account to a savings account,
if a debit is made successfully from the checking account, the _____ property ensures that the
corresponding credit is made to the savings account. - CORRECT ANSWER>>>>atomicity
a database administrator is updating one of the tables in the database. Which of the following
techniques can prevent other database administrators from doing concurrent transactions to the
same table? - CORRECT ANSWER>>>>locking
which deadlock management technique automatically rolls back a transaction when a lock is not
released in a fixed period of time? - CORRECT ANSWER>>>>timeout
a document that sequentially writes all the database operations is known as a/an ___________ -
CORRECT ANSWER>>>>recovery log
Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after
the schedule executes? (look at #10) - CORRECT ANSWER>>>>8
a retailer using a cloud-based transaction database is experiencing sales fluctuations through the
year. the ability for cloud resources to adapt to such change in utilization is called __________ -
CORRECT ANSWER>>>>elasticity
a hierarchy in a dimension table contains a series of ________ where each has a _______
relationship to the next - CORRECT ANSWER>>>>columns, one-many
which of the following is NOT a replica type? - CORRECT ANSWER>>>>query
UPDATED QUESTIONS WITH
VERIFIED ANSWERS ALREADY
GRADED
which statement is NOT an advantage of using a view table? - CORRECT ANSWER>>>>the
creation of a new base table is always up to date
what does the following statement return? SELECT SUBSTRING('Excellent', 3, 4); -
CORRECT ANSWER>>>>'cell'
the following tables describes parts and companies that supply parts. the following query selects
all possible combinations of part names and supplier names. what ________ completes the
query? - CORRECT ANSWER>>>>CROSS JOIN Supplier
A/an _________ is a subquery that contains a reference to a table column that also appears in the
outer query - CORRECT ANSWER>>>>correlated subquery
SELECT DISTINCT Size
FROM Product; - CORRECT ANSWER>>>>ignores duplicates
An Inventory view table is defined with a WHERE clause that specifies ShelfNumber = 25. An
INSERT adds a new item to ShelfNumber 20. What happens when the WITH CHECK OPTION
is not specified in the CREATE VIEW statement? - CORRECT ANSWER>>>>the item appears
in the base table but not in the view table
a database administrator wants to correlate pairs of rows from the same table. which type of join
should the database administrator use? - CORRECT ANSWER>>>>Self join
how many rows are in the table defined by the following relational algebra expression? -
CORRECT ANSWER>>>>2
which relational algebra operation is denoted by the greek letter p? - CORRECT
ANSWER>>>>rename
a meaningless primary key contains no ________ - CORRECT ANSWER>>>>descriptive
information
when implementing a __________ relationship, a new table contains two foreign keys, refering
to the primary keys of the related tables - CORRECT ANSWER>>>>many-many
,The entity Book includes Paperback, Hardcover, and Digital books. The attribute ChapterCount
applies to both PaperBack and HardCover but not Digital. Digital has a TextToSpeech attribute.
Which entity type is Digital? - CORRECT ANSWER>>>>subtype
in a one-one relationship, the ______ key is often placed in the table with fewer rows, this
minimizes the number of _______ values - CORRECT ANSWER>>>>foreign, NULL
which table type do plural attributes become? - CORRECT ANSWER>>>>dependent
which of the following is a set of things in an entity-relationship modeling? - CORRECT
ANSWER>>>>entity
a database administrator normalizes a table to Boyce-Codd normal form. this involves
identifying dependencies on non-unique _________ - CORRECT ANSWER>>>>columns
a database contains several relationships. which is a valid relationship name? - CORRECT
ANSWER>>>>Toys-Contains-Dolls
Each value of a _____ attribute describes at most one entity instance. - CORRECT
ANSWER>>>>unique
a single level index is a file that contains column values and pointers to ______ containing the
column ______ - CORRECT ANSWER>>>>rows, value
in a multitable, a ______ column is available in all interleaved tables - CORRECT
ANSWER>>>>cluster key
a _______ partition requires a partition expression with positive integer values - CORRECT
ANSWER>>>>Hash
a column contains grades from 0 to 10, but a WHERE clause specifies values from 0 to 100. A
_______ index can be used to modify the column values and process the queries - CORRECT
ANSWER>>>>function
how are books read with a single level index scan? - CORRECT ANSWER>>>>a scan reads all
index to find table blocks that contain selected rows. The table blocks are then read
in a logical index, pointers to table blocks are replaced with _______ values - CORRECT
ANSWER>>>>primary key
the sort column in a sorted table determines the ________ row order - CORRECT
ANSWER>>>>physical
When a table is updated and the index block has no free space for a new index entry, what
happens? - CORRECT ANSWER>>>>the block splits
, in MySQL with InnoDB, tables with a primary key have a ______ structure, while those without
a primary key have a _____ structure - CORRECT ANSWER>>>>sorted, heap
Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after
the schedule executes? (look at #1) - CORRECT ANSWER>>>>2
a recovery system should manage which 3 failure scenarios? - CORRECT
ANSWER>>>>transaction failure, system failure, and storage media failure
the username and password for the database in the configuration file of a web application is
incorrect, so the web application cannot connect to the database. which failure scenario best
describes this example? - CORRECT ANSWER>>>>transaction failure
In the recovery log below, line 6 is a/an _____. - CORRECT ANSWER>>>>compensation
record
Refer to the sequence below. What is the isolation level of transaction E? - CORRECT
ANSWER>>>>repeatable read
In an online bank application that transfers funds from a checking account to a savings account,
if a debit is made successfully from the checking account, the _____ property ensures that the
corresponding credit is made to the savings account. - CORRECT ANSWER>>>>atomicity
a database administrator is updating one of the tables in the database. Which of the following
techniques can prevent other database administrators from doing concurrent transactions to the
same table? - CORRECT ANSWER>>>>locking
which deadlock management technique automatically rolls back a transaction when a lock is not
released in a fixed period of time? - CORRECT ANSWER>>>>timeout
a document that sequentially writes all the database operations is known as a/an ___________ -
CORRECT ANSWER>>>>recovery log
Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after
the schedule executes? (look at #10) - CORRECT ANSWER>>>>8
a retailer using a cloud-based transaction database is experiencing sales fluctuations through the
year. the ability for cloud resources to adapt to such change in utilization is called __________ -
CORRECT ANSWER>>>>elasticity
a hierarchy in a dimension table contains a series of ________ where each has a _______
relationship to the next - CORRECT ANSWER>>>>columns, one-many
which of the following is NOT a replica type? - CORRECT ANSWER>>>>query
