Question 1

A missing value is called a non-null.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

Accepted Answer

A) True 
 B)False

Question 4

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 5

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation,the tuple being referenced must remain intact.

Accepted Answer

A) Cardinality constraint 
B) Participation constraint 
C) Referential integrity 
D) Economic constraint 
A) Cardinality constraint 
B) Participation constraint 
C) Referential integrity 
D) Economic constraint

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A model is a complex representation of a simple entity or phenomenon.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following is a composite 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 10

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

Accepted Answer

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

Question 11

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

Question 12

Relational integrity specifies that for every attribute in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

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

A missing value is called a non-null.

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

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

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

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation,the tuple being referenced must remain intact.

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

A model is a complex representation of a simple entity or phenomenon.

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

Which of the following is a composite attribute?

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

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

Relational integrity specifies that for every attribute in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

Which of the following is a valid SQL command?

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

A missing value is called a non-null.

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

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

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

____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation,the tuple being referenced must remain intact.

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

A model is a complex representation of a simple entity or phenomenon.

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

Which of the following is a composite attribute?

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

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

Relational integrity specifies that for every attribute in one relation that has been specified to allow reference to another relation, the tuple being referenced must remain intact.

Which of the following is a valid SQL command?

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