MODERN DATABASE
MANAGEMENT 13TH EDITION TEST
BANK 2026 FINAL PAPER PRACTICE
QUESTIONS ANSWERS ACCURATE
A+
◉ The benefits of a standardized relational language include:
Answer: all of the above.
◉ The ________ is the structure that contains descriptions of objects
such as tables and views created by users.
Answer: schema
◉ ________ is a set of commands used to control a database, which
includes security.
Answer: DCL
◉ ________ is a set of commands used to update and query a database.
Answer: DML
◉ DDL is typically used during which phases of the development
process?
Answer: Physical design
, ◉ The command for creating a database is:
Answer: create schema.
◉ The SQL command ________ defines a logical table from one or
more tables or views.
Answer: create view
◉ Any create command may be reversed by using a ________
command.
Answer: drop
◉ The first in a series of steps to follow when creating a table is to:
Answer: identify each attribute and its characteristics.
◉ The SQL command ________ adds one or more new columns to a
table.
Answer: alter table
◉ Which of the following is a technique for optimizing the internal
performance of the relational data model?
Answer: Clustering data
◉ Indexes are created in most RDBMSs to:
Answer: provide rapid random and sequential access to base-table data.
MANAGEMENT 13TH EDITION TEST
BANK 2026 FINAL PAPER PRACTICE
QUESTIONS ANSWERS ACCURATE
A+
◉ The benefits of a standardized relational language include:
Answer: all of the above.
◉ The ________ is the structure that contains descriptions of objects
such as tables and views created by users.
Answer: schema
◉ ________ is a set of commands used to control a database, which
includes security.
Answer: DCL
◉ ________ is a set of commands used to update and query a database.
Answer: DML
◉ DDL is typically used during which phases of the development
process?
Answer: Physical design
, ◉ The command for creating a database is:
Answer: create schema.
◉ The SQL command ________ defines a logical table from one or
more tables or views.
Answer: create view
◉ Any create command may be reversed by using a ________
command.
Answer: drop
◉ The first in a series of steps to follow when creating a table is to:
Answer: identify each attribute and its characteristics.
◉ The SQL command ________ adds one or more new columns to a
table.
Answer: alter table
◉ Which of the following is a technique for optimizing the internal
performance of the relational data model?
Answer: Clustering data
◉ Indexes are created in most RDBMSs to:
Answer: provide rapid random and sequential access to base-table data.
