Isds 402 Appendix E

Front 1

Which type of join, although not included in standard SQL, was created to allow
unmatched rows to appear in the result of a join operation?

Back 1

a. ODD JOIN
b. OUTER JOIN
c. INNER JOIN
d. OPEN JOIN
e. COMBINE JOIN

Front 2

SQL statements can be run individually or as part of a related group of SQL statements
known as a(n):

Back 2

a. Scriptset.
b. Result.
c. Script.
d. Resultset.
e. Commandset.

Front 3

SQL views are used:

Back 3

a. to hide columns or rows.
b. All of these
c. to hide complicated SQL syntax.
d. to layer built-in functions.
e. to display the results of computations.

Front 4

SQL statements used to construct views cannot contain:

Back 4

a. the FROM clause.
b. the WHERE clause.
c. the SELECT clause.
d. the LIKE keyword.
e. the ORDER BY clause.

Front 5

Database objects are displayed in the Object Explorer window in the SQL Server
Management Studio.

Back 5

True
False

Front 6

The Microsoft SQL Server 2008 Management Studio is included with Microsoft SQL
Server 2008 R2 Express Advanced.

Back 6

True
False

Front 7

SQL query results are displayed in a tabbed Resultset window.

Back 7

True
False

Front 8

The SQL statement used to delete a view from a database is:

Back 8

a. DELETE VIEW ViewName.
b. ALTER EXISTING VIEW ViewName AS.
c. DROP EXISTING VIEW ViewName.
d. ALTER VIEW ViewName AS.
e. DROP VIEW ViewName.

Front 9

To start working with SQL Server 2008 R2 Express use the command Start | All
Programs | Microsoft SQL Server 2008 R2 | SQL Server management Studio Express

Back 9

True
False

Front 10

Database objects are displayed in the _________ in the SQL Server Management Studio.

Back 10

Object Explorer

Front 11

A new SQL Server database is created using the New Database dialog box.

Back 11

True
False

Front 12

SQL statements can be run individually or as part of a related group of SQL statements
known as a script.

Back 12

True
False

Front 13

The SQL statement used to modify a view is:

Back 13

a. DROP EXISTING VIEW ViewName.
b. DROP VIEW ViewName.
c. ALTER VIEW ViewName AS.
d. ALTER EXISTING VIEW ViewName AS.
e. MODIFY VIEW ViewName AS.

Front 14

SQL views are constructed from:

Back 14

a. SELECT statements.
b. CREATE statements.
c. INSERT statements.
d. VIEW statements.
e. UPDATE statements.

Front 15

(Number 15)
Based on the tables below, which of the following SQL commands would create an SQL
view named CustomerSalesRep that could be used to display CustNo, CustName,
RepName?
GENERAL SALES DATABASE:

Back 15

a. CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;
b. SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER;
c. CREATE VIEW CustomerSalesRep AS
SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP,SalesRepNo = CUSTOMER,SalesRepNo;
d. SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE SALEREP,SalesRepNo = CUSTOMER,SalesRepNo;
e. SELECT CustNo, CustName, RepName
FROM SALESREP, CUSTOMER
WHERE CustNo=*;

Front 16

To run an SQL script, click the Execute button on the Query Toolbar.

Back 16

True
False

Front 17

An important reason for using SQL Server 2008 R2 Express is that it has full SQL
capabilities.

Back 17

True
False

Front 18

Users log into SQL Server 2008 R2 Express using the Connect to Server dialog box.

Back 18

True
False

Front 19

DBMS objects are displayed:

Back 19

a. in the Navigation Pane.
b. in the command tab.
c. in the tabbed document window.
d. in the tabbed database window.
e. in the Object Browser.

Front 20

A new SQL Server database is created using the ____________ dialog box.

Back 20

New Database

Front 21

When an SQL SELECT statement is used to retrieve a view instance, the maximum
number of columns that can be specified in the SELECT is the same as the number of
columns:

Back 21

a. in the VIEW specification.
b. in the HAVING clause.
c. in the ORDER BY clause.
d. that have aliases.
e. in the table underlying the view.

Front 22

SQL view instances are retrieved using the:

Back 22

a. SQL UPDATE statement.
b. SQL CREATE statement.
c. SQL SELECT statement.
d. SQL DELETE statement.
e. SQL INSERT statement.

Front 23

SQL query results are displayed in a tabbed ________ window.

Back 23

results

Front 24

Although it cannot be used in creating a SQL VIEW, the SQL SELECT statements
retrieving view instances can include:

Back 24

a. SQL keyword NULL.
b. SQL keyword BETWEEN.
c. SQL keyword NOT NULL.
d. SQL keyword ORDER BY.
e. SQL keyword LIKE.

Front 25

To create a new SQL query, click the New Query button

Back 25

True
False