Databases Reference
In-Depth Information
ASSESS YOUR UNDERSTANDING
Go to
www.wiley.com/college/gillenson
to evaluate your knowledge of the SQL
language.
Measure your learning by comparing pre-test and post-test results.
Summary Questions
1.
The ANSI SQL standard defines other commands in addition to DDL and
DML command statements. True or False?
2.
What is the advantage of a command-line based interface for interactive
SQL?
(a)
A command-line interface is easier to use than a graphic-based inter-
face.
(b)
A command-line interface lets you run commands from an operating
system batch.
(c)
A command-line interface does NOT require you to provide connec-
tion information.
(d)
A command-line interface is more forgiving of user error than other
interfaces.
3.
Embedded SQL is supported by.NET Framework development language
only. True or False?
4.
Which of the following statements accurately describes running SQL
commands?
(a)
You must specify the database context when running any SQL com-
mand.
(b)
All SQL commands require you to specify a WHERE clause.
(c)
Unless otherwise specified, commands run in the security context of
the user establishing the database connection.
5.
SELECT commands are considered to be declarative in nature. True or
False?
6.
You must always specify the FROM clause when executing the SELECT
command. True or False?
7.
What is the purpose of the SELECT command WHERE clause?
(a)
to provide search conditions to filter the result set
(b)
to identify the source database
(c)
to identify the source tables or views
(d)
to specify the destination for reporting the command result
