Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Question 5

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

Accepted Answer

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

Question 6

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 $\leftarrow$___________________________________ from X

Accepted Answer

PROJECT Na

Question 7

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, th

Question 8

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 9

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 10

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.

Accepted Answer

The connection between an empl

Question 11

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

Accepted Answer

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

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 $\leftarrow$SELECT from X where _________________________________________

Accepted Answer

StockGoal

Question 13

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

Accepted Answer

A persistent object is one tha

Question 14

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

Accepted Answer

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

Question 15

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

Question 16

Describe the distinction between class description and cluster analysis.

Accepted Answer

Class description attempts to

Question 17

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 18

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

Accepted Answer

no informa

Question 19

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.

Accepted Answer

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

Question 20

Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?

Accepted Answer

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

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

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

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

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.

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

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 $\leftarrow$ ___________________________________ 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

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

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

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

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

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

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 ________________________________

Describe the distinction between class description and cluster analysis.

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

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.

Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?

Data Storage

Data Manipulation

Operating Systems

Networking and the Internet

Algorithms

Programming Languages

Software Engineering

Database Systems

Computer Graphics

Artificial Intelligence

Theory of Computation

Filters

Exam 8: Data Abstractions

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

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

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

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.

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

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 ←\leftarrow← ___________________________________ 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

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

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

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

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

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

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 ________________________________

Describe the distinction between class description and cluster analysis.

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

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.

Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?

Data Storage

Data Manipulation

Operating Systems

Networking and the Internet

Algorithms

Programming Languages

Software Engineering

Database Systems

Computer Graphics

Artificial Intelligence

Theory of Computation

Filters

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 $\leftarrow$ ___________________________________ 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

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