Question 1

In a relational database, a relation is defined as a collection of data representing multiple occurrences of the following except:

Accepted Answer

A)  a resource 
B)  an event 
C)  an activity 
D)  an agent 
A)  a resource 
B)  an event 
C)  an activity 
D)  an agent

Question 2

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

Accepted Answer

A) True 
 B)False

Question 3

Exhibit 6-1
The following table is a view of BILLING_HOURS from the various data elements in High-Tech Corp.'s relational database.$\begin{array}{|c|c|c|c|c|c|}
\hline\text { I BILLING HOURS }& \text { Employee No } & \text { Clieat No } & \text { Date } & \text { Hours } & \text { Ballizug Rate } \
\hline &\text { B122 } & \text { F26768 } & 20010823 & 8 & 150 \
\hline &\text { A632 } & \text { F11555 } & 20010823 & 7 & 100 \
\hline& \text { B122 } & \text { F26768 } & 20010824 & 8 & 150 \
\hline& \text { A632 } & \text { F11555 } & 20010824 & 6 & 100 \
\hline& \text { B122 } & \text { F26768 } & 20010825 & 9 & 150 \
\hline &\text { A632 } & \text { F11555 } & 20010825 & 10 & 100 \
\hline
\end{array}$

-Refer to Exhibit 6-1. Which of the following SQL statements would extract the employee number and date for every instance that had a billing rate of $150?

Accepted Answer

A)  SELECT Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
B)  QUERY Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Employee_No, Date
WHERE Rate=150 
D)  QUERY BILLING_HOURS
SELECT Employee_No, Date
WHERE Hours>8 
A)  SELECT Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
B)  QUERY Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Employee_No, Date
WHERE Rate=150 
D)  QUERY BILLING_HOURS
SELECT Employee_No, Date
WHERE Hours>8

In a relational database, a relation is defined as a collection of data representing multiple occurrences of the following except:

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 6: Relational Databases and SQL

In a relational database, a relation is defined as a collection of data representing multiple occurrences of the following except:

A set of data that describes a single instance of the entity represented by a relation is known as a tuple.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Database Management Systems

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters