Question 1

Which of the following is not a proper SQL command for creating database relations?

Accepted Answer

A)  Create table employee 
B)  Create table training_completed 
C)  Create client 
D)  Alter table release_time 
A)  Create table employee 
B)  Create table training_completed 
C)  Create client 
D)  Alter table release_time

Question 2

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 3

The notation 1:N is used to specify the relationship type of ______________________________.

Accepted Answer

one to man

Question 4

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 5

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 6

A(n)______________________________ of an entity is one specific thing of the type defined by the entity.

Accepted Answer

The answer of A(n)______________________________ of an entity is one specific...

Question 7

Which of the following is the entity or agent?

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 8

Queries of a database are driven by ______________________________ commands.

Accepted Answer

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

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 situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

Accepted Answer

A)  one-to-one relationship 
B)  one-to-many relationship 
C)  many-to-many relationship 
D)  entity relationship 
A)  one-to-one relationship 
B)  one-to-many relationship 
C)  many-to-many relationship 
D)  entity relationship

Question 11

Refer to Exhibit 6-1.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

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a valid SQL command?

Accepted Answer

A)  MODIFY 
B)  INSERT 
C)  ADD 
D)  APPEND 
A)  MODIFY 
B)  INSERT 
C)  ADD 
D)  APPEND

Question 14

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

Accepted Answer

A) True 
 B)False

Question 15

A(n)______________________________ relationship occurs between two different instances of an entity.

Accepted Answer

The answer of A(n)______________________________ relationship occurs between two different instances...

Question 16

______________________________ 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

The answer of ______________________________ is a powerful database language that...

Question 17

A(n)______________________________ a simplified representation of a complex entity or phenomenon.

Accepted Answer

The answer of A(n)______________________________ a simplified representation of a complex...

Question 18

Queries of a database are driven by SELECT commands.

Accepted Answer

A) True 
 B)False

Question 19

The INSERT command is used to add a single tuple to an existing relation.

Accepted Answer

A) True 
 B)False

Question 20

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

Accepted Answer

A)  cardinality constraint 
B)  participation constraint 
C)  economic constraint 
D)  logical constraint 
A)  cardinality constraint 
B)  participation constraint 
C)  economic constraint 
D)  logical constraint

Which of the following is not a proper SQL command for creating database relations?

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

The notation 1:N is used to specify the relationship type of ______________________________.

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

A key attribute is the attribute whose value is:

A(n)______________________________ of an entity is one specific thing of the type defined by the entity.

Which of the following is the entity or agent?

Queries of a database are driven by ______________________________ commands.

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

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

Refer to Exhibit 6-1.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?

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

Which of the following is a valid SQL command?

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

A(n)______________________________ relationship occurs between two different instances of an entity.

______________________________ 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.

A(n)______________________________ a simplified representation of a complex entity or phenomenon.

Queries of a database are driven by SELECT commands.

The INSERT command is used to add a single tuple to an existing relation.

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

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 of the following is not a proper SQL command for creating database relations?

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

The notation 1:N is used to specify the relationship type of ______________________________.

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

A key attribute is the attribute whose value is:

A(n)______________________________ of an entity is one specific thing of the type defined by the entity.

Which of the following is the entity or agent?

Queries of a database are driven by ______________________________ commands.

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

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

Refer to Exhibit 6-1.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?

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

Which of the following is a valid SQL command?

The fundamental requirement for moving toward an event-driven model is the complete integration of data related to an organization's business events.

A(n)______________________________ relationship occurs between two different instances of an entity.

______________________________ 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.

A(n)______________________________ a simplified representation of a complex entity or phenomenon.

Queries of a database are driven by SELECT commands.

The INSERT command is used to add a single tuple to an existing relation.

The constraint that is specifies the degree of minimum participation of one entity in the relationship with the other entity is called:

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