Filters
Question type

If a database contained a relation containing information about individual people (name,address,birthday,etc.)and another relation containing information about music composers (name,style,education level,etc.),how would you extend the database's design to include links between each individual and his or her favorite composer?

Correct Answer

verifed

verified

The main idea would be to add a new rela...

View Answer

Given the two relations X and Y below  X: AB2 s5Z Y: CDt1r3 W2\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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

What is th...

View Answer

What information is available from a relational database containing one relation with the attributes Name,Employee identification number,and Address that is not available from a database containing two relations,one with attributes Name and Address and the other with attributes Address and Employee identification number? Explain your answer.

Correct Answer

verifed

verified

The connection between an empl...

View Answer

Given the three relations X,Y,and Z below 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 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

Correct Answer

verifed

verified

Given the two relations X and Y below 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 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

Correct Answer

verifed

verified

Which of the following accesses a database in terms of a database model?


A) Application software
B) Database management system
C) Actual database

D) A) and B)
E) All of the above

Correct Answer

verifed

verified

Which of the following data mining techniques would be applied when trying to identify any underlying heterogeneity within housing patterns in a community?


A) Class description
B) Class discrimination
C) Cluster analysis
D) Association analysis

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

Given the relation Parts containing the attributes PartName,PartNumber,and SupplierID as well as the relation Suppliers containing the attributes SupplierID,Address,FaxNumber,write a sequence of SELECT,PROJECT,and JOIN operations to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

PROJECT Na...

View Answer

Describe the wound-wait protocol.

Correct Answer

verifed

verified

Young transactions must releas...

View Answer

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

Correct Answer

verifed

verified

Which empl...

View Answer

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

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

Which of the following relational operations combine data from more than one relation?


A) SELECT
B) PROJECT
C) JOIN

D) A) and B)
E) All of the above

Correct Answer

verifed

verified

Given the two relations X and Y below Given the two relations X and Y below     draw the relation 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 draw the relation 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

Correct Answer

verifed

verified

Which of the following features within a DBMS is not provided to maintain database integrity?


A) Concurrent transaction processing
B) Log
C) Locking protocol
D) Commit points

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Describe the distinction between class description and cluster analysis.

Correct Answer

verifed

verified

Class description attempts to ...

View Answer

Which of the following describes only the portion of a database available to a particular user?


A) Database model
B) Schema
C) Subschema
D) DBMS

E) All of the above
F) A) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Which empl...

View Answer

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

Correct Answer

verifed

verified

Showing 21 - 40 of 52

Related Exams

Show Answer