Question 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 2

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 3

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is an attribute but least likely to be the key attribute?

Accepted Answer

A) client 
B) client number 
C) client name 
D) client street address 
A) client 
B) client number 
C) client name 
D) client street address

Question 5

Attributes are often called fields.

Accepted Answer

A) True 
 B)False

Question 6

A legacy system is one that has existed in an organization for less than one year.

Accepted Answer

A) True 
 B)False

Question 7

Queries of a database are driven by ____________________ commands.

Accepted Answer

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

Question 8

The following table is a view of TRAINING_COMPLETED from the various data elements in High-Tech Corp.'s relational database:
   Required: 
a.Using proper SQL commands, develop a query to extract training data for employee Missy Pitman (employee number 11111), showing the date, hours, and training code.
b.Design a table showing the output that would be generated based upon your query created above.

Accepted Answer

a.SELECT
Date, Hours

Question 9

The customer street address is often used as the key attribute in an REA diagram.

Accepted Answer

A) True 
 B)False

Question 10

Queries of a database are driven by SELECT commands.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following SQL statements would extract the client number and date for every instance that an employee worked less than 8 hours any particular day?

Accepted Answer

A) QUERY BILLING_HOURS SELECT Client_No, Date
WHERE Hours8 
C) SELECT Client_No, Date WHERE Hours<8 
D) SELECT Client_No, Date FROM BILLING_HOURS
WHERE Hours<8 
A) QUERY BILLING_HOURS SELECT Client_No, Date
WHERE Hours8 
C) SELECT Client_No, Date WHERE Hours<8 
D) SELECT Client_No, Date FROM BILLING_HOURS
WHERE Hours<8

Question 12

A(n) ____________________ in an accounting system can be classified as a resource, event, or agent about which data is collected.

Accepted Answer

The answer of A(n) ____________________ in an accounting system can...

Question 13

The notation 1,N is used to specify the relationship type of one to many.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

Accepted Answer

A) divide the content of the Course relation to establish two relations having 1:N relationships 
B) add the primary key of the Student relation as an attribute in the Course relation 
C) create a new relation whose primary key is a composite of the primary keys of two relations 
D) add the primary key of the Course relation as an attribute in the Student relation 
A) divide the content of the Course relation to establish two relations having 1:N relationships 
B) add the primary key of the Student relation as an attribute in the Course relation 
C) create a new relation whose primary key is a composite of the primary keys of two relations 
D) add the primary key of the Course relation as an attribute in the Student relation

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The sequence of steps in identifying relationships in a model is:

Accepted Answer

A) evaluate entities as pairs, identify user existing and desired information, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked 
B) identify user existing and desired information, evaluate entities as pairs, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked 
C) evaluate entities as pairs, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked, identify user existing and desired information 
D) evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked, evaluate entities as pairs, identify user existing and desired information 
A) evaluate entities as pairs, identify user existing and desired information, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked 
B) identify user existing and desired information, evaluate entities as pairs, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked 
C) evaluate entities as pairs, evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked, identify user existing and desired information 
D) evaluate each entity to determine if there is any need for two occurrences of the same entity type to be linked, evaluate entities as pairs, identify user existing and desired information

Question 19

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

Accepted Answer

A) agent 
B) composite attribute 
C) attribute 
D) instance 
A) agent 
B) composite attribute 
C) attribute 
D) instance

Question 20

REA stands for ____________________, ____________________, and ____________________.

Accepted Answer

resources,

Which of the following SQL statements would extract the client number and date for every instance that had a billing rate of $150?

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

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

Which of the following is an attribute but least likely to be the key attribute?

Attributes are often called fields.

A legacy system is one that has existed in an organization for less than one year.

Queries of a database are driven by ____________________ commands.

The customer street address is often used as the key attribute in an REA diagram.

Queries of a database are driven by SELECT commands.

Which of the following SQL statements would extract the client number and date for every instance that an employee worked less than 8 hours any particular day?

A(n) ____________________ in an accounting system can be classified as a resource, event, or agent about which data is collected.

The notation 1,N is used to specify the relationship type of one to many.

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

A key attribute is the attribute whose value is:

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

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

The sequence of steps in identifying relationships in a model is:

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

REA stands for , , and .

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 6: Relational Databases and Sql

Which of the following SQL statements would extract the client number and date for every instance that had a billing rate of $150?

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

A primary attribute is the attribute whose value is unique for every entity that will appear in the database.

Which of the following is an attribute but least likely to be the key attribute?

Attributes are often called fields.

A legacy system is one that has existed in an organization for less than one year.

Queries of a database are driven by ____________________ commands.

The customer street address is often used as the key attribute in an REA diagram.

Queries of a database are driven by SELECT commands.

Which of the following SQL statements would extract the client number and date for every instance that an employee worked less than 8 hours any particular day?

A(n) ____________________ in an accounting system can be classified as a resource, event, or agent about which data is collected.

The notation 1,N is used to specify the relationship type of one to many.

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

A key attribute is the attribute whose value is:

The following E-R diagram shows a M:N relationship between two relations.To map this E-R diagram into a logical database model:

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

The sequence of steps in identifying relationships in a model is:

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

REA stands for ____________________, ____________________, and ____________________.

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 Receivable Cash Receipts Barcr Process

The Purchasing Process

Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

General Ledger and Business Reporting Glbr Process

Acquiring and Implementing Accounting Information Systems

Filters

REA stands for , , and .