Database Management Final Exam Study
2026
In a doubly nested set of NOT EXISTS SELECT statements, ________.
if a row does not not match any row, then it matches every row
if a row matches any row, then it matches every row
if a row matches any row, then it does not match every row
if a row does not match any row, then it does not match every row - answers-if a row does not
not match any row, then it matches every row
A dependency graph should include all of the following except ________.
triggers
DEFAULT values
views
tables - answers-DEFAULT values
1
,The SQL function COUNT ________.
counts the number of columns in a table
counts the number of updates to a database
counts the number of tables in a database
counts the number of rows in a table - answers-counts the number of rows in a table
An online drugstore such as Drugstore.com is an example of a(n) ________.
single-user database application
enterprise resource planning system
e-commerce database application
multiuser database application - answers-e-commerce database application
When dropping a foreign key column from a table, which of the following steps is (are) included
in the process? (The order of the steps listed below is not relevant, only the steps themselves.)
2
,Drop the foreign key constraint from the table
Drop the foreign key column from the table
Drop the primary key in the other table referenced by the referential integrity constraint
Both Drop the foreign key constraint from the table and Drop the foreign key column from the
table are correct - answers-Both Drop the foreign key constraint from the table and Drop the
foreign key column from the table are correct
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and
are asked to draw the relationship between them. If a given customer can place only one order
and a given order can be placed by at most one customer, which of the following should be
indicated in the relationship symbol between the two entities?
N:M
1:1
1:N
N:1 - answers-1:1
Which of the following database systems is not enterprise-class?
3
, Microsoft SQL Server
IBM DB2
Microsoft Access
Oracle Database - answers-Microsoft Access
A classic example of unneeded normalization is when we are dealing with ________.
ZIP codes
sales orders and line items
multivalued dependencies
association patterns - answers-ZIP codes
In an SQL query, which built-in function is used to obtain the largest value of numeric columns?
COUNT
MAX
4
2026
In a doubly nested set of NOT EXISTS SELECT statements, ________.
if a row does not not match any row, then it matches every row
if a row matches any row, then it matches every row
if a row matches any row, then it does not match every row
if a row does not match any row, then it does not match every row - answers-if a row does not
not match any row, then it matches every row
A dependency graph should include all of the following except ________.
triggers
DEFAULT values
views
tables - answers-DEFAULT values
1
,The SQL function COUNT ________.
counts the number of columns in a table
counts the number of updates to a database
counts the number of tables in a database
counts the number of rows in a table - answers-counts the number of rows in a table
An online drugstore such as Drugstore.com is an example of a(n) ________.
single-user database application
enterprise resource planning system
e-commerce database application
multiuser database application - answers-e-commerce database application
When dropping a foreign key column from a table, which of the following steps is (are) included
in the process? (The order of the steps listed below is not relevant, only the steps themselves.)
2
,Drop the foreign key constraint from the table
Drop the foreign key column from the table
Drop the primary key in the other table referenced by the referential integrity constraint
Both Drop the foreign key constraint from the table and Drop the foreign key column from the
table are correct - answers-Both Drop the foreign key constraint from the table and Drop the
foreign key column from the table are correct
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and
are asked to draw the relationship between them. If a given customer can place only one order
and a given order can be placed by at most one customer, which of the following should be
indicated in the relationship symbol between the two entities?
N:M
1:1
1:N
N:1 - answers-1:1
Which of the following database systems is not enterprise-class?
3
, Microsoft SQL Server
IBM DB2
Microsoft Access
Oracle Database - answers-Microsoft Access
A classic example of unneeded normalization is when we are dealing with ________.
ZIP codes
sales orders and line items
multivalued dependencies
association patterns - answers-ZIP codes
In an SQL query, which built-in function is used to obtain the largest value of numeric columns?
COUNT
MAX
4
