Given the relation X below X: $\begin{array} { l l l } \mathrm { A } & \mathrm { B } & \mathrm { C } \\ \hline 2 & 5 & 7 \\ 3 & 3 & 3 \\ 4 & 4 & 2 \\ 5 & 2 & 8 \end{array}$ What value will be retrieved by the following query? TEMP ? SELECT from X where B = C RESULT ? PROJECT B from TEMP

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

Given the relation below X: $\begin{array} { l l l } \mathrm { A } & \mathrm { B } & \mathrm { C } \\ \hline 2 & 5 & 7 \\ 3 & 3 & 6 \\ 4 & 4 & 2 \\ 5 & 2 & 2 \end{array}$ What values will be retrieved by the following SQL statement? SELECT A,B FROM X WHERE X.B = X.C

A) 2, 5 B) 3, 6 C) 2, 2 D) 5, 2 A) 2, 5 B) 3, 6 C) 2, 2 D) 5, 2

Given the relation X below X: $\begin{array} { l l l } \mathrm { A } & \mathrm { B } & \mathrm { C } \\ \hline 2 & 5 & 7 \\ 3 & 3 & 3 \\ 4 & 3 & 2 \\ 5 & 2 & 8 \end{array}$ What value will be extracted by the following query? TEMP ? SELECT from X where B > C RESULT ? PROJECT A from TEMP

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

Exam 9: Database Systems

Describe a scenario in which computing the total deposits in a bank while also transferring $100 from account X to account Y would result in a final sum that is $100 too great.Then describe a scenario in which the final sum turns out to be $100 too small.

Free

(Essay)

4.8/5

(37)

Question 1

Correct Answer:

Verified

The first occurs if,when computing the total,one checks account X before the funds are withdrawn and account Y after the funds are deposited.The second occurs if account Y is checked before the funds are deposited and X is checked after the funds are withdrawn.

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

Free

(Short Answer)

4.8/5

(36)

Question 2

Correct Answer:

Verified

no information is lost

Given the relation X below X: 2 5 7 3 3 3 4 4 2 5 2 8 What value will be retrieved by the following query? TEMP ? SELECT from X where B = C RESULT ? PROJECT B from TEMP

Free

(Multiple Choice)

4.7/5

(37)

Question 3

Correct Answer:

Verified

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

(Short Answer)

4.8/5

(30)

Question 4

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

(Short Answer)

4.8/5

(31)

Question 5

List four data mining techniques. ___________ _ _ ___________

(Short Answer)

4.8/5

(25)

Question 6

Which of the following data mining techniques would be applied when trying to identify traits that characterize the citizens of a democracy who fail to vote?

(Multiple Choice)

4.7/5

(40)

Question 7

Which of the following file structures requires a small "auxiliary" storage system that must be updated as entries in the file are inserted or deleted.

(Multiple Choice)

4.8/5

(40)

Question 8

Given the relation below X: 2 5 7 3 3 6 4 4 2 5 2 2 What values will be retrieved by the following SQL statement? SELECT A,B FROM X WHERE X.B = X.C

(Multiple Choice)

4.8/5

(35)

Question 9

Which of the following file structures is commonly used for the storage of text files?

(Multiple Choice)

5.0/5

(41)

Question 10

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

(Short Answer)

4.9/5

(39)

Question 11

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.

(Short Answer)

4.7/5

(37)

Question 12

Which of the following file structures is associated with the problem of clustering?

(Multiple Choice)

4.8/5

(33)

Question 13

Describe the distinction between a traditional database and a data warehouse.

(Essay)

4.8/5

(36)

Question 14

Which of the following data mining techniques would be applied when trying to identify traits that predict whether a citizen in a democracy will or will not vote?

(Multiple Choice)

4.7/5

(38)

Question 15

Which of the following relational operations extracts entire rows from a relation?

(Multiple Choice)

4.7/5

(37)

Question 16

Which of the following relational operations is performed by the SQL statement below? SELECT A,B,C FROM X

(Multiple Choice)

4.9/5

(35)

Question 17

Given the relation X below X: 2 5 7 3 3 3 4 3 2 5 2 8 What value will be extracted by the following query? TEMP ? SELECT from X where B > C RESULT ? PROJECT A from TEMP

(Multiple Choice)

4.7/5

(32)

Question 18

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?

(Short Answer)

4.8/5

(31)

Question 19

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?

(Short Answer)

4.9/5

(40)

Question 20

Showing 1 - 20 of 52

Describe a scenario in which computing the total deposits in a bank while also transferring $100 from account X to account Y would result in a final sum that is $100 too great.Then describe a scenario in which the final sum turns out to be $100 too small.

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

Given the relation X below X: 2 5 7 3 3 3 4 4 2 5 2 8 What value will be retrieved by the following query? TEMP ? SELECT from X where B = C RESULT ? PROJECT B from TEMP

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

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. ___________ _ _ ___________

Which of the following data mining techniques would be applied when trying to identify traits that characterize the citizens of a democracy who fail to vote?

Which of the following file structures requires a small "auxiliary" storage system that must be updated as entries in the file are inserted or deleted.

Given the relation below X: 2 5 7 3 3 6 4 4 2 5 2 2 What values will be retrieved by the following SQL statement? SELECT A,B FROM X WHERE X.B = X.C

Which of the following file structures is commonly used for the storage of text files?

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

Which of the following file structures is associated with the problem of clustering?

Describe the distinction between a traditional database and a data warehouse.

Which of the following data mining techniques would be applied when trying to identify traits that predict whether a citizen in a democracy will or will not vote?

Which of the following relational operations extracts entire rows from a relation?

Which of the following relational operations is performed by the SQL statement below? SELECT A,B,C FROM X

Given the relation X below X: 2 5 7 3 3 3 4 3 2 5 2 8 What value will be extracted by the following query? TEMP ? SELECT from X where B > C RESULT ? PROJECT A from TEMP

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?

Data Representation

Data Representation

Operating Systems

Networks and the Internet

Algorithms

Programming Languages

Software Engineering

Data Abstractions

Computer Graphics

Artificial Intelligence

Theory of Computation

Filters

Exam 9: Database Systems

Describe a scenario in which computing the total deposits in a bank while also transferring $100 from account X to account Y would result in a final sum that is $100 too great.Then describe a scenario in which the final sum turns out to be $100 too small.

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

Given the relation X below X: 2 5 7 3 3 3 4 4 2 5 2 8 What value will be retrieved by the following query? TEMP ? SELECT from X where B = C RESULT ? PROJECT B from TEMP

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

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. _____________________ _____________________ _____________________ _____________________

Which of the following data mining techniques would be applied when trying to identify traits that characterize the citizens of a democracy who fail to vote?

Which of the following file structures requires a small "auxiliary" storage system that must be updated as entries in the file are inserted or deleted.

Given the relation below X: 2 5 7 3 3 6 4 4 2 5 2 2 What values will be retrieved by the following SQL statement? SELECT A,B FROM X WHERE X.B = X.C

Which of the following file structures is commonly used for the storage of text files?

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

Which of the following file structures is associated with the problem of clustering?

Describe the distinction between a traditional database and a data warehouse.

Which of the following data mining techniques would be applied when trying to identify traits that predict whether a citizen in a democracy will or will not vote?

Which of the following relational operations extracts entire rows from a relation?

Which of the following relational operations is performed by the SQL statement below? SELECT A,B,C FROM X

Given the relation X below X: 2 5 7 3 3 3 4 3 2 5 2 8 What value will be extracted by the following query? TEMP ? SELECT from X where B > C RESULT ? PROJECT A from TEMP

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?

Data Representation

Data Representation

Operating Systems

Networks and the Internet

Algorithms

Programming Languages

Software Engineering

Data Abstractions

Computer Graphics

Artificial Intelligence

Theory of Computation

Filters

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 _________ .