Question 1

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

Accepted Answer

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

Question 2

The cardinality constraint:

Accepted Answer

A)  specifies the degree of minimum participation of one entity in the relationship with the other entity.
B)  provides more information than the participation constraint.
C)  is the most common constraint specified in E-R diagrams.
D)  all of the above.E) A) and C)
F) A) and B)

Question 3

Which of the following is the entity or agent?

Accepted Answer

A)  client
B)  client number
C)  client name
D)  client street addressE) B) and D)
F) B) and C) A

Question 4

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

Accepted Answer

A)  INSERT
B)  DELETE
C)  UPDATE
D)  CREATEE) A) and B)
F) A) and D)

Question 5

REA stands for resources, entities and agents

Accepted Answer

A) True 
 B)False

Question 6

Enterprise systems are integrated software packages designed to provide complete integration of:

Accepted Answer

A)  an organization's accounting information system
B)  an organization's business data
C)  an organization's business information processing systems and all related data
D)  an organization's managementE) A) and B)
F) A) and C) C

Question 7

A(n)  ____ of an entity is on specific thing of the type defined by the entity.

Accepted Answer

A)  agent
B)  composite attribute
C)  attribute
D)  instanceE) None of the above
F) A) and B)

Question 8

Legacy systems do not usually have which of the following characteristics?

Accepted Answer

A)  developed on previous hardware (and/or software)  platforms
B)  are easily adaptable to enterprise systems
C)  have been used by an organization for a long period of time
D)  all of the above are typical characteristics of legacy systemsE) A) and B)
F) A) and D)

Question 9

The relationship that relates to the specification of how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship is referred to as ______________________________.

Accepted Answer

cardinality constraint

Question 10

The ____________________ command is used to add new tuples to a relation.

Accepted Answer

The answer of The ____________________ command is used to add...

Question 11

Which of the following relational commands would a manager use to combine the data from two related relations into a third relation?

Accepted Answer

A)  select
B)  project
C)  join
D)  displayE) B) and D)
F) B) and C)

Question 12

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

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

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

Accepted Answer

The answer of The notation 1,N is used to specify...

Question 15

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

Accepted Answer

The answer of A set of data that describes a...

Question 16

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_HOURSWHERE Hours>8
B)  QUERY Employee_No, Date FROM BILLING_HOURSWHERE Hours>8
C)  SELECT Employee_No, Date WHERE Hours>8
D)  QUERY BILLING_HOURS SELECT Employee_No, DateWHERE Hours>8E) A) and D)
F) All of the above

Question 17

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-manyE) A) and D)
F) A) and C)

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The first step in REA is evaluating the attributes.

Accepted Answer

A) True 
 B)False

Question 20

In an REA diagram, the rectangle is used to represent the composite attribute.

Accepted Answer

A) True 
 B)False

Exam 6: Relational Databases and Sql

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

Correct AnswerverifiedShow Answer

The cardinality constraint:

Correct AnswerverifiedShow Answer

Which of the following is the entity or agent?

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

REA stands for resources, entities and agents

Correct AnswerverifiedShow Answer

Enterprise systems are integrated software packages designed to provide complete integration of:

Correct AnswerverifiedC

A(n) ____ of an entity is on specific thing of the type defined by the entity.

Correct AnswerverifiedShow Answer

Legacy systems do not usually have which of the following characteristics?

Correct AnswerverifiedShow Answer

The relationship that relates to the specification of how many occurrences of an entity can participate in the given relationship with any one occurrence of the other entity in the relationship is referred to as ______________________________.

Correct Answerverifiedcardinality constraint

The ____________________ command is used to add new tuples to a relation.

Correct AnswerverifiedShow Answer

Which of the following relational commands would a manager use to combine the data from two related relations into a third relation?

Correct AnswerverifiedShow Answer

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Which of the following is not a relationship type?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The first step in REA is evaluating the attributes.

Correct AnswerverifiedShow Answer

In an REA diagram, the rectangle is used to represent the composite attribute.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
cardinality constraint

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified