Question 1

______________________________ map and define the way in which data can be extracted from a database.

Accepted Answer

The answer of ______________________________ map and define the way in...

Question 2

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

Accepted Answer

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

Question 3

Which is not an SQL command in which data can be changed in the database?

Accepted Answer

A)  INSERT 
B)  DELETE 
C)  UPDATE 
D)  CREATE 
A)  INSERT 
B)  DELETE 
C)  UPDATE 
D)  CREATE

Question 4

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 5

The first step in identifying all the relationships that should be included in a model is to identify users' existing and desired information.

Accepted Answer

A) True 
 B)False

Question 6

A(n)______________________________ is an item of data that characterizes an entity or relationship.

Accepted Answer

The answer of A(n)______________________________ is an item of data that...

Question 7

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Accepted Answer

Business intelligenc

Question 8

Attributes are often called fields.

Accepted Answer

A) True 
 B)False

Question 9

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

Accepted Answer

The answer of The ______________________________ command demonstrates one of the...

Question 10

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 11

A collection of data representing multiple occurrences of a resource,event,or agent is known as a relation.

Accepted Answer

A) True 
 B)False

Question 12

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

Accepted Answer

A) True 
 B)False

Question 13

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 14

A(n)______________________________ is a primary key that is inserted into other tables to establish links among the tables.

Accepted Answer

The answer of A(n)______________________________ is a primary key that is...

Question 15

Which of the following statements about the participation constraint is false?

Accepted Answer

A)  It specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B)  The constraint is either 1 or 0. 
C)  It is the most common constraint in E-R diagrams. 
D)  It provides more information than the cardinality constraint. 
A)  It specifies the degree of minimum participation of one entity in the relationship with the other entity. 
B)  The constraint is either 1 or 0. 
C)  It is the most common constraint in E-R diagrams. 
D)  It provides more information than the cardinality constraint.

Question 16

Which of the following is not a relationship type?

Accepted Answer

A)  one-to-many 
B)  one-to-one 
C)  one-to-few 
D)  many-to-many 
A)  one-to-many 
B)  one-to-one 
C)  one-to-few 
D)  many-to-many

Question 17

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Accepted Answer

A) True 
 B)False

Question 18

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

______________________________ map and define the way in which data can be extracted from a database.

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

Which is not an SQL command in which data can be changed in the database?

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?

The first step in identifying all the relationships that should be included in a model is to identify users' existing and desired information.

A(n)______________________________ is an item of data that characterizes an entity or relationship.

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Attributes are often called fields.

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

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

A collection of data representing multiple occurrences of a resource,event,or agent is known as a relation.

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

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

A(n)______________________________ is a primary key that is inserted into other tables to establish links among the tables.

Which of the following statements about the participation constraint is false?

Which of the following is not a relationship type?

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

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

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?

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 Oesprocess

The Billingaccounts Receivablecash Receipts Barcrprocess

The Purchasing Process

The Accounts Payablecash Disbursements Apcdprocess

The Human Resources Process Hrmanagement and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting Glbrprocess

Acquiring and Implementing Accounting Information Systems

Filters

Exam 6: Relational Databases and SQL

______________________________ map and define the way in which data can be extracted from a database.

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

Which is not an SQL command in which data can be changed in the database?

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?

The first step in identifying all the relationships that should be included in a model is to identify users' existing and desired information.

A(n)______________________________ is an item of data that characterizes an entity or relationship.

______________________________ uses state-of-the-art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Attributes are often called fields.

The ______________________________ command demonstrates one of the weaknesses in most forms of SQL because the database will not enforce referential integrity.

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

A collection of data representing multiple occurrences of a resource,event,or agent is known as a relation.

Most DBMS available today that include SQL also include mechanisms within the DBMS itself for establishing and enforcing referential integrity.

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

A(n)______________________________ is a primary key that is inserted into other tables to establish links among the tables.

Which of the following statements about the participation constraint is false?

Which of the following is not a relationship type?

Knowledge management uses state-of-the art information technologies for storing and analyzing data to help managers make the best possible decisions for their companies.

Representing supervisors and their employees as separate entities in the model can lead to data redundancy.

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

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?

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 Oesprocess

The Billingaccounts Receivablecash Receipts Barcrprocess

The Purchasing Process

The Accounts Payablecash Disbursements Apcdprocess

The Human Resources Process Hrmanagement and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting Glbrprocess

Acquiring and Implementing Accounting Information Systems

Filters