Question 1

Which of the following is not a construct in a relational database?

Accepted Answer

A) Tables 
B) Attributes 
C) Records 
D) Forms

Question 2

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

Accepted Answer

A) A decision support system. 
B) A Structured Data system. 
C) A Microsoft database. 
D) An enterprise resource planning system.

Question 3

What kind data model is most commonly used as a basis for today's enterprise systems?

Accepted Answer

A) The hierarchical mode. 
B) The network model. 
C) The relational model. 
D) None of these choices is correct.

Question 4

SQL is based on relational algebra and allows a user to query and update the database.

Accepted Answer

A) True 
 B)False

Question 5

Each attribute in a table can have several names.

Accepted Answer

A) True 
 B)False

Question 6

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Accepted Answer

A) True 
 B)False

Question 7

Classes could be grouped into Resources (R),Entities (E),and Assets (A)in data modeling.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not a likely module of an Enterprise Reporting System (ERP)?

Accepted Answer

A) Financial Accounting. 
B) Cloud based computing. 
C) Payroll. 
D) Sales and Distribution.

Question 9

Which of the following about cloud computing is incorrect?

Accepted Answer

A) Cloud computing is Internet-based computing where shared resources,software,and information are provided to firms on demand. 
B) Cloud computing can easily host enterprise system applications. 
C) If the internet connection goes down the system will not function. 
D) Data stored in a cloud computing system is always secure.

Question 10

Which of the following is not accurate?

Accepted Answer

A) Columns in a table are called fields. 
B) Fields represent attributes of a class. 
C) Records represent attributes of a table. 
D) Rows in a table are called records.

Question 11

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is not one of the advantages relational data models have over other data models?

Accepted Answer

A) Exclusively uses parent/child relationships. 
B) Increased flexibility and scalability. 
C) Simplicity. 
D) Reduced information redundancy.

Question 13

What kind of data model has the greatest ability to scale?

Accepted Answer

A) Hierarchical data model. 
B) Network data model. 
C) Relational data model. 
D) All of the choices are correct.

Question 14

The "Where" SQL clause can be used to link two tables.

Accepted Answer

A) True 
 B)False

Question 15

While hierarchical and network data models require relationships to be formed at the database creation,relational data models allow relationships to be created and updated as needed.

Accepted Answer

A) True 
 B)False

Question 16

Using the following table what will result from the SQL command "SELECT Item SKU,Price"?

Accepted Answer

A) All rows but only the 1st and 2nd column. 
B) All rows but only columns with numerical data. 
C) All data in the 1st and 2nd columns for the first and last row. 
D) All data in the table.

Question 17

Which of the following best describes cloud computing?

Accepted Answer

A) Internet based computing where an ERP system is shared amongst multiple firms. 
B) Internet based computing where shared resources,software and information are provided to firms on demand. 
C) Internet based software which is used to run SQL queries. 
D) Internet based software that helps monitor the security of a firm's resources.

Question 18

Using the following table what will result from the SQL command "SELECT *,WHERE [Price] = $5"?

Accepted Answer

A) All columns,row 1. 
B) Price column,row 1. 
C) All columns,rows 1 & 3. 
D) Price column,row 3.

Question 19

Access offers modules,which are defined by users to automate processes like opening a specific form.

Accepted Answer

A) True 
 B)False

Question 20

Access is a simple database management system that can be used to run databases for individuals and small firms.

Accepted Answer

A) True 
 B)False

Exam 4: Relational Databases and Enterprise Systems

Which of the following is not a construct in a relational database?

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

What kind data model is most commonly used as a basis for today's enterprise systems?

SQL is based on relational algebra and allows a user to query and update the database.

Each attribute in a table can have several names.

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Classes could be grouped into Resources (R),Entities (E),and Assets (A)in data modeling.

Which of the following is not a likely module of an Enterprise Reporting System (ERP) ?

Which of the following about cloud computing is incorrect?

Which of the following is not accurate?

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Which of the following is not one of the advantages relational data models have over other data models?

What kind of data model has the greatest ability to scale?

The "Where" SQL clause can be used to link two tables.

While hierarchical and network data models require relationships to be formed at the database creation,relational data models allow relationships to be created and updated as needed.

Using the following table what will result from the SQL command "SELECT Item SKU,Price"?

Which of the following best describes cloud computing?

Using the following table what will result from the SQL command "SELECT *,WHERE [Price] = $5"?

Access offers modules,which are defined by users to automate processes like opening a specific form.

Access is a simple database management system that can be used to run databases for individuals and small firms.