MODERN DATABASE MANAGEMENT
EXAMPREP REVIEW SHEET WITH TESTED
QUESTIONS AND COMPLETE SOLUTIONS
●● 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:
EXAMPREP REVIEW SHEET WITH TESTED
QUESTIONS AND COMPLETE SOLUTIONS
●● 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:
