Question 1

Which relationship type does (1:N)mean?

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 2

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

A recursive relationship occurs between two different instances of an entity.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

Accepted Answer

A)  Select 
B)  Project 
C)  Join 
D)  Display 
A)  Select 
B)  Project 
C)  Join 
D)  Display

Question 9

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 10

A collection of data representing multiple occurrences of a resource,event,or agent is known as a(n)______________________________.

Accepted Answer

The answer of A collection of data representing multiple occurrences...

Question 11

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 12

REA stands for resources,entities and agents.

Accepted Answer

A) True 
 B)False

Question 13

For the following entity and attribute model,what would be the key attribute of the Students entity?

Accepted Answer

A)  social security number 
B)  name 
C)  address 
D)  street 
A)  social security number 
B)  name 
C)  address 
D)  street

Question 14

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,Train_Cod

Question 15

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

Accepted Answer

cardinalit

Question 16

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

Accepted Answer

composite

Question 17

SQL is a powerful database language that can be used to define database systems,query the database for information,generate reports from the database,and access databases from within programs using embedded commands.

Accepted Answer

A) True 
 B)False

Question 18

The mapping of the relationships between entities would be used in the development of a(n):

Accepted Answer

A)  context diagram 
B)  logical DFD 
C)  physical DFD 
D)  REA Model 
A)  context diagram 
B)  logical DFD 
C)  physical DFD 
D)  REA Model

Question 19

Composite attributes consist of multiple subattributes.

Accepted Answer

A) True 
 B)False

Question 20

An entity can be classified as all of the following except:

Accepted Answer

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

Which relationship type does (1:N)mean?

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

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

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

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

A recursive relationship occurs between two different instances of an entity.

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

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

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

A collection of data representing multiple occurrences of a resource,event,or agent is known as a(n)______________________________.

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

REA stands for resources,entities and agents.

For the following entity and attribute model,what would be the key attribute of the Students entity?

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

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

SQL is a powerful database language that can be used to define database systems,query the database for information,generate reports from the database,and access databases from within programs using embedded commands.

The mapping of the relationships between entities would be used in the development of a(n):

Composite attributes consist of multiple subattributes.

An entity can be classified as all of the following except:

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

Which relationship type does (1:N)mean?

Spreadsheets that are kept offline to an organization's enterprise systems can improve internal control.

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

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

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

A recursive relationship occurs between two different instances of an entity.

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

Which of the following commands allow us to join data across multiple tables to link specific pieces of information that are of interest?

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

A collection of data representing multiple occurrences of a resource,event,or agent is known as a(n)______________________________.

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

REA stands for resources,entities and agents.

For the following entity and attribute model,what would be the key attribute of the Students entity?

The ______________________________ specifies how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship.

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

SQL is a powerful database language that can be used to define database systems,query the database for information,generate reports from the database,and access databases from within programs using embedded commands.

The mapping of the relationships between entities would be used in the development of a(n):

Composite attributes consist of multiple subattributes.

An entity can be classified as all of the following except:

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