Question 1

What does it mean to say that an object is persistent?

Accepted Answer

A persistent object is one tha

Question 2

Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

Accepted Answer

A)  Lost update problem 
B)  Clustering 
C)  Deadlock 
D)  Incorrect summary problem 
A)  Lost update problem 
B)  Clustering 
C)  Deadlock 
D)  Incorrect summary problem

Question 3

Translate the following query into a single SQL statement.
Temp ← SELECT from X where A = B
Result ← PROJECT A,C from Temp

Accepted Answer

select A,C

Question 4

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

Second,thi

Question 5

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

Accepted Answer

A)  SELECT 
B)  PROJECT 
C)  JOIN 
A)  SELECT 
B)  PROJECT 
C)  JOIN

Question 6

Which of the following file structures is most efficient in cases in which the file is always processed in its entirety a predetermined order?

Accepted Answer

A)  Sequential 
B)  Indexed 
C)  Hash 
A)  Sequential 
B)  Indexed 
C)  Hash

Question 7

Given the two relations X and Y below

$\begin{array}{l}
\text { X: } \quad \begin{array} { l l } 
\text { A } & \text { B } \
\hline 7 & \mathrm {~s} \
2 & \text { Z }
\end{array}\\
\mathrm { Y } :\quad \begin{array} { l l } 
\mathrm { C } & \mathrm { D } \
\hline \mathrm { t } & 3 \
\mathrm { r } & 2
\end{array}
\end{array}$
What value would be retrieved by executing the following SQL statement?
SELECT Y.C FROM X,Y WHERE X.A < Y.D

Accepted Answer

A)  s 
B)  z 
C)  t 
D)  r 
A)  s 
B)  z 
C)  t 
D)  r

Question 8

Identify two database models.
____________________

Accepted Answer

Possible answers inc

Question 9

Given the relation Parts containing the attributes PartName,PartNumber,and SupplierID as well as the relation Suppliers containing the attributes SupplierID,Address,FaxNumber,write an SQL statement to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Accepted Answer

SELECT Suppliers.SupplierID,Su

Question 10

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

StockGoal != Current

Question 11

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 12

Given a relation called People whose attributes are Name,Father,and Mother (containing each person's name as well as the name of that person's parents),write an SQL statement to obtain a list of all the children of Nathan.

Accepted Answer

SELECT Nam

What does it mean to say that an object is persistent?

Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

Translate the following query into a single SQL statement. Temp ← SELECT from X where A = B Result ← PROJECT A,C from Temp

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

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

Which of the following file structures is most efficient in cases in which the file is always processed in its entirety a predetermined order?

Given the two relations X and Y below X: A B 7 2 Z : 3 2 What value would be retrieved by executing the following SQL statement? SELECT Y.C FROM X,Y WHERE X.A < Y.D

Identify two database models. ____________________

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

Given a relation called People whose attributes are Name,Father,and Mother (containing each person's name as well as the name of that person's parents),write an SQL statement to obtain a list of all the children of Nathan.

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

What does it mean to say that an object is persistent?

Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

Translate the following query into a single SQL statement. Temp ← SELECT from X where A = B Result ← PROJECT A,C from Temp

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

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

Which of the following file structures is most efficient in cases in which the file is always processed in its entirety a predetermined order?

Given the two relations X and Y below X: A B 7 2 Z : 3 2 What value would be retrieved by executing the following SQL statement? SELECT Y.C FROM X,Y WHERE X.A < Y.D

Identify two database models. ____________________

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

Given a relation called People whose attributes are Name,Father,and Mother (containing each person's name as well as the name of that person's parents),write an SQL statement to obtain a list of all the children of Nathan.

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

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