Question 1

A relational algebra operator used to combine rows from two tables is the ______________ operator.

Accepted Answer

The answer of A relational algebra operator used to combine...

Question 2

Figuer:
VOTE $$\begin{array} { | l | l | l | } 
\hline \text { Name } & \text { votel } & \text { vote2 } \
\hline \text { Bill } & 20 & 15 \
\hline \text { Mary } & 10 & 25 \
\hline \text { Jill } & 15 & 0 \
\hline \text { Bob } & 30 & \
\hline
\end{array}$$
-SELECT Vote2,COUNT(*) FROM VOTE
GROUP BY Vote2
In SQL2,the execution of this query produces the following number of rows:

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 3

In outer join queries,non-matched rows in the result table would contain ____________ values in certain columns.

Accepted Answer

The answer of In outer join queries,non-matched rows in the...

Question 4

Figuer:
CUSTOMER $$\begin{array} { | l | l | l | l | l | } 
\hline \text { CID } & \text { CNAME } & \text { AGE } & \text { RESID\_CITY } & \text { BIRTHPLACE } \
\hline 10 & \text { BLACK } & 40 & \text { ERIE } & \text { TAMPA } \
\hline 20 & \text { GREEN } & 25 & \text { CARY } & \text { ERIE } \
\hline 30 & \text { JONES } & 30 & \text { HEMET } & \text { TAMPA } \
\hline 40 & \text { MARTIN } & 35 & \text { HEMET } & \text { TAMPA } \
\hline 50 & \text { SIMON } & 22 & \text { ERIE } & \text { ERIE } \
\hline 60 & \text { VERNON } & 60 & \text { CARY } & \text { CARY } \
\hline
\end{array}$$ In table CUSTOMER, CID is the primary key (Customer ID).
RENTALS $$\begin{array} { | l | l | l | l | l | l | } 
\hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } \
\hline 10 & \text { FORD } & 10 - 0 c t - 1994 & \text { CARY } & \text { CARY } & 1 \
\hline 10 & \text { GM } & 01 - N o v - 1995 & \text { TAMPA } & \text { CARY } & 2 \
\hline 10 & \text { FORD } & 01 - J a n - 1995 & \text { ERIE } & \text { ERIE } & 3 \
\hline 20 & \text { NISSAN } & 07 - J u 1 - 1994 & \text { TAMPA } & \text { TAMPA } & 4 \
\hline 30 & \text { FORD } & 01 - J u l - 1995 & \text { CARY } & \text { ERIE } & 5 \
\hline 30 & \text { GM } & 01 - A u g - 1995 & \text { ERIE } & \text { ERIE } & 6 \
\hline 40 & \text { FORD } & 01 - A u g - 1994 & \text { CARY } & \text { ERIE } & 7 \
\hline 50 & \text { GM } & 01 - S e p - 19 95 & \text { ERIE } & \text { CARY } & 8 \
\hline 70 & \text { TOYOTA } & 02 - S e p - 1995 & \text { RENO } & \text { RENO } & 9 \
\hline
\end{array}$$ In the table RENTALS, RTN provides the rental number (the primary key), CID is the customer's unique id, PICKUP is the city where the car was picked up, and Return is the city where the car was returned.
RENTCOST $$\begin{array} { | l | l | } 
\hline \text { MAKE } & \text { COST } \
\hline \text { FORD } & 30 \
\hline \text { GM } & 40 \
\hline \text { NISSAN } & 30 \
\hline \text { TOYOTA } & 20 \
\hline \text { VOLVO } & 50 \
\hline
\end{array}$$ RENTCOST shows the base cost of renting a given MAKE for one day.
CITYADJ $$\begin{array} { | l | l | } 
\hline \text { CITY } & \text { FACTOR } \
\hline \text { CARY } & 1 \
\hline \text { ERIE } & 1.1 \
\hline \text { RENO } & 0.9 \
\hline \text { TAMPA } & 0.8 \
\hline
\end{array}$$ If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below.
RENTLENGTH $$\begin{array} { | l | l | } 
\hline \text { RTN } & \text { DAYS } \
\hline 1 & 1 \
\hline 2 & 3 \
\hline 3 & 2 \
\hline 4 & 2 \
\hline 5 & 4 \
\hline 6 & 2 \
\hline 7 & 3 \
\hline 8 & 1 \
\hline
\end{array}$$ RENTLENGTH shows the number of days for the rental number (RTN) shown in table RENTALS. In a database used in reality, this table would be merged with the RENTALS table.
-(ACCESS)SELECT CNAME,DATE_OUT,RTN FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
WHERE AGE  1)
The CNAMEs shown by the execution of this query are:

Accepted Answer

A)  JONES, MARTIN 
B)  GREEN, JONES, MARTIN 
C)  BLACK, JONES, MARTIN 
D)  BLACK, GREEN, JONES, MARTIN 
A)  JONES, MARTIN 
B)  GREEN, JONES, MARTIN 
C)  BLACK, JONES, MARTIN 
D)  BLACK, GREEN, JONES, MARTIN

Question 5

Type II nested queries should not be used for a join operation when the result table contains any columns from the inner query.

Accepted Answer

A) True 
 B)False

Question 6

Using a Type I nested query is the standard way to reference related tables in SQL DELETE statements.

Accepted Answer

A) True 
 B)False

Question 7

