Question 1

Given the two relations X and Y below
  
what values would be retrieved by executing the following statement?
SELECT X.A,X.B,Y.C
FROM X,Y
WHERE X.A < Y.D

Accepted Answer

The answer of Given the two relations X and Y...

Question 2

Which of the operations SELECT,PROJECT,and JOIN are actually used when executing the following SQL instruction?
SELECT A,B
FROM X
WHERE C = D

Accepted Answer

The answer of Which of the operations SELECT,PROJECT,and JOIN are...

Question 3

Place an X in the space before those requests below that require data mining techniques rather than traditional database techniques.Leave the other spaces blank.
_____ Identify all shoppers who bought dog food last week.
_____ Identify items that tend to be purchased by common shoppers.
_____ Identify any correlation between time-of-day and items purchased.
_____ Identify the items purchased during the first hour after opening the store.

Accepted Answer

The answer of Place an X in the space before...

Question 4

Identify two database models.
____________________

Accepted Answer

The answer of Identify two database models.
____________________...

Question 5

List four data mining techniques.
_____________________
_____________________
_____________________
_____________________

Accepted Answer

The answer of List four data mining techniques.
_____________________
_____________________
_____________________
_____________________...

Question 6

In a relational database,information is presented as though it were stored in tables called
_________________ ,each of which has columns called _________________ and rows
called _________________ .

Accepted Answer

The answer of In a relational database,information is presented as...

Question 7

Suppose you were going to construct a hash file with 20 to 25 buckets using the division hash function discussed in the text.How many buckets should you actually use?

Accepted Answer

The answer of Suppose you were going to construct a...

Question 8

Given the relation Employees containing the attributes Name,Address,and BirthDate,what question is answered by the following sequence of operations?
Temp ? SELECT from Employees where BirthDate < "January 4,1975"
Result? PROJECT Name from Temp

Accepted Answer

The answer of Given the relation Employees containing the attributes...

Question 9

Place an X in the space before those questions whose answers might be obtained by means of sequential pattern analysis.Leave the other spaces blank.
_____ What are progressing stages in youthful behavior that led to criminal activity?
_____ What are the symptoms of the various stages of a particular progressing disease?
_____ What crimes does a particular judge punish most harshly?
_____ What items had the highest sales volume last week?

Accepted Answer

The answer of Place an X in the space before...

Question 10

Suppose a relation X had the attributes Name,EmployeeID,and Address.Complete the following statement to obtain a list of the names and addresses of all employees.
Result ← ___________________________________ from X

Accepted Answer

The answer of Suppose a relation X had the attributes...

Question 11

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items.Leave the other spaces blank.
_____ Sequential file
_____ Indexed file
_____ Hash file
_____ Hash table

Accepted Answer

The answer of Place an X in the space before...

Question 12

Suppose a relation X had the attributes PartID (part identification number),StockGoal (quantity held when fully stocked),and CurrentQuantity (quantity actually in stock).Complete the following statement to obtain information about those parts that are not fully stocked.
Result ? SELECT from X where

Accepted Answer

The answer of Suppose a relation X had the attributes...

Question 13

Given the relation Employees containing the attributes Name,Address,and CurrentJobID and the relation Jobs containing the attributes JobID,SkillRating,Department,what question is answered by the following SQL statement?
SELECT SkillRating
FROM Employees,Jobs
WHERE Employees.Name = "Joe Smith"
AND Employees.CurrentJobID = Jobs.JobID

Accepted Answer

The answer of Given the relation Employees containing the attributes...

Question 14

Place an X in the space before those issues that are not problems associated with data mining.Leave the other spaces blank.
_____ Cascading rollback
_____ Deadlock
_____ Incorrect summary problem
_____ Lost update problem

Accepted Answer

The answer of Place an X in the space before...

Question 15

Given the three relations X,Y,and Z below
  
what values would be retrieved by executing the following statement?
SELECT X.B,Y.C,Z.F
FROM X,Y,Z
WHERE X.A > Y.D AND X.A = Z.E

Accepted Answer

The answer of Given the three relations X,Y,and Z below
...

Question 16

Place an X in the space before those questions whose answers might be obtained by means of outlier analysis.Leave the other spaces blank.
_____ Which are the flawed parts on a production line conveyor belt?
_____ What items have not sold during the last two days?
_____ What sales region generated the most orders over the last sales period?
_____ Which shoppers in a busy shopping mall are potential shoplifters?

Accepted Answer

The answer of Place an X in the space before...

Question 17

Given the two relations X and Y below
 $\begin{array}{l}
\text { X: }&
\begin{array}{ll}
\mathrm{A} & \mathrm{B} \
\hline 2 & \mathrm{~s} \
5 & \mathrm{Z}
\end{array}
&\text { Y: }&
\begin{array}{ll}
\mathrm{C} & \mathrm{D} \
\hline \mathrm{t} & 1 \
\mathrm{r} & 3 \
\mathrm{~W} & 2
\end{array}
\end{array}$  
what values would be in the tuple produced by the following statement?
Result ? JOIN X and Y where X.A < Y.D

Accepted Answer

The answer of Given the two relations X and Y...

Question 18

The term "lossless decomposition" refers to a decomposition of one relation into several relations such
that _____________________________________________ .

Accepted Answer

The answer of The term "lossless decomposition" refers to a...

