Question 1

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

Accepted Answer

A) True 
 B)False

Question 2

Queries of a database are driven by ______________________________ commands.

Accepted Answer

The answer of Queries of a database are driven by...

Question 3

A relation in an ER model is the same as an entity in the REA model.

Accepted Answer

A) True 
 B)False

Question 4

The DELETE command is used when we want to change one or more attribute values.

Accepted Answer

A) True 
 B)False

Question 5

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 an employee worked more than 8 hours any particular day?

Accepted Answer

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

Question 6

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____.

Accepted Answer

A)  tuple 
B)  resource 
C)  agent 
D)  event 
A)  tuple 
B)  resource 
C)  agent 
D)  event

Question 7

A(n) ______________________________ attribute is the attribute whose value is unique for every entity that will ever appear in the database.

Accepted Answer

The answer of A(n) ______________________________ attribute is the attribute whose...

Question 8

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 client number and date for every instance that had a billing rate of $150?

Accepted Answer

A)  QUERY BILLING_HOURS
SELECT Client_No, Date
WHERE Rate=150 
B)  QUERY Client_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Client_No, Date
WHERE Rate=150 
D)  SELECT Client_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
A)  QUERY BILLING_HOURS
SELECT Client_No, Date
WHERE Rate=150 
B)  QUERY Client_No, Date
FROM BILLING_HOURS
WHERE Rate=150 
C)  SELECT Client_No, Date
WHERE Rate=150 
D)  SELECT Client_No, Date
FROM BILLING_HOURS
WHERE Rate=150

Question 9

The DELETE command is the method used to delete a tuple from a relation.

Accepted Answer

A) True 
 B)False

Question 10

A key attribute is the attribute whose value is:

Accepted Answer

A)  undeterminable 
B)  unique 
C)  large 
D)  the same for all attributes 
A)  undeterminable 
B)  unique 
C)  large 
D)  the same for all attributes

Question 11

Which is not a step in creating a relation using SQL?

Accepted Answer

A)  assign the relation a name 
B)  assign each attribute a name 
C)  specify the constraints on the attributes 
D)  specify the attributes of the constraints 
A)  assign the relation a name 
B)  assign each attribute a name 
C)  specify the constraints on the attributes 
D)  specify the attributes of the constraints

Question 12

Attributes that consist of multiple subattributes are referred to as ______________________________.

Accepted Answer

composite

Question 13

In a relational database, the entity is represented as a(n):

Accepted Answer

A)  Table 
B)  Network 
C)  Field 
D)  Attribute 
A)  Table 
B)  Network 
C)  Field 
D)  Attribute

Question 14

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation, the tuple being referenced must remain intact.

Accepted Answer

A)  Cardinality constraint 
B)  Participation constraint 
C)  Referential integrity 
D)  Economic constraint 
A)  Cardinality constraint 
B)  Participation constraint 
C)  Referential integrity 
D)  Economic constraint

Question 15

A simplified representation of a complex entity is a(n):

Accepted Answer

A)  instance 
B)  attribute 
C)  model 
D)  relationship 
A)  instance 
B)  attribute 
C)  model 
D)  relationship

Question 16

______________________________ systems have existed in an organization over a long period of time and were developed using an organization's previous computer hardware and software platforms.

Accepted Answer

The answer of ______________________________ systems have existed in an organization...

Question 17

The cardinality constraint is used to specify both the minimum and maximum participation of one entity in the relationship with the other entity.

Accepted Answer

A) True 
 B)False

Question 18

The ______________________________ is specified to uniquely identity each tuple in the relation.

Accepted Answer

The answer of The ______________________________ is specified to uniquely identity...

Question 19

The SELECT statement has all but one of the following parts:

Accepted Answer

A)  a list of attributes that we wish to SELECT from the database 
B)  a WHEN clause 
C)  a list of tables where these attributes can be found 
D)  a WHERE clause 
A)  a list of attributes that we wish to SELECT from the database 
B)  a WHEN clause 
C)  a list of tables where these attributes can be found 
D)  a WHERE clause

Question 20

______________________________ values waste memory space and may cause problems when running queries.

Accepted Answer

The answer of ______________________________ values waste memory space and may...

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

Queries of a database are driven by ______________________________ commands.

A relation in an ER model is the same as an entity in the REA model.

The DELETE command is used when we want to change one or more attribute values.

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____.

A(n) ______________________________ attribute is the attribute whose value is unique for every entity that will ever appear in the database.

The DELETE command is the method used to delete a tuple from a relation.

A key attribute is the attribute whose value is:

Which is not a step in creating a relation using SQL?

Attributes that consist of multiple subattributes are referred to as ______________________________.

In a relational database, the entity is represented as a(n):

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation, the tuple being referenced must remain intact.

A simplified representation of a complex entity is a(n):

______________________________ systems have existed in an organization over a long period of time and were developed using an organization's previous computer hardware and software platforms.

The cardinality constraint is used to specify both the minimum and maximum participation of one entity in the relationship with the other entity.

The ______________________________ is specified to uniquely identity each tuple in the relation.

The SELECT statement has all but one of the following parts:

______________________________ values waste memory space and may cause problems when running queries.

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

An entity in an accounting system can be classified as a resource, event or agent about which data are collected.

Queries of a database are driven by ______________________________ commands.

A relation in an ER model is the same as an entity in the REA model.

The DELETE command is used when we want to change one or more attribute values.

A set of data that describes a single instance of the entity represented by a relation is known as a(n) ____.

A(n) ______________________________ attribute is the attribute whose value is unique for every entity that will ever appear in the database.

The DELETE command is the method used to delete a tuple from a relation.

A key attribute is the attribute whose value is:

Which is not a step in creating a relation using SQL?

Attributes that consist of multiple subattributes are referred to as ______________________________.

In a relational database, the entity is represented as a(n):

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation, the tuple being referenced must remain intact.

A simplified representation of a complex entity is a(n):

______________________________ systems have existed in an organization over a long period of time and were developed using an organization's previous computer hardware and software platforms.

The cardinality constraint is used to specify both the minimum and maximum participation of one entity in the relationship with the other entity.

The ______________________________ is specified to uniquely identity each tuple in the relation.

The SELECT statement has all but one of the following parts:

______________________________ values waste memory space and may cause problems when running queries.

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