Question 1

The following Query will produce

Accepted Answer

A)  All employees who have been hired 
B)  Employees who have been hired and fired 
C)  The query will not produce anything because the data requested is incomplete 
D)  All employees who were hired within the range of dates the end user enters in prompt boxes provided by Access. 
E)  The employees who were fired within 30 days of being hired. 
A)  All employees who have been hired 
B)  Employees who have been hired and fired 
C)  The query will not produce anything because the data requested is incomplete 
D)  All employees who were hired within the range of dates the end user enters in prompt boxes provided by Access. 
E)  The employees who were fired within 30 days of being hired.

Question 2

A Microsoft Access dynaset looks and behaves like a table but is not stored as a table.

Accepted Answer

A) True 
 B)False

Question 3

A single SQL query statement can accomplish relational algebra select, project, and join operations.

Accepted Answer

A) True 
 B)False

Question 4

If a table contained 20 columns and you wanted to use only ten of the table's columns in a query you would use:

Accepted Answer

A)  A vertical subset 
B)  A horizontal subset 
C)  A JOIN 
D)  An OPEN 
E)  A diagonal subset 
A)  A vertical subset 
B)  A horizontal subset 
C)  A JOIN 
D)  An OPEN 
E)  A diagonal subset

Question 5

A calculation that performs a mathematical operation within a single column of data is called an aggregation function.

Accepted Answer

A) True 
 B)False

Question 6

Three tables exist in a relational database as follows:
   What would a full outer join of these three tables include in its answer? Give a complete picture of what the answer would look like, using only the Student ID and CourseID attributes, and assuming Student is the left table, StudentTakesCourse is middle, and Course is the right table.

Accepted Answer

The answer of Three tables exist in a relational database...

Question 7

What is the general name for a query that prompts the user to enter criteria to apply in selecting the rows of interest in a table?

Accepted Answer

A)  Outer join query 
B)  Filter query 
C)  Select query 
D)  Parameter query 
E)  Inner join query 
A)  Outer join query 
B)  Filter query 
C)  Select query 
D)  Parameter query 
E)  Inner join query

Question 8

The SELECT component of a SQL query statement specifies which attributes are to be included in the answer to the query.

Accepted Answer

A) True 
 B)False

Question 9

An SQL query statement that accomplishes only the relational algebra PROJECT operation would not include a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 10

In SQL what character allows the database to know that the end of the query has been reached?

Accepted Answer

A)  / 
B)  * 
C)  . 
D)  ; 
E)  ^ 
A)  / 
B)  * 
C)  . 
D)  ; 
E)  ^

Question 11

A horizontal subset includes only some of the rows in the table and all of the table's columns.

Accepted Answer

A) True 
 B)False

Question 12

Given the following table schema, create a query using Structured Query Language that displays the total amount of cash receipts for the month of June, 2010.

Accepted Answer

SELECT Sum(DollarAmo

Question 13

Write the generic format of a SQL query statement and explain the purpose of each clause in the SQL statement. Include in your explanation a description of which relational algebra operations are accomplished by each component of a SQL query statement.

Accepted Answer

The format of a SQL query statement is S

Question 14

Which of the following SQL statements would produce a list of all employees from the Employee table that live in the Zip Code of 80112?

Accepted Answer

A)  Select * From Employee Where EmployeeId = 80112. 
B)  Select * From Employee Where ZipCode = 80112; 
C)  Select * From Employee Where ZipCode = 80112 And EmployeeId Is <Blank, 
D)  Select * From ZipCode Where EmployeeId = 80112; 
E)  Select ZipCode From Employee Where EmployeeId = 80112; 
A)  Select * From Employee Where EmployeeId = 80112. 
B)  Select * From Employee Where ZipCode = 80112; 
C)  Select * From Employee Where ZipCode = 80112 And EmployeeId Is <Blank, 
D)  Select * From ZipCode Where EmployeeId = 80112; 
E)  Select ZipCode From Employee Where EmployeeId = 80112;

Question 15

Mathematical Comparison operators are used in which part of the SQL statement?

Accepted Answer

A)  SELECT 
B)  WHERE 
C)  JOIN 
D)  PROJECT 
E)  FROM 
A)  SELECT 
B)  WHERE 
C)  JOIN 
D)  PROJECT 
E)  FROM

The following Query will produce

A Microsoft Access dynaset looks and behaves like a table but is not stored as a table.

A single SQL query statement can accomplish relational algebra select, project, and join operations.

If a table contained 20 columns and you wanted to use only ten of the table's columns in a query you would use:

A calculation that performs a mathematical operation within a single column of data is called an aggregation function.

What is the general name for a query that prompts the user to enter criteria to apply in selecting the rows of interest in a table?

The SELECT component of a SQL query statement specifies which attributes are to be included in the answer to the query.

An SQL query statement that accomplishes only the relational algebra PROJECT operation would not include a WHERE clause.

In SQL what character allows the database to know that the end of the query has been reached?

A horizontal subset includes only some of the rows in the table and all of the table's columns.

Given the following table schema, create a query using Structured Query Language that displays the total amount of cash receipts for the month of June, 2010.

Write the generic format of a SQL query statement and explain the purpose of each clause in the SQL statement. Include in your explanation a description of which relational algebra operations are accomplished by each component of a SQL query statement.

Which of the following SQL statements would produce a list of all employees from the Employee table that live in the Zip Code of 80112?

Mathematical Comparison operators are used in which part of the SQL statement?

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

The following Query will produce

A Microsoft Access dynaset looks and behaves like a table but is not stored as a table.

A single SQL query statement can accomplish relational algebra select, project, and join operations.

If a table contained 20 columns and you wanted to use only ten of the table's columns in a query you would use:

A calculation that performs a mathematical operation within a single column of data is called an aggregation function.

What is the general name for a query that prompts the user to enter criteria to apply in selecting the rows of interest in a table?

The SELECT component of a SQL query statement specifies which attributes are to be included in the answer to the query.

An SQL query statement that accomplishes only the relational algebra PROJECT operation would not include a WHERE clause.

In SQL what character allows the database to know that the end of the query has been reached?

A horizontal subset includes only some of the rows in the table and all of the table's columns.

Given the following table schema, create a query using Structured Query Language that displays the total amount of cash receipts for the month of June, 2010.

Write the generic format of a SQL query statement and explain the purpose of each clause in the SQL statement. Include in your explanation a description of which relational algebra operations are accomplished by each component of a SQL query statement.

Which of the following SQL statements would produce a list of all employees from the Employee table that live in the Zip Code of 80112?

Mathematical Comparison operators are used in which part of the SQL statement?

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