Your performance was as follows: 

 You took 6 minutes on this assessment from Sat Apr 28 08:34:39 UTC+0800 2007 to Sat Apr 28 08:40:09 UTC+0800 2007. 

 Total score: 100.00 
 
 

 

 1. 
 An E-Commerce system consists of the following components. Which of these same components must be included in a database? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A database must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains. 
A database must include a collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I only
 (b) I, II, and III
 (c) I and II only
 (d) II only  

 Correct answer is  (a)  

 Your score on this question is: 14.29  

 Feedback: 
   Database refers to just the data  
 



--------------------------------------------------------------------------------

 2. 
 In a database system, whose responsibility is it to provide data consistency?  
 

  (a) the DBMS's
 (b) the user's
 (c) the database administrator's
 (d) the application programmer's  

 Correct answer is  (a)  

 Your score on this question is: 14.29  
 

--------------------------------------------------------------------------------

 3. 
 An E-Commerce system consists of the following components. Which of the same components must be included in a database management system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I, II, and III
 (b) I only
 (c) II only
 (d) II and III only  

 Correct answer is  (c)  

 Your score on this question is: 14.29  

 Feedback: 
   A DBMS refers to just the set of general-purpose programs to control data.  
 

--------------------------------------------------------------------------------

 4. 
 An E-Commerce system consists of the following components. Which of these same components will constitute a database system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system. These programs can be easily used to create, maintain, and manipulate data in other domains such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system, constitutes a database system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I and II only
 (b) II only
 (c) I, II, and III
 (d) I only  

 Correct answer is  (c)  

 Your score on this question is: 14.29  

 Feedback: 
   A database system includes the data, the DBMS, and the application-specific programs that operate on that data.  
 

--------------------------------------------------------------------------------

 5. 
 An E-Commerce database contains data about customers, products, orders, system response times, etc. Which of the following can be specified as integrity constraints in an E-Commerce database system? 
No two products can have the same product ID. 
The DBMS response time for all Web requests should be at most 2 seconds. 
A customer order cannot have more than one shipping address. 
 
 

  (a) I and III only
 (b) I only
 (c) I, II, and III
 (d) I and II only  

 Correct answer is  (a)  

 Your score on this question is: 14.29  

 Feedback: 
   The constraints I, II and III specify the application semantics of the data captured in the E-Commerce database. Constraint III, although it seems contrary to common sense, is not something that can be prohibited by the DBMS because the DBMS is general purpose. The response time of the DBMS cannot be enforced by the DBMS. It depends on factors such the processor speed, memory available, etc.  
 

--------------------------------------------------------------------------------

 6. 
 A database is needed for which of the following application scenarios? 
A video store that needs to keep track of data about members, about videos carried by the store, about videos rented by members, as well as data concerning borrow-date, return-date, and payment information. 
In the human resources department of a company, information about employees, their titles, their salaries and sick days, and about vacation days taken by each employee. 
A computer-simulated video game which needs to calculate and display, the physical (x, y) location of each actor in the game, the speed with which they are moving at the current instant, the direction in which they are moving, the action they are performing, the angle at which the game-player is viewing the scene. 
 
 

  (a) I only
 (b) I and III only
 (c) I, II, and III
 (d) I and II only  

 Correct answer is  (d)  

 Your score on this question is: 14.29  
 

--------------------------------------------------------------------------------

 7. 
 The physical storage structure will be _____ to the application programmer in a database approach, and will be _____ to the application programmer in a file system approach.  
 

  (a) hidden, hidden
 (b) visible, visible
 (c) hidden, visible
 (d) visible, hidden  

 Correct answer is  (c)  

 Your score on this question is: 14.29  

 Feedback: 
   The layer of abstraction offered by a DBMS hides the physical storage structure from the application programmer.  
 

--------------------------------------------------------------------------------

 Go to top of assessment.  

 Total score: 100.00 

 ? Copyright 2004 iCarnegie, Inc. All rights reserved 
Your performance was as follows: 

 You took 7 minutes on this assessment from Thu Mar 29 09:33:37 UTC+0800 2007 to Thu Mar 29 09:40:34 UTC+0800 2007. 

 Total score: 100.00 
 
 

 

 1. 
 An E-Commerce system consists of the following components. Which of the same components must be included in a database management system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I only
 (b) II only
 (c) II and III only
 (d) I, II, and III  

 Correct answer is  (b)  

 Your score on this question is: 14.29  

 Feedback: 
   A DBMS refers to just the set of general-purpose programs to control data.  
 



--------------------------------------------------------------------------------

 2. 
 An E-Commerce system consists of the following components. Which of these same components will constitute a database system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system. These programs can be easily used to create, maintain, and manipulate data in other domains such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system, constitutes a database system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I only
 (b) I and II only
 (c) I, II, and III
 (d) II only  

 Correct answer is  (c)  

 Your score on this question is: 14.29  

 Feedback: 
   A database system includes the data, the DBMS, and the application-specific programs that operate on that data.  
 

--------------------------------------------------------------------------------

 3. 
 In a database system, whose responsibility is it to provide data consistency?  
 

  (a) the application programmer's
 (b) the DBMS's
 (c) the user's
 (d) the database administrator's  

 Correct answer is  (b)  

 Your score on this question is: 14.29  
 

--------------------------------------------------------------------------------

 4. 
 An E-Commerce system consists of the following components. Which of these same components must be included in a database? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A database must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains. 
A database must include a collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I and II only
 (b) II only
 (c) I, II, and III
 (d) I only  

 Correct answer is  (d)  

 Your score on this question is: 14.29  

 Feedback: 
   Database refers to just the data  
 

--------------------------------------------------------------------------------

 5. 
 An E-Commerce database contains data about customers, products, orders, system response times, etc. Which of the following can be specified as integrity constraints in an E-Commerce database system? 
No two products can have the same product ID. 
The DBMS response time for all Web requests should be at most 2 seconds. 
A customer order cannot have more than one shipping address. 
 
 

  (a) I only
 (b) I and III only
 (c) I, II, and III
 (d) I and II only  

 Correct answer is  (b)  

 Your score on this question is: 14.29  

 Feedback: 
   The constraints I, II and III specify the application semantics of the data captured in the E-Commerce database. Constraint III, although it seems contrary to common sense, is not something that can be prohibited by the DBMS because the DBMS is general purpose. The response time of the DBMS cannot be enforced by the DBMS. It depends on factors such the processor speed, memory available, etc.  
 

--------------------------------------------------------------------------------

 6. 
 A database is needed for which of the following application scenarios? 
A video store that needs to keep track of data about members, about videos carried by the store, about videos rented by members, as well as data concerning borrow-date, return-date, and payment information. 
In the human resources department of a company, information about employees, their titles, their salaries and sick days, and about vacation days taken by each employee. 
A computer-simulated video game which needs to calculate and display, the physical (x, y) location of each actor in the game, the speed with which they are moving at the current instant, the direction in which they are moving, the action they are performing, the angle at which the game-player is viewing the scene. 
 
 

  (a) I only
 (b) I and III only
 (c) I, II, and III
 (d) I and II only  

 Correct answer is  (d)  

 Your score on this question is: 14.29  
 

--------------------------------------------------------------------------------

 7. 
 The physical storage structure will be _____ to the application programmer in a database approach, and will be _____ to the application programmer in a file system approach.  
 

  (a) hidden, hidden
 (b) visible, hidden
 (c) visible, visible
 (d) hidden, visible  

 Correct answer is  (d)  

 Your score on this question is: 14.29  

 Feedback: 
   The layer of abstraction offered by a DBMS hides the physical storage structure from the application programmer.  
 

--------------------------------------------------------------------------------

 Go to top of assessment.  

 Total score: 100.00 

 ? Copyright 2004 iCarnegie, Inc. All rights reserved.  
Your performance was as follows: 

 You took 16 minutes on this assessment from Thu Mar 29 08:26:15 UTC+0800 2007 to Thu Mar 29 08:42:05 UTC+0800 2007. 

 Total score: 71.43 
 
 

 

 1. 
 An E-Commerce system consists of the following components. Which of the same components must be included in a database management system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) II and III only
 (b) I only
 (c) II only
 (d) I, II, and III  

 Correct answer is  (c)  

 Your score on this question is: 14.29  

 Feedback: 
   A DBMS refers to just the set of general-purpose programs to control data.  
 



--------------------------------------------------------------------------------

 2. 
 An E-Commerce system consists of the following components. Which of these same components will constitute a database system? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system. These programs can be easily used to create, maintain, and manipulate data in other domains such as in a library information system. 
A collection of programs that operate on the data, but are specific to the E-commerce system, constitutes a database system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I only
 (b) I, II, and III
 (c) I and II only
 (d) II only  

 Correct answer is  (b)  

 Your score on this question is: 14.29  

 Feedback: 
   A database system includes the data, the DBMS, and the application-specific programs that operate on that data.  
 

--------------------------------------------------------------------------------

 3. 
 In a database system, whose responsibility is it to provide data consistency?  
 

  (a) the DBMS's
 (b) the user's
 (c) the application programmer's
 (d) the database administrator's  

 Correct answer is  (a)  

 Your score on this question is: 14.29  
 

--------------------------------------------------------------------------------

 4. 
 An E-Commerce system consists of the following components. Which of these same components must be included in a database? 
The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc. 
A database must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains. 
A database must include a collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. 
 
 

  (a) I and II only
 (b) I, II, and III
 (c) II only
 (d) I only  

 Correct answer is  (d)  

 Your score on this question is: 14.29  

 Feedback: 
   Database refers to just the data  
 

--------------------------------------------------------------------------------

 5. 
 An E-Commerce database contains data about customers, products, orders, system response times, etc. Which of the following can be specified as integrity constraints in an E-Commerce database system? 
No two products can have the same product ID. 
The DBMS response time for all Web requests should be at most 2 seconds. 
A customer order cannot have more than one shipping address. 
 
 

  (a) I and III only
 (b) I, II, and III
 (c) I only
 (d) I and II only  

 Correct answer is  (a)  

 Your score on this question is: 0.00  

 Feedback: 
   The constraints I, II and III specify the application semantics of the data captured in the E-Commerce database. Constraint III, although it seems contrary to common sense, is not something that can be prohibited by the DBMS because the DBMS is general purpose. The response time of the DBMS cannot be enforced by the DBMS. It depends on factors such the processor speed, memory available, etc.  
 

--------------------------------------------------------------------------------

 6. 
 A database is needed for which of the following application scenarios? 
A video store that needs to keep track of data about members, about videos carried by the store, about videos rented by members, as well as data concerning borrow-date, return-date, and payment information. 
In the human resources department of a company, information about employees, their titles, their salaries and sick days, and about vacation days taken by each employee. 
A computer-simulated video game which needs to calculate and display, the physical (x, y) location of each actor in the game, the speed with which they are moving at the current instant, the direction in which they are moving, the action they are performing, the angle at which the game-player is viewing the scene. 
 
 

  (a) I and II only
 (b) I only
 (c) I and III only
 (d) I, II, and III  

 Correct answer is  (a)  

 Your score on this question is: 0.00  

 Feedback: 
   (d) Unrelated data such as site downtimes, price of goods, employees, etc do not constitute a database.