The following SQL statement could not be executed because what column is included in the SELECT? _____________
SELECT StdSSN,StdLastName,StdMajor,EnrGrade
FROM Student
WHERE Student.StdSSN IN
(SELECT StdSSN FROM Enrollment
WHERE EnrGrade > 3.5)

Accepted Answer

The answer of The following SQL statement could not be...

Question 8

Type I nested queries are useful for some join problems but should not be used for difference problems.

Accepted Answer

A) True 
 B)False

Question 9

An operator that generates a result table that contains the matching rows of both tables plus the non-matching rows of one of the input tables is a(n)_____________________.

Accepted Answer

one-sided

Question 10

In simple conditions,only rows in which the condition evaluates to false are excluded from the result set.

Accepted Answer

A) True 
 B)False

Question 11

Figuer:
VOTE $$\begin{array} { | l | l | l | } 
\hline \text { Name } & \text { votel } & \text { vote2 } \
\hline \text { Bill } & 20 & 15 \
\hline \text { Mary } & 10 & 25 \
\hline \text { Jill } & 15 & 0 \
\hline \text { Bob } & 30 & \
\hline
\end{array}$$
-SELECT * FROM VOTE WHERE Vote1>10 OR VOTE2 >10
The execution of this query produces the following number of rows:

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 12

The following SQL statement is an example of a Type II nested query:
SELECT StdSSN,StdLastName,StdMajor
FROM Student
WHERE Student.StdSSN IN
(SELECT StdSSN FROM Enrollment
WHERE EnrGrade > 3.5)

Accepted Answer

A) True 
 B)False

Question 13

To be union compatible each corresponding column from both temporary tables must have compatible data types.

Accepted Answer

A) True 
 B)False

Question 14

Using the join operator style,the result set of a one-sided outer join depends on the direction and position of the table names in the query.

Accepted Answer

A) True 
 B)False

A relational algebra operator used to combine rows from two tables is the ______________ operator.

Figuer: VOTE Name votel vote2 Bill 20 15 Mary 10 25 Jill 15 0 Bob 30 -SELECT Vote2,COUNT(*) FROM VOTE GROUP BY Vote2 In SQL2,the execution of this query produces the following number of rows:

In outer join queries,non-matched rows in the result table would contain ____________ values in certain columns.

Type II nested queries should not be used for a join operation when the result table contains any columns from the inner query.

Using a Type I nested query is the standard way to reference related tables in SQL DELETE statements.

The following SQL statement could not be executed because what column is included in the SELECT? _____________ SELECT StdSSN,StdLastName,StdMajor,EnrGrade FROM Student WHERE Student.StdSSN IN (SELECT StdSSN FROM Enrollment WHERE EnrGrade > 3.5)

Type I nested queries are useful for some join problems but should not be used for difference problems.

An operator that generates a result table that contains the matching rows of both tables plus the non-matching rows of one of the input tables is a(n)_____________________.

In simple conditions,only rows in which the condition evaluates to false are excluded from the result set.

Figuer: VOTE Name votel vote2 Bill 20 15 Mary 10 25 Jill 15 0 Bob 30 -SELECT * FROM VOTE WHERE Vote1>10 OR VOTE2 >10 The execution of this query produces the following number of rows:

The following SQL statement is an example of a Type II nested query: SELECT StdSSN,StdLastName,StdMajor FROM Student WHERE Student.StdSSN IN (SELECT StdSSN FROM Enrollment WHERE EnrGrade > 3.5)

To be union compatible each corresponding column from both temporary tables must have compatible data types.

Using the join operator style,the result set of a one-sided outer join depends on the direction and position of the table names in the query.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 9: Advanced Query Formulation With SQL

A relational algebra operator used to combine rows from two tables is the ______________ operator.

Figuer: VOTE Name votel vote2 Bill 20 15 Mary 10 25 Jill 15 0 Bob 30 -SELECT Vote2,COUNT(*) FROM VOTE GROUP BY Vote2 In SQL2,the execution of this query produces the following number of rows:

In outer join queries,non-matched rows in the result table would contain ____________ values in certain columns.

Type II nested queries should not be used for a join operation when the result table contains any columns from the inner query.

Using a Type I nested query is the standard way to reference related tables in SQL DELETE statements.

The following SQL statement could not be executed because what column is included in the SELECT? _____________ SELECT StdSSN,StdLastName,StdMajor,EnrGrade FROM Student WHERE Student.StdSSN IN (SELECT StdSSN FROM Enrollment WHERE EnrGrade > 3.5)

Type I nested queries are useful for some join problems but should not be used for difference problems.

An operator that generates a result table that contains the matching rows of both tables plus the non-matching rows of one of the input tables is a(n)_____________________.

In simple conditions,only rows in which the condition evaluates to false are excluded from the result set.

Figuer: VOTE Name votel vote2 Bill 20 15 Mary 10 25 Jill 15 0 Bob 30 -SELECT * FROM VOTE WHERE Vote1>10 OR VOTE2 >10 The execution of this query produces the following number of rows:

The following SQL statement is an example of a Type II nested query: SELECT StdSSN,StdLastName,StdMajor FROM Student WHERE Student.StdSSN IN (SELECT StdSSN FROM Enrollment WHERE EnrGrade > 3.5)

To be union compatible each corresponding column from both temporary tables must have compatible data types.

Using the join operator style,the result set of a one-sided outer join depends on the direction and position of the table names in the query.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters