Question 1

Placing SQL SELECT commands among the lines of a higher-level language program if referred to as ____.

Accepted Answer

A)  online mode 
B)  query mode 
C)  programming 
D)  embedded 
E)  retrieval mode 
A)  online mode 
B)  query mode 
C)  programming 
D)  embedded 
E)  retrieval mode

Question 2

The SQL SELECT HAVING clause limits the output of a GROUP BY operation based on ____.

Accepted Answer

A)  individual attribute values in the groups 
B)  calculated values of the built-in functions 
C)  the arrangement of rows specified by the ORDER BY clause 
D)  the query's output conforming to the range specified by the BETWEEN operator 
E)  the query's output conforming to the values specified by the IN operator 
A)  individual attribute values in the groups 
B)  calculated values of the built-in functions 
C)  the arrangement of rows specified by the ORDER BY clause 
D)  the query's output conforming to the range specified by the BETWEEN operator 
E)  the query's output conforming to the values specified by the IN operator

Question 3

The SQL SELECT built-in function that adds the values of a specified set of attributes is ____.

Accepted Answer

A)  COUNT 
B)  MIN 
C)  MAX 
D)  SUM 
E)  AVG 
A)  COUNT 
B)  MIN 
C)  MAX 
D)  SUM 
E)  AVG

Question 4

The purpose of the SQL SELECT GROUP BY clause is ____.

Accepted Answer

A)  to present rows of a table with common attribute values together as groups in the query output 
B)  to present columns of a table with common attribute values together as groups in the query output 
C)  to group together rows of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group 
D)  to group together columns of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group 
E)  None of the above. 
A)  to present rows of a table with common attribute values together as groups in the query output 
B)  to present columns of a table with common attribute values together as groups in the query output 
C)  to group together rows of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group 
D)  to group together columns of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group 
E)  None of the above.

Question 5

The SQL SELECT command is used to update, insert, and delete rows in relational tables.

Accepted Answer

A) True 
 B)False

Question 6

A GROUP BY clause in an SQL SELECT command groups together columns based on common attribute values.

Accepted Answer

A) True 
 B)False

Question 7

The SQL SELECT command is capable of executing relational Select, Project, and Join operations, singly or in combination.

Accepted Answer

A) True 
 B)False

Question 8

To retrieve an entire table, an SQL SELECT statement must specify the rows in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 9

The SQL SELECT LIKE operator ____.

Accepted Answer

A)  involves looking for numeric values close to a specified numeric value 
B)  involves numeric values in between two specified numeric values 
C)  involves the use of wildcards 
D)  involves limiting duplicate values in the output of an SQL SELECT command 
E)  None of the above. 
A)  involves looking for numeric values close to a specified numeric value 
B)  involves numeric values in between two specified numeric values 
C)  involves the use of wildcards 
D)  involves limiting duplicate values in the output of an SQL SELECT command 
E)  None of the above.

Question 10

Consider the following relational database for the Central Zoo. Central Zoo wants to maintain information about its animals, the enclosures in which they live, and its zookeepers and the services they perform for the animals. In addition, Central Zoo has a program by which people can be sponsor of animals. Central Zoo wants to track its sponsors, their dependents, and associated data.
Each animal has a unique animal number and each enclosure has a unique enclosure number. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. A zookeeper has a unique employee number. Every animal has been cared for by at least one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a specific, significant service for an animal the service type, date, and time are recorded. A zookeeper may perform a particular service on a particular animal more than once on a given day.
A sponsor, who has a unique sponsor number and a unique social security number, sponsors at least one and possibly several animals. An animal may have several sponsors or none. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. In addition, Central Zoo wants to keep track of each sponsor's dependents. A sponsor may have several dependents or none. A dependent is associated with exactly one sponsor.
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { ENCLNUM } & \text { TYPE } & \text { LOCATION } & \text { SIZE } & \text { DATEBULT } \
\hline
\end{array}$$ ENCLOSURE Relation
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { ANIMALNUM } & \text { SPECES } & \text { ANIMALNAME } & \text { GENDER } & \text { COUNTRY } \
\hline
\end{array}$$ $$\begin{array} { | l | l | } 
\hline \text { WEIGHT}&\text { ENCLNUM } \
\hline
\end{array}$$ ANIMAL Relation
 $$\begin{array} { | l | l | l | l | } 
\hline \text { EMPNUM } & \text { EMPNAME } & \text { TITLE } & \text { YERHIRED } \
\hline
\end{array}$$ ZOOKEEPER Relation
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { ANIMALNUM } & \text { EMPNUM } & \text { SERVICETYPE } & \text { DATE } & \text { TIME }\
\hline
\end{array}$$ CARESFOR Relation
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { SPONSORNUM } & \text { SOCSECNUM } & \text { SPONSORNAME } & \text { ADDRESS } & \text { PHONE }\
\hline
\end{array}$$ SPONSOR Relation
 $$\begin{array} { | l | l | l | l | } 
\hline \text { ANIMALNUM } & \text { SPONSORNUM } & \text { ANNUALCONT } & \text { RENEWDATE } \
\hline
\end{array}$$ CONTRIBUTION Relation
 $$\begin{array} { | l | l | l | l| } 
\hline \text { SPONSORNUM } & \text { DEPENNAME } & \text { RELATIONSHIP } & \text { BIRTHDATE }\
\hline
\end{array}$$ DEPENDENT Relation
Write SQL SELECT commands to answer the following queries. 
a. Find the size of enclosure number 2582.
b. List the names and numbers of the female tigers who live in enclosure number 4627.
c. List the animal number, species, gender, and weight of all of the lions, tigers, and leopards that weigh between 700 and 900 pounds, from heaviest to lightest.
d. Find the average weight of all of the male tigers.
e. Find the average weight of the males of each species.
f. List the names, addresses, and phone numbers of all of the sponsors of tigers that were born in India.
g. How many monkeys live in cages that are less than 400 square feet in size?
h. Find the average weight of each species of animal that that live in cages that are less than 400 square feet in size. Only include those species for which the average weight is at least 200 pounds.
i. Find the name and number of the heaviest tiger.
j. Find the name, number, and species of the animals from China that are at least as heavy as the heaviest female tiger that was born in India.

Accepted Answer

a. SELECT SIZE
FROM ENCLOSURE
WHERE ENCL

Question 11

All of the following features of a relational query or of the relational database that it accesses are considered by the relational query optimizer, except ____.

Accepted Answer

A)  whether a search argument in the query is a unique attribute in the database 
B)  whether a search argument in the query involves an indexed attribute 
C)  the number of rows of output the query produces 
D)  the number of rows of the database tables involved 
E)  whether a join attribute in the query involves an indexed attribute 
A)  whether a search argument in the query is a unique attribute in the database 
B)  whether a search argument in the query involves an indexed attribute 
C)  the number of rows of output the query produces 
D)  the number of rows of the database tables involved 
E)  whether a join attribute in the query involves an indexed attribute

Question 12

The BETWEEN operator in the SQL SELECT command WHERE clause requires that a character string must be between two specified character strings.

Accepted Answer

A) True 
 B)False

Question 13

The use of a subquery in an SQL SELECT statement is always optional.

Accepted Answer

A) True 
 B)False

Question 14

The SQL CREATE TABLE command is capable of doing all of the following, except ____.

Accepted Answer

A)  building indexes 
B)  specifying which attributes are unique 
C)  specifying which attributes serve as the primary key 
D)  specifying referential integrity constraints 
E)  specifying which attributes serve as foreign keys 
A)  building indexes 
B)  specifying which attributes are unique 
C)  specifying which attributes serve as the primary key 
D)  specifying referential integrity constraints 
E)  specifying which attributes serve as foreign keys

Question 15

A relational query optimizer ____.

Accepted Answer

A)  is a form of a relational catalog 
B)  is a separate piece of software that can be added to the relational DBMS environment as an option 
C)  can be invoked at the option of the user issuing the query 
D)  is only used with queries involving joins 
E)  None of the above. 
A)  is a form of a relational catalog 
B)  is a separate piece of software that can be added to the relational DBMS environment as an option 
C)  can be invoked at the option of the user issuing the query 
D)  is only used with queries involving joins 
E)  None of the above.

Question 16

Structured Query Language (SQL) ____.

Accepted Answer

A)  is capable of retrieving data from a relational database 
B)  is capable of defining the tables, attributes, and indexes of a relational database 
C)  is a relational DBMS 
D)  a and b above 
E)  a, b, and c above 
A)  is capable of retrieving data from a relational database 
B)  is capable of defining the tables, attributes, and indexes of a relational database 
C)  is a relational DBMS 
D)  a and b above 
E)  a, b, and c above

Question 17

A basic SQL SELECT command is capable of performing a combination of relational Select and Project operations.

Accepted Answer

A) True 
 B)False

Question 18

The SQL SELECT DISTINCT operator ____.

Accepted Answer

A)  eliminates duplicate rows in the output of an SQL SELECT command 
B)  eliminates duplicate columns in the output of an SQL SELECT command 
C)  eliminates duplicate attribute values within a row of the output of an SQL SELECT command 
D)  eliminates duplicate attribute values within a column of the output of an SQL SELECT command 
E)  None of the above. 
A)  eliminates duplicate rows in the output of an SQL SELECT command 
B)  eliminates duplicate columns in the output of an SQL SELECT command 
C)  eliminates duplicate attribute values within a row of the output of an SQL SELECT command 
D)  eliminates duplicate attribute values within a column of the output of an SQL SELECT command 
E)  None of the above.

Question 19

In an SQL SELECT statement, a subquery can accomplish the same function as a join.

Accepted Answer

A) True 
 B)False

Question 20

A relational query optimizer is a separate piece of software that can be called in by the relational DBMS when it has to respond to an especially complex query.

Accepted Answer

A) True 
 B)False

Placing SQL SELECT commands among the lines of a higher-level language program if referred to as ____.

The SQL SELECT HAVING clause limits the output of a GROUP BY operation based on ____.

The SQL SELECT built-in function that adds the values of a specified set of attributes is ____.

The purpose of the SQL SELECT GROUP BY clause is ____.

The SQL SELECT command is used to update, insert, and delete rows in relational tables.

A GROUP BY clause in an SQL SELECT command groups together columns based on common attribute values.

The SQL SELECT command is capable of executing relational Select, Project, and Join operations, singly or in combination.

To retrieve an entire table, an SQL SELECT statement must specify the rows in the WHERE clause.

The SQL SELECT LIKE operator ____.

All of the following features of a relational query or of the relational database that it accesses are considered by the relational query optimizer, except ____.

The BETWEEN operator in the SQL SELECT command WHERE clause requires that a character string must be between two specified character strings.

The use of a subquery in an SQL SELECT statement is always optional.

The SQL CREATE TABLE command is capable of doing all of the following, except ____.

A relational query optimizer ____.

Structured Query Language (SQL) ____.

A basic SQL SELECT command is capable of performing a combination of relational Select and Project operations.

The SQL SELECT DISTINCT operator ____.

In an SQL SELECT statement, a subquery can accomplish the same function as a join.

A relational query optimizer is a separate piece of software that can be called in by the relational DBMS when it has to respond to an especially complex query.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 4: Relational Data Retrieval: SQL

Placing SQL SELECT commands among the lines of a higher-level language program if referred to as ____.

The SQL SELECT HAVING clause limits the output of a GROUP BY operation based on ____.

The SQL SELECT built-in function that adds the values of a specified set of attributes is ____.

The purpose of the SQL SELECT GROUP BY clause is ____.

The SQL SELECT command is used to update, insert, and delete rows in relational tables.

A GROUP BY clause in an SQL SELECT command groups together columns based on common attribute values.

The SQL SELECT command is capable of executing relational Select, Project, and Join operations, singly or in combination.

To retrieve an entire table, an SQL SELECT statement must specify the rows in the WHERE clause.

The SQL SELECT LIKE operator ____.

All of the following features of a relational query or of the relational database that it accesses are considered by the relational query optimizer, except ____.

The BETWEEN operator in the SQL SELECT command WHERE clause requires that a character string must be between two specified character strings.

The use of a subquery in an SQL SELECT statement is always optional.

The SQL CREATE TABLE command is capable of doing all of the following, except ____.

A relational query optimizer ____.

Structured Query Language (SQL) ____.

A basic SQL SELECT command is capable of performing a combination of relational Select and Project operations.

The SQL SELECT DISTINCT operator ____.

In an SQL SELECT statement, a subquery can accomplish the same function as a join.

A relational query optimizer is a separate piece of software that can be called in by the relational DBMS when it has to respond to an especially complex query.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters