Question 1

Which of the following are the relational algebra operators that accomplish the logic underlying most basic queries?

Accepted Answer

A)  SELECT, JOIN, FROM 
B)  OPEN, CLOSE, SELECT 
C)  PROJECT, SELECT, JOIN 
D)  OPEN, CLOSE, DELETE 
E)  SELECT, CLOSE, JOIN 
A)  SELECT, JOIN, FROM 
B)  OPEN, CLOSE, SELECT 
C)  PROJECT, SELECT, JOIN 
D)  OPEN, CLOSE, DELETE 
E)  SELECT, CLOSE, JOIN

Question 2

What tool may be used in Microsoft Access querying to create horizontal calculations by pointing and clicking on field names and on mathematical operators?

Accepted Answer

The answer of What tool may be used in Microsoft...

Question 3

Which of the following join types will produce only the rows for which two tables' common attribute values match exactly:

Accepted Answer

A)  Equi-join 
B)  Right outer join 
C)  Inner join 
D)  Both equi-join and inner join 
E)  Left outer join 
A)  Equi-join 
B)  Right outer join 
C)  Inner join 
D)  Both equi-join and inner join 
E)  Left outer join

Question 4

Three tables exist in a relational database as follows:
   Which records from the Driver table would a Left Outer Join query of Driver (left table) to AssignmentDriverTruck (right table) include in its answer?

Accepted Answer

All Driver records w

Question 5

Which of the following SQL statements will sum the total number of items from the Inventory table's Quantity column?

Accepted Answer

A)  Project Quantity (Sum) From Inventory; 
B)  Select Sum (Quantity) From Inventory; 
C)  Select (Inventory) From Quantity Column And Sum Select (Inventory) Where (Quantity Column)= N And Itemid. 
D)  And (Sum)/ 
E)  Select Quantity Column From Inventory Where; 
A)  Project Quantity (Sum) From Inventory; 
B)  Select Sum (Quantity) From Inventory; 
C)  Select (Inventory) From Quantity Column And Sum Select (Inventory) Where (Quantity Column)= N And Itemid. 
D)  And (Sum)/ 
E)  Select Quantity Column From Inventory Where;

Question 6

A database includes the following tables. Design a query to identify the notebook computers whose condition worsened while they were checked out. The higher the number, the better the condition of the computer. Include the computer's ID, the ID of the employee who checked it out, the date it was checked out, the condition in which it was checked out, the date it was checked back in, and the condition in which it was checked back in. You may either write the query in SQL code or fill in the appropriate fields in the blank QBE design grid that follows the tables. The blank QBE design grid includes the "Total" line in case the query requires it; if the query does not use it, be sure to cross it off.

Accepted Answer

Select NCID, EmpID, DateOut, C

Question 7

Under what conditions does a valid SQL statement not include a WHERE clause?

Accepted Answer

A)  If the query is intended to accomplish only a relational algebra selection operation. 
B)  If the query is intended to accomplish only a relational algebra project operation. 
C)  If the query is intended to accomplish only a relational algebra join operation. 
D)  If the query is intended to combine a relational algebra join with a relational algebra selection operation. 
E)  No conditions exist under which an SQL statement is valid without including a WHERE clause; i.e., all SQL statements must include a WHERE clause. 
A)  If the query is intended to accomplish only a relational algebra selection operation. 
B)  If the query is intended to accomplish only a relational algebra project operation. 
C)  If the query is intended to accomplish only a relational algebra join operation. 
D)  If the query is intended to combine a relational algebra join with a relational algebra selection operation. 
E)  No conditions exist under which an SQL statement is valid without including a WHERE clause; i.e., all SQL statements must include a WHERE clause.

Question 8

What type of query in Microsoft Access allows a user to run the same query with different specified criteria without changing the query design?

Accepted Answer

The answer of What type of query in Microsoft Access...

Question 9

Given the Sale and Cash Receipt relational database tables below, which of the following answers would be produced by the query statement
SELECT Sum(Amount)
FROM Sale
WHERE Date >=6/30/02;

Accepted Answer

A)  Answer 1 
B)  Answer 2 
C)  Answer 3 
D)  Answer 4 
E)  Answer 5 
A)  Answer 1 
B)  Answer 2 
C)  Answer 3 
D)  Answer 4 
E)  Answer 5

Question 10

The following tables cannot be joined:

Accepted Answer

A) True 
 B)False

Question 11

Relational Algebra allows for multiple operations in a single query.

Accepted Answer

A) True 
 B)False

Question 12

The approach to providing information for decision makers that allows users to create their own queries as needed is called

Accepted Answer

A)  Database design 
B)  Predetermined query and interface design 
C)  Ad hoc querying 
D)  Scheduled querying 
E)  Three-pronged presupposed querying 
A)  Database design 
B)  Predetermined query and interface design 
C)  Ad hoc querying 
D)  Scheduled querying 
E)  Three-pronged presupposed querying

Question 13

A database includes the following tables and design for a query, Query3, illustrated in both Microsoft Access QBE and SQL formats.     (a) What is the result of the Query3 design applied to the tables? 
(b) If the goal is to identify the notebook computer makers of the computers that have not required any maintenance (including the NCID and the Maker name), does Query3 provide the needed information? 
(c) If the answer to (b) is no, what errors need to be corrected in Query3? 
(d) Once the query is corrected, what should the result look like?

Accepted Answer

(a) Null values
(b) No
(c) The join need

Question 14

Which of the following are Boolean Search operators?

Accepted Answer

A)  >, =, , BEGINNING 
A)  >, =, , BEGINNING

Question 15

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

Accepted Answer

The answer of What will be the result of the...

Question 16

The criteria field in the query design for Microsoft Access accepts Relational Algebra language syntax.

Accepted Answer

A) True 
 B)False

Question 17

Given the Sale and Cash Receipt relational database tables below, which of the relational algebra operators are needed to determine the unpaid balance due for each sale? Assume the only fields the user wants to appear in the query solution are SaleID and Balance Due, and also assume the user wants sales with zero balances to be included in the query solution.

Accepted Answer

A)  SELECT, PROJECT, and JOIN 
B)  PROJECT and SELECT 
C)  JOIN only 
D)  PROJECT and JOIN 
E)  SELECT and JOIN 
A)  SELECT, PROJECT, and JOIN 
B)  PROJECT and SELECT 
C)  JOIN only 
D)  PROJECT and JOIN 
E)  SELECT and JOIN

Question 18

Given the following tables and query, what is the most likely result?

Accepted Answer

A)  Answer Choice 1 
B)  Answer Choice 2 
C)  Answer Choice 3 
D)  Answer Choice 4 
A)  Answer Choice 1 
B)  Answer Choice 2 
C)  Answer Choice 3 
D)  Answer Choice 4

Question 19

What will be the result of the following SQL statement applied to the CashDisbursement table?
CashDisbursement
   SELECT Sum(Amount)
FROM CashDisbursement
WHERE Date  40204;

Accepted Answer

The answer of What will be the result of the...

Question 20

A query in Microsoft Access takes a subset of data contained in a table and creates another table on which you can perform multiple queries.

Accepted Answer

A) True 
 B)False

Which of the following are the relational algebra operators that accomplish the logic underlying most basic queries?

What tool may be used in Microsoft Access querying to create horizontal calculations by pointing and clicking on field names and on mathematical operators?

Which of the following join types will produce only the rows for which two tables' common attribute values match exactly:

Three tables exist in a relational database as follows: Which records from the Driver table would a Left Outer Join query of Driver (left table) to AssignmentDriverTruck (right table) include in its answer?

Which of the following SQL statements will sum the total number of items from the Inventory table's Quantity column?

Under what conditions does a valid SQL statement not include a WHERE clause?

What type of query in Microsoft Access allows a user to run the same query with different specified criteria without changing the query design?

Given the Sale and Cash Receipt relational database tables below, which of the following answers would be produced by the query statement SELECT Sum(Amount) FROM Sale WHERE Date >=6/30/02;

The following tables cannot be joined:

Relational Algebra allows for multiple operations in a single query.

The approach to providing information for decision makers that allows users to create their own queries as needed is called

Which of the following are Boolean Search operators?

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

The criteria field in the query design for Microsoft Access accepts Relational Algebra language syntax.

Given the following tables and query, what is the most likely result?

What will be the result of the following SQL statement applied to the CashDisbursement table? CashDisbursement SELECT Sum(Amount) FROM CashDisbursement WHERE Date <=2/05/2010 AND PayeeID > 40204;

A query in Microsoft Access takes a subset of data contained in a table and creates another table on which you can perform multiple queries.

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters

Exam 7: Information Retrieval From Relational Databases

Which of the following are the relational algebra operators that accomplish the logic underlying most basic queries?

What tool may be used in Microsoft Access querying to create horizontal calculations by pointing and clicking on field names and on mathematical operators?

Which of the following join types will produce only the rows for which two tables' common attribute values match exactly:

Three tables exist in a relational database as follows: Which records from the Driver table would a Left Outer Join query of Driver (left table) to AssignmentDriverTruck (right table) include in its answer?

Which of the following SQL statements will sum the total number of items from the Inventory table's Quantity column?

Under what conditions does a valid SQL statement not include a WHERE clause?

What type of query in Microsoft Access allows a user to run the same query with different specified criteria without changing the query design?

Given the Sale and Cash Receipt relational database tables below, which of the following answers would be produced by the query statement SELECT Sum(Amount) FROM Sale WHERE Date >=6/30/02;

The following tables cannot be joined:

Relational Algebra allows for multiple operations in a single query.

The approach to providing information for decision makers that allows users to create their own queries as needed is called

Which of the following are Boolean Search operators?

What will be the result of the following Microsoft Access QBE query of the CashDisbursement table?

The criteria field in the query design for Microsoft Access accepts Relational Algebra language syntax.

Given the following tables and query, what is the most likely result?

What will be the result of the following SQL statement applied to the CashDisbursement table? CashDisbursement SELECT Sum(Amount) FROM CashDisbursement WHERE Date <=2/05/2010 AND PayeeID > 40204;

A query in Microsoft Access takes a subset of data contained in a table and creates another table on which you can perform multiple queries.

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

View Integration and Implementation Compromises

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters