(+5) Chapter review problem #43 on page 441. Which of the following statements a
ID: 3603968 • Letter: #
Question
(+5) Chapter review problem #43 on page 441. Which of the following statements answer the Question posed in the problem
a. The sum computed by T1 would be $100 too small because it subtracted the balance of A before the transfer made by T2 to the balance of B after the transfer.
b. The sum computed by T1 would be $200 too large because it added the balance of A to the balance of B before the transfer made by T2 to the balance of B after the transfer.
c. The sum computed by T1 would be $100 too large because it added the balance of A before the transfer made by T2 to the balance of B after the transfer.
d. The sum computed by T1 would be correct but balance of A and B are incorrect.
(+5) Chapter review problem #35 on page 441. Which of the following statements answer the Question posed in the problem
a. The names of the people who have been employed in the sales dept
b. The names of the people who have NOT been employed in the sales dept
c. The names of the people who have been employed in the accounting dept
d. The names and Empl Id of the people who have been employed in the sales dept
(+5) Given the relation X below
X: A B C
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
A. 2 B. 3 C. 4 D. 5
(+5) Given the relation X below
X: A B C
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
a. 2 b. 3 c. 4 d. 5
(+5) Which of the following is the answer for Chapter review problem #59 on page 442
a. 124/23 produces the quotient 5 with a remainder of 9. Search bucket number 9.
b. 124/23 produces the quotient 5 with a remainder of 9. Search bucket number 5.
c. 124/23 produces the quotient 6 with a remainder of 10. Search bucket number 10.
d. 124/23 produces the quotient 6 with a remainder of 10. Search bucket number 6.
(+5) Suppose a relation X had the attributes Name, EmployeeID, and Address. Which statement will obtain a list of the names and addresses of all employees?
R1 ¬ PROJECT Name, Address from X
R1 ¬ SELECT Name, Address from X
R1 ¬ JOIN Name, Address from X
None of these
(+5) Given the relation X below
X: A B C
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
A. 2, 5 B. 3, 6 C. 2, 2 D. 5, 2
(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, what is the name of the person who works as a secretary in the Accounting Dept.
HINT: Q & E page 419
a. Joe E Baker
b. Cheryl H Clark
c. Cannot be determined
d. G Jerry Smith
(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, in what is the job title of employee Cheryl H Clark
a. Secretary
b. Floor Manager
c. Cannot be determined
d. Sales
(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, in what job does G Jerry Smith currently hold
a. S25X
b. S26Z
c. Cannot be determined
d. F5
(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, will the following sequence of relational operations obtain a list of job titles within the personnel department
TEMP ß SELECT from JOB where Dept = ”Personnel”
RESULT ß PROJECT JobTitle from TEMP
a. True
b. False
(+5) Chapter Review # 13 on page 440
Answers a and c provided Only b is required
a. TEMP ¬ SELECT from Manufacturer where PartName = "bolt 2Z"
RESULT ¬ PROJECT CompanyName from TEMP
c. TEMP1 ¬ JOIN PART and Manufacturer
where PART.PartName = MANUFACTURER.PartName
TEMP2 ¬ SELECT from TEMP1 where PART.Weight = 1
RESULT ¬ PROJECT Manufacturer.CompanyName from TEMP2
b. Which of the following answers the query: Obtain a list of the parts made by Company X along with each parts cost ?
TEMP ¬ SELECT from MANUFACTURER where CompanyName = COMPANY X
RESULT ¬ PROJECT PartName from TEMP
TEMP ¬ SELECT from MANUFACTURER where CompanyName = COMPANY X
RESULT ¬ PROJECT PartName, Cost from TEMP
TEMP ¬ SELECT from MANUFACTURER where CompanyName = COMPANY X
RESULT ¬ PROJECT Cost from TEMP
None of the above
(+5) Given the two relations X and Y below
X: A B Y: C D
2 s t 1
5 z r 3
w 2
what values would be in the tuple produced by the following statement?
Result ¬ JOIN X and Y where X.A < Y.D
a. 2, s, r, 3
b. 2, s, w, 2
c. 2, s, t, 1
d. 5, z, r, 3
(+5) Given the relation Employees containing the attributes Name, Address, and CurrentJobID and the relation Jobs containing the attributes JobID, SkillRating, Department, which of the following 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
What is the name of employees that work in the personnel department?
b. What is the JobID of employees that work in the personnel department?
What is the Name of employees that do not work in the personnel department?
d. What is the CurrentJobID of employees that work in the personnel department?
(+5) Given the two relations X and Y below
X: A B Y: C D
2 s t 1
5 z r 3
w 2
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
a. s, t
b. s, w
c. z, w
d. z, r
(+5) Given the two relations X and Y below
X: A B Y: C D
7 s t 1
3 z r 3
1 u
what values would be retrieved by executing the following statements?
SELECT X.A, X.B, Y.C
FROM X, Y
WHERE X.A < Y.D
a. 3, s, t
b. 3, z, t
c. 1, u, t
d. 1, u, r
(+5) Given the three relations X, Y, and Z below
X: A B Y: C D Z: E F
7 s t 4 2 w
3 z r 2 3 q
1 u
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
a. s, t, q
b. s, t, w
c. z, r, q
d. z, r, w
(+5) Given the two relations X and Y below
X: A B Y: C D
7 s t 3
2 z r 2
what value would be retrieved by executing the following SQL statement?
SELECT Y.C FROM X, Y WHERE X.A < Y.D
A. s B. z C. t D. r
(+5) Given the two X and Y below
X: A B Y: C D
2 s t 1
5 z r 3
w 2
draw the relation below that would result that would be produced by the following statements?
Temp ¬ JOIN X and Y where X.A > Y.D
Result ¬ PROJECT X.B, Y.C from Temp
HINT: The relation should have two attributes (X.B and Y.C == columns) and 4 tuples
X.B Y.C
(+5)Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?
Lost update problem
Clustering
Deadlock
Incorrect summary problem
(+5) 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?
A. Class description B. Class discrimination
C. Cluster analysis D. Association analysis
(+5) Which of the following data mining techniques would be answered by using outlier analysis?
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 item had an average sales volume last week ?
Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?
A. Class description B. Class discrimination
C. Cluster analysis D. Association analysis
Which of the following relational operations extracts entire columns from a relation?
A. SELECT B. PROJECT C. JOIN
Which of the following relational operations extracts entire rows from a relation?
A. SELECT B. PROJECT C. JOIN
ISBN-13: 9780133593372Explanation / Answer
what values would be in the tuple produced by the following statement?
Result JOIN X and Y where X.A < Y.D
--> [A] 2,s,r,3
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
--> [B] s,w
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
--> [c] 1,u,t
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
-->[C] z,r,q
what value would be retrieved by executing the following SQL statement?
SELECT Y.C FROM X, Y WHERE X.A < Y.D
--> [c] t
Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?
--> [B] Clustering
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?
--> [B] Class discrimination
Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?
--> [D] Association Analysis
Which of the following relational operations extracts entire columns from a relation?
--> [B] Project
Which of the following relational operations extracts entire rows from a relation?
--> [A] Select
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.