Question 19

Given the two relations X and Y below
  
what values would be in the tuple produced by the following statements?
Temp ? JOIN X and Y where X.A = Y.D
Result ? PROJECT X.B,Y.C from Temp

Accepted Answer

The answer of Given the two relations X and Y...

Question 20

Given the relation Employees containing the attributes Name,Address,and CurrentJobID and the relation Jobs containing the attributes JobID,SkillRating,Department,what question is answered by the following sequence of operations?
Temp1 ? JOIN Employees and Jobs
where Employees.CurrentJobID = Jobs.JobID
Temp2 ? SELECT from Temp1 where Department = "Personnel"
Result ? PROJECT Name from Temp2

Accepted Answer

The answer of Given the relation Employees containing the attributes...

Quiz 9: Database Systems

Given the two relations X and Y below what values would be retrieved by executing the following statement? SELECT X.A,X.B,Y.C FROM X,Y WHERE X.A < Y.D

Which of the operations SELECT,PROJECT,and JOIN are actually used when executing the following SQL instruction? SELECT A,B FROM X WHERE C = D

Identify two database models. ____________________

List four data mining techniques. ___________ _ _ ___________

In a relational database,information is presented as though it were stored in tables called _________ ,each of which has columns called _ and rows called _________ .

Suppose you were going to construct a hash file with 20 to 25 buckets using the division hash function discussed in the text.How many buckets should you actually use?

Given the relation Employees containing the attributes Name,Address,and BirthDate,what question is answered by the following sequence of operations? Temp ? SELECT from Employees where BirthDate < "January 4,1975" Result? PROJECT Name from Temp

Suppose a relation X had the attributes Name,EmployeeID,and Address.Complete the following statement to obtain a list of the names and addresses of all employees. Result ← ___________________________________ from X

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items.Leave the other spaces blank. ___ Sequential file _ Indexed file _ Hash file ___ Hash table

Suppose a relation X had the attributes PartID (part identification number),StockGoal (quantity held when fully stocked),and CurrentQuantity (quantity actually in stock).Complete the following statement to obtain information about those parts that are not fully stocked. Result ? SELECT from X where

Place an X in the space before those issues that are not problems associated with data mining.Leave the other spaces blank. ___ Cascading rollback _ Deadlock _ Incorrect summary problem ___ Lost update problem

Given the three relations X,Y,and Z below what values would be retrieved by executing the following statement? SELECT X.B,Y.C,Z.F FROM X,Y,Z WHERE X.A > Y.D AND X.A = Z.E

The term "lossless decomposition" refers to a decomposition of one relation into several relations such that _____________________________________________ .

Given the two relations X and Y below what values would be in the tuple produced by the following statements? Temp ? JOIN X and Y where X.A = Y.D Result ? PROJECT X.B,Y.C from Temp

Quiz 9: Database Systems

Given the two relations X and Y below what values would be retrieved by executing the following statement? SELECT X.A,X.B,Y.C FROM X,Y WHERE X.A < Y.D

Which of the operations SELECT,PROJECT,and JOIN are actually used when executing the following SQL instruction? SELECT A,B FROM X WHERE C = D

Identify two database models. ____________________

List four data mining techniques. _____________________ _____________________ _____________________ _____________________

In a relational database,information is presented as though it were stored in tables called _________________ ,each of which has columns called _________________ and rows called _________________ .

Suppose you were going to construct a hash file with 20 to 25 buckets using the division hash function discussed in the text.How many buckets should you actually use?

Given the relation Employees containing the attributes Name,Address,and BirthDate,what question is answered by the following sequence of operations? Temp ? SELECT from Employees where BirthDate < "January 4,1975" Result? PROJECT Name from Temp

Suppose a relation X had the attributes Name,EmployeeID,and Address.Complete the following statement to obtain a list of the names and addresses of all employees. Result ← ___________________________________ from X

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items.Leave the other spaces blank. _____ Sequential file _____ Indexed file _____ Hash file _____ Hash table

Suppose a relation X had the attributes PartID (part identification number),StockGoal (quantity held when fully stocked),and CurrentQuantity (quantity actually in stock).Complete the following statement to obtain information about those parts that are not fully stocked. Result ? SELECT from X where

Place an X in the space before those issues that are not problems associated with data mining.Leave the other spaces blank. _____ Cascading rollback _____ Deadlock _____ Incorrect summary problem _____ Lost update problem

Given the three relations X,Y,and Z below what values would be retrieved by executing the following statement? SELECT X.B,Y.C,Z.F FROM X,Y,Z WHERE X.A > Y.D AND X.A = Z.E

The term "lossless decomposition" refers to a decomposition of one relation into several relations such that _____________________________________________ .

Given the two relations X and Y below what values would be in the tuple produced by the following statements? Temp ? JOIN X and Y where X.A = Y.D Result ? PROJECT X.B,Y.C from Temp

List four data mining techniques. ___________ _ _ ___________

In a relational database,information is presented as though it were stored in tables called _________ ,each of which has columns called _ and rows called _________ .

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items.Leave the other spaces blank. ___ Sequential file _ Indexed file _ Hash file ___ Hash table

Place an X in the space before those issues that are not problems associated with data mining.Leave the other spaces blank. ___ Cascading rollback _ Deadlock _ Incorrect summary problem ___ Lost update problem