Experiencing MIS 4th Canadian Edition by Kroenke - Test Bank

Experiencing MIS 4th Canadian Edition by Kroenke – Test Bank

 

Instant Download – Complete Test Bank With Answers

 

 

Sample Questions Are Posted Below

 

Experiencing MIS, Cdn. Ed., 4e (Kroenke)

Chapter 5  Database and Content Management

 

1) A database is a self-describing collection of integrated records.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

2) Special data called structured data describes the structure of the database.

Answer:  FALSE

Diff: 1    Type: TF    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

3) Metadata is data about data.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

4) The name of the field, its datatype, and description are examples of metadata.

Answer:  TRUE

Diff: 2    Type: TF    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

5) A DBMS is software that helps manage the operating system.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 149

Topic:  Q5

Skill:  RECALL

 

6) A database application system consists of forms, reports, and database programs.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

7) Most large companies develop their own DBMSs.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

 

8) IBM makes a DBMS called SQL-Server.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

9) MySQL is an open source DBMS product.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

10) Oracle makes a DBMS packaged called DB2.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

11) SQL Server is an open-source DBMS package that is free for most database applications.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

12) A DBMS and a database are two different things.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

13) A DBMS is a collection of tables, relationships, and metadata.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

14) SQL is an international standard language for processing a database.

Answer:  TRUE

Diff: 2    Type: TF    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

15) SQL stands for “Standard Query Language.”

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

16) SQL can be used to add a new column to a table.

Answer:  TRUE

Diff: 2    Type: TF    Page Ref: 144

Topic:  Q5

Skill:  APPLIED

 

17) A database can have one and only one application.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 145

Topic:  Q6

Skill:  RECALL

18) A database application can have one or more users.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 145

Topic:  Q6

Skill:  RECALL

 

19) A database form translates inputted changes into a SQL query in order for the database to process them.

Answer:  TRUE

Diff: 3    Type: TF    Page Ref: 144

Topic:  Q5

Skill:  APPLIED

 

20) Many people find it easier to store data using a spreadsheet than a database.

Answer:  TRUE

Diff: 1    Type: TF    Page Ref: 138

Topic:  Q3

Skill:  RECALL

 

21) The only remaining personal DBMS today is Paradox.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 150

Topic:  Q7

Skill:  RECALL

 

22) A spreadsheet is just another type of relational database.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 141

Topic:  Q4

Skill:  APPLIED

 

 

23) Personal DBMS can handle over 100 users.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 150

Topic:  Q7

Skill:  RECALL

 

24) Spreadsheets usually track only one “theme,” but databases usually involved more than one “theme.”

Answer:  TRUE

Diff: 2    Type: TF    Page Ref: 138

Topic:  Q3

Skill:  RECALL

 

25) Employees usually insert content directly into a company’s website without a controlling editor.

Answer:  FALSE

Diff: 2    Type: TF    Page Ref: 137

Topic:  Q2

Skill:  APPLIED

26) ________ is a form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography.

1. A) Innovative design
2. B) Intellectual property
3. C) Creative writing
4. D) Programming
5. E) Digital design

Answer:  B

Diff: 1    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

 

27) What does CMS stand for?

1. A) Content Management System
2. B) Copy Management System
3. C) Customer Management System
4. D) Customer Manipulation System
5. E) Content Manipulation System

Answer:  A

Diff: 1    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

 

28) A ________ is a self-describing collection of integrated records.

1. A) column
2. B) table
3. C) row
4. D) field
5. E) database

Answer:  E

Diff: 1    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

29) A group of similar rows or records is called a

1. A) database.
2. B) table.
3. C) instance.
4. D) attribute.
5. E) column.

Answer:  B

Diff: 1    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

30) ________ describe(s) the structure of the database.

1. A) Metadata
2. B) Tables
3. C) Columns
4. D) A relationship diagram
5. E) Fields

Answer:  A

Diff: 2    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

31) A database consists of

1. A) rows, tables, instructions.
2. B) metadata, keyboard, relationships.
3. C) tables, instructions, relationships.
4. D) relationships, rows tables.
5. E) CPU, tables, rows.

Answer:  D

Diff: 3    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

 

32) A ________ is a column or group of columns that identifies a unique row in a table.

1. A) record
2. B) relationship
3. C) row
4. D) key
5. E) field

Answer:  D

Diff: 2    Type: MC    Page Ref: 140

Topic:  Q4

Skill:  RECALL

 

33) ________ are keys in a different table from the one in which they reside.

1. A) Secondary keys
2. B) Simple keys
3. C) Special keys
4. D) Primary keys
5. E) Foreign keys

Answer:  E

Diff: 3    Type: MC    Page Ref: 141

Topic:  Q4

Skill:  RECALL

34) ________ is a formal name for a table.

1. A) File
2. B) Database
3. C) Collection
4. D) Metadata
5. E) Relation

Answer:  E

Diff: 2    Type: MC    Page Ref: 141

Topic:  Q4

Skill:  RECALL

 

35) A relational database refers to

1. A) databases that have related objects related by similar attributes.
2. B) a set of tables that contains similar content.
3. C) a set of files that have similar names.
4. D) databases that carry data in the form of tables with individual primary keys.
5. E) databases that carry data in the form of tables and that represent relationships using foreign keys.

Answer:  E

Diff: 2    Type: MC    Page Ref: 141

Topic:  Q5

Skill:  RECALL

 

 

36) Which of the following are NOT considered to be metadata?

1. A) Field properties
2. B) Description
3. C) File name
4. D) Data type
5. E) Field name

Answer:  C

Diff: 2    Type: MC    Page Ref: 141

Topic:  Q4

Skill:  APPLIED

 

37) ________ consists of forms, formatted reports, queries, and application programs.

1. A) A database application
2. B) A DBMS program
3. C) A Visual Basic application
4. D) A database
5. E) A Windows application

Answer:  A

Diff: 1    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  RECALL

38) Which of the following is a personal DBMS product?

1. A) Microsoft Access
2. B) Oracle
3. C) SQL.
4. D) Microsoft SQL Server
5. E) IBM DB2.

Answer:  A

Diff: 1    Type: MC    Page Ref: 150

Topic:  Q7

Skill:  RECALL

 

39) Which of the following is an international standard language for processing a database?

1. A) VBA
2. B) C++
3. C) Visual Basic
4. D) Standard Query Language
5. E) Structured Query Language

Answer:  E

Diff: 2    Type: MC    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

 

40) A database applications is a collection of programs, forms, reports and

1. A) Queries.
2. B) Tables.
3. C) Metadata.
4. D) Keys.
5. E) Printers.

Answer:  A

Diff: 2    Type: MC    Page Ref: 145

Topic:  Q6

Skill:  RECALL

 

41) ________ are used to display formatted data and to generate paper copies of the data.

1. A) Tables
2. B) Forms
3. C) Views
4. D) Reports
5. E) Queries

Answer:  D

Diff: 2    Type: MC    Page Ref: 147

Topic:  Q6

Skill:  RECALL

42) Which of the following techniques is used to resolve the lost-update problem?

1. A) Preemptive updating
2. B) Sharing
3. C) Task switching
4. D) Locking
5. E) Multitasking

Answer:  D

Diff: 2    Type: MC    Page Ref: 149

Topic:  Q6

Skill:  RECALL

 

43) Which of the following is a file extension name of a graphics file?

1. A) .wav
2. B) .mov
3. C) .mpg
4. D) .pdf
5. E) .bmp

Answer:  E

Diff: 2    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

 

 

44) Which of the following is a file extension name of an audio file?

1. A) .pdf
2. B) .wav
3. C) .mov
4. D) .bmp
5. E) .mpg

Answer:  B

Diff: 1    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

 

45) Which of the following is a file extension name of a video file?

1. A) .wav
2. B) .mpg
3. C) .doc
4. D) .pdf
5. E) .bmp

Answer:  B

Diff: 1    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

46) Which of the following is a file extension name of a word-processing document?

1. A) .mpg
2. B) .docx
3. C) .bmp
4. D) .xlsx
5. E) .wav

Answer:  B

Diff: 1    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

 

47) Which of the following are NOT users of a content management system?

1. A) Customers
2. B) Web masters
3. C) Copy editors
4. D) Managers
5. E) Employees

Answer:  A

Diff: 3    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

 

48) The company that digitized the Oxford English Dictionary is called

1. A) IBM.
2. B) Nortel.
3. C) Microsoft.
4. D) Open Text.
5. E) Research in Motion.

Answer:  D

Diff: 1    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

49) Columns are also called

1. A) rows.
2. B) databases.
3. C) fields.
4. D) relations.
5. E) tables.

Answer:  C

Diff: 1    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

50) In a relational database, a collection of related records is a(n)

1. A) row.
2. B) attribute.
3. C) table.
4. D) column.
5. E) field.

Answer:  C

Diff: 2    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

51) A collection of records in a relational database can be called a

1. A) matrix.
2. B) column.
3. C) field.
4. D) row.
5. E) relation.

Answer:  E

Diff: 2    Type: MC    Page Ref: 141

Topic:  Q4

Skill:  RECALL

 

 

52) The company Open Text provides companies with “cloud based”

1. A) sales management software.
2. B) document management software.
3. C) Microsoft Office.
4. D) data storage.
5. E) accounting software.

Answer:  B

Diff: 3    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

53) Many users prefer to avoid database applications altogether and simply store their data in a(n)

1. A) mattress.
2. B) file.
3. C) old can.
4. D) spreadsheet.
5. E) encrypted table.

Answer:  D

Diff: 2    Type: MC    Page Ref: 138

Topic:  Q3

Skill:  RECALL

54) ________ software assists in creating, maintaining, and manipulating databases.

1. A) DMS
2. B) KMS
3. C) DBMS
4. D) MIS
5. E) DBM

Answer:  C

Diff: 3    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

55) Content management is indexing the right information, processing, sorting it, and then

1. A) getting it printed when needed.
2. B) hiring good programmers.
3. C) editing right employee input.
4. D) making it available in the right format at the right time.
5. E) giving it to employees with “strong” passwords.

Answer:  D

Diff: 3    Type: MC    Page Ref: 136

Topic:  Q2

Skill:  RECALL

 

 

56) ________ is a record in a relational database.

1. A) A field
2. B) A table
3. C) A column
4. D) A row
5. E) A key

Answer:  D

Diff: 2    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

57) ________ is an example of a personal DBMS.

1. A) Access
2. B) SQL Server
3. C) DB2
4. D) SQL
5. E) Oracle

Answer:  A

Diff: 2    Type: MC    Page Ref: 139

Topic:  Q4

Skill:  RECALL

58) ________ is an example of an enterprise DBMS.

1. A) Access
2. B) DB2
3. C) FoxPro
4. D) Quattro Pro
5. E) Paradox

Answer:  B

Diff: 2    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

59) MySQL is popular because it is a(n) ________ DBMS.

1. A) open-source
2. B) work-group
3. C) personal
4. D) enterprise
5. E) powerful

Answer:  A

Diff: 2    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

 

60) One example of a DBMS is

1. A) SQL Server.
2. B) .NET.
3. C) Java.
4. D) OEM.
5. E) Excel.

Answer:  A

Diff: 2    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

61) SQL is a

1. A) query language.
2. B) database system.
3. C) 3GL.
4. D) 2GL.
5. E) programming language.

Answer:  A

Diff: 2    Type: MC    Page Ref: 144

Topic:  Q5

Skill:  RECALL

62) A(n) ________ DBMS is designed to process large organizational and workgroup databases.

1. A) object-oriented
2. B) network
3. C) relational
4. D) personal
5. E) enterprise

Answer:  E

Diff: 2    Type: MC    Page Ref: 149

Topic:  Q7

Skill:  RECALL

 

63) SQL stands for

1. A) Structured Query Language.
2. B) Standard Query Language.
3. C) Structured Question Language.
4. D) Simple Query Language.
5. E) Standard Question Language.

 

Answer:  A

Diff: 2    Type: MC    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

 

64) ________ is an international standard language for processing a database.

1. A) VBA
2. B) SQL
3. C) Java
4. D) .NET
5. E) MySQL

Answer:  B

Diff: 2    Type: MC    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

65) The ________ problem is unique to a multi-user database environment.

1. A) redundancy
2. B) lost-update
3. C) locked file
4. D) security
5. E) data integrity

Answer:  B

Diff: 3    Type: MC    Page Ref: 149

Topic:  Q6

Skill:  RECALL

66) Users process data in the database using

1. A) files.
2. B) logic.
3. C) programs.
4. D) reports.
5. E) queries.

Answer:  E

Diff: 3    Type: MC    Page Ref: 143

Topic:  Q5

Skill:  APPLIED

 

67) The name of the field, the data type, and number of characters allowed are examples of

1. A) attributes.
2. B) characters.
3. C) content.
4. D) overhead.
5. E) metadata.

Answer:  E

Diff: 2    Type: MC    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

 

68) ________ describe(s) the structure of a database.

1. A) Logic
2. B) Metadata
3. C) Models
4. D) Protocols
5. E) Content

Answer:  B

Diff: 2    Type: MC    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

69) In today’s business world content is just not about collection and distribution. It is also about

1. A) the accuracy of the content.
2. B) the organization of the content.
3. C) the content management system.
4. D) the relevance of the content.
5. E) presenting the content appropriately for the audience.

Answer:  E

Diff: 2    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

70) In the early days of corporate websites, employees were allowed to add content directly to the sites. Today this practice is not acceptable because

1. A) of the lack of consistency in both look and accuracy of the web site.
2. B) employees lack the skills to add content to web sites due to the greater sophistication of the software used today for corporate web sites.
3. C) companies with web sites now have copy editors to prepare web site content.
4. D) most companies use content management systems today.
5. E) most web sites are driven by database management systems.

Answer:  A

Diff: 3    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

71) Modern content management systems

1. A) seek out documents located across an organization and actively manage access to the content.
2. B) manage only media files.
3. C) archive documents.
4. D) organize content for corporate web sites.
5. E) manage all aspects of corporate data.

Answer:  A

Diff: 3    Type: MC    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

 

72) Content is closely related to

1. A) intellectual property.
2. B) words.
3. C) software.
4. D) property in the broadest sense.
5. E) organized materials.

Answer:  A

Diff: 2    Type: MC    Page Ref: 136

Topic:  Q1

Skill:  RECALL

 

73) One of the DMBS administrative functions includes

1. A) building the database.
2. B) backing up the database.
3. C) collecting user requirements for the database.
4. D) planning the database.
5. E) entering new data into the database.

Answer:  B

Diff: 3    Type: MC    Page Ref: 145

Topic:  Q5

Skill:  RECALL

74) A database differs from a spreadsheet by

1. A) involving lists of a single theme.
2. B) having only columns.
3. C) having lists of multiple rows and columns.
4. D) involving lists of multiple themes.
5. E) having only rows.

Answer:  D

Diff: 3    Type: MC    Page Ref: 138

Topic:  Q3

Skill:  APPLIED

 

75) In databases, names of clients can be troublesome since they may not be

1. A) relevant.
2. B) simple.
3. C) reconciled.
4. D) unique.
5. E) normalized.

Answer:  D

Diff: 3    Type: MC    Page Ref: 146

Topic:  Q6

Skill:  RECALL

 

 

76) In a relational database application, a(n) ________ key is used to link one table with another.

1. A) primary
2. B) index
3. C) secondary
4. D) foreign
5. E) composite

Answer:  D

Diff: 2    Type: MC    Page Ref: 141

Topic:  Q4

Skill:  RECALL

 

77) Some employees are frustrated with database applications or are unwilling to share their data, so they prefer to store their data in a(n) ________ instead of a database application.

Answer:  spreadsheet

Diff: 2    Type: SA    Page Ref: 138

Topic:  Q3

Skill:  RECALL

 

78) If a user stores their data in a spreadsheet, it is unavailable to other users unless it is stored in the company’s ________.

Answer:  CMS

Diff: 3    Type: SA    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

79) ________ describes the data in a database.

Answer:  metadata

Diff: 2    Type: SA    Page Ref: 142

Topic:  Q4

Skill:  RECALL

80) ________ DBMS like DB2 are designed for large, corporate database applications.

Answer:  Enterprise

Diff: 1    Type: SA    Page Ref: 149

Topic:  Q7

Skill:  RECALL

 

81) For applications that need to process databases over the Internet, the application serves as an intermediary between the ________ and the database.

Answer:  web server

Diff: 2    Type: SA    Page Ref: 148

Topic:  Q6

Skill:  RECALL

 

 

82) Characters of information are represented by individual ________.

Answer:  bytes

Diff: 1    Type: SA    Page Ref: 140

Topic:  Q4

Skill:  RECALL

 

83) A(n) ________ is software that is used to create, process, and administer a database.

Answer:  DBMS

Diff: 2    Type: SA    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

84) A(n) ________ is another name for a table in relational database terms.

Answer:  relation

Diff: 2    Type: SA    Page Ref: 141

Topic:  Q4

Skill:  RECALL

 

85) ________ is a query language that is portable between all relational DBMSs.

Answer:  SQL

Diff: 2    Type: SA    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

86) ________ database products like MS Access are designed for individual users or small workgroups of no more than 15 users.

Answer:  Personal

Diff: 2    Type: SA    Page Ref: 150

Topic:  Q7

Skill:  RECALL

 

87) If your database produces inaccurate results that don’t seem to have a cause, your database may be having ________ problems.

Answer:  lost-update

Diff: 3    Type: SA    Page Ref: 149

Topic:  Q6

Skill:  RECALL

88) A web ________ helps to enable a company to standardize the look and feel of a web site.

Answer:  CMS

Diff: 2    Type: SA    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

 

89) A collection of columns or fields is called rows or ________.

Answer:  records

Diff: 1    Type: SA    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

90) A group of similar rows or records is called a file or a(n) ________.

Answer:  table

Diff: 1    Type: SA    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

91) Bytes are grouped into columns or ________.

Answer:  fields

Diff: 1    Type: SA    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

92) A ________ is a self-describing collection of integrated records.

Answer:  database

Diff: 1    Type: SA    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

93) A database is a collection of tables, ________, and metadata.

Answer:  relationships

Diff: 2    Type: SA    Page Ref: 139

Topic:  Q4

Skill:  RECALL

 

94) Data type and description are examples of ________.

Answer:  metadata

Diff: 2    Type: SA    Page Ref: 142

Topic:  Q4

Skill:  RECALL

 

95) The purpose of a database is to keep track of things that involve more than one ________.

Answer:  theme

Diff: 2    Type: SA    Page Ref: 138

Topic:  Q3

Skill:  RECALL

 

96) A(n) ________ is a special name for a question that is asked in a database application.

Answer:  query

Diff: 2    Type: SA    Page Ref: 144

Topic:  Q5

Skill:  RECALL

97) A database is a collection of tables, metadata, and ________.

Answer:  relationships

Diff: 2    Type: SA    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

98) Setting up the database security is a part of database ________.

Answer:  administration

Diff: 2    Type: SA    Page Ref: 145

Topic:  Q5

Skill:  RECALL

 

99) When a database form is processed to add a new record to a table, the DBMS converts the contents of the form into a(n) ________ statement.

Answer:  SQL

Diff: 3    Type: SA    Page Ref: 144

Topic:  Q5

Skill:  RECALL

 

100) To prevent the lost-update problem, the DBMS should have some type of ________ mechanism.

Answer:  locking

Diff: 3    Type: SA    Page Ref: 149

Topic:  Q6

Skill:  RECALL

 

101) Forms and reports are usually part of a database ________.

Answer:  application

Diff: 2    Type: SA    Page Ref: 147

Topic:  Q6

Skill:  RECALL

 

102) What are the differences between a database and a spreadsheet?

Answer:  A spreadsheet table is organized into rows and columns and is typically used to track related data across two dimensions (e.g. student grades on course assignments), whereas a database is a three-dimensional storage structure—think of a series of two-dimensional tables linked together (e.g. course scheduling for faculty and students). A database has metadata to structure the data of the database. Spreadsheets are simple to set up and understand. However, a database is preferable in cases where the user needs to keep track of three or more things—customers, sales, suppliers, and other transactions—and databases are better when data involves more than one topic or theme. Spreadsheets work best when the data involves just one topic or theme.

Diff: 3    Type: ES    Page Ref: 138

Topic:  Q3

Skill:  APPLIED

 

 

103) Explain the difference between a primary key and a foreign key.

Answer:  A primary key is a column or group of columns that has a unique value for each row in a table. Foreign keys are primary keys from a different table than the one in which they reside.

Diff: 3    Type: ES    Page Ref: 141

Topic:  Q4

Skill:  APPLIED

104) What is a database application?

Answer:  A database application consists of forms, formatted reports, queries, and application programs. Each of these in turn calls on the database management system to process the database tables.

Diff: 2    Type: ES    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

105) Discuss the challenges for a multiuser database application.

Answer:  Multiple users may try to update the same record at the same time, which can make for a lost-update problem. To prevent this problem, some type of locking must be used to co-ordinate the activities of users.

Diff: 3    Type: ES    Page Ref: 149

Topic:  Q6

Skill:  APPLIED

 

106) Describe the use of a content management system.

Answer:  When an employee wants to place some content on the organizations web site he or she will access the content management system. The web CMS is usually located on the company’s web site server. The employee typically loads the raw content into the CMS. Copy editors then review the document and make necessary changes. They then pass the content on to layout editors, who prepare how the content will be presented. The content and presentation are stored with the help of a DBMS. The manager in charge of the web site will then review the content and presentation and publish the work to the public web site.

Diff: 3    Type: ES    Page Ref: 137

Topic:  Q2

Skill:  RECALL

 

107) Name three different DBMS packages available today.

Answer:  IBM DB2, Oracle, Microsoft SQL Server, MySQL.

Diff: 1    Type: ES    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

108) What is the difference between a DBMS and a database?

Answer:  A DBMS is a software program that helps to build, control and maintain a database; a database is a collection of tables, relationships, and metadata.

Diff: 2    Type: ES    Page Ref: 143

Topic:  Q5

Skill:  RECALL

 

109) What is metadata? Give an example. Why is it important?

Answer:  Metadata is data “about” data. Metadata describes the structure of the database and its contents. Examples include the names and descriptions of the fields, the various aliases for them throughout the database, the dates that they were created and modified, the data types, the field widths, and whether it’s a key or indexed. Metadata is important because it helps the DBMS to automate some data management tasks. However, as the amount of metadata grows it takes up more memory and must be managed itself.

Diff: 3    Type: ES    Page Ref: 142

Topic:  Q4

Skill:  APPLIED

110) What is a DBMS? What are the advantages and disadvantages of using a DBMS?

Answer:  DBMS stands for Database Management System. There are many different kinds but the relational DBMS (RDBMS) is by far the most popular today. A DBMS is useful because it helps database developers create tables and relationships, manage the metadata, process the database with queries, and administer the user access and security. It standardizes data access in the organization and simplifies data maintenance. Data can be quite complex and quite expensive to manage. If the centralized data store is not archived and backed up properly, the impact of lost corporate data will be more severe than in an older situation where there were a lot of redundant databases.

Diff: 3    Type: ES    Page Ref: 143

Topic:  Q5

Skill:  APPLIED

 

111) It is often said that much of corporate data resides in various unrelated spreadsheet files or, “spreadsheet silos.” What are these concepts and why are they a problem?

Answer:  Millions of business users rely daily on spreadsheets for business intelligence (BI) functions such as data manipulation, data visualization, presentation graphics, forecasting, and so on. For many users, spreadsheets are a form of reporting, and pivot tables a type of data analysis. When users modify the data in spreadsheets and add new data, soon the data in the spreadsheet looks nothing like the source data. This creates problems for sharing the data with others and it generates inconsistent versions of the data in the organization.

Diff: 3    Type: ES    Page Ref: 138

Topic:  Q3

Skill:  APPLIED

 

 

112) What is meant by a relational database? What are the advantages of relational database technology?

Answer:  Relational databases store data in tables and use shared fields (primary and foreign keys) in order to show the relationships between tables. Relational databases are based on strong fundamental theory and limit the amount of data redundancy and data errors. A relational database can enforce data and referential integrity constraints. They are the most popular type of DBMS available because they capture all the possible types of relationships and they are fairly easy to learn and implement. There are many skilled IT specialists in this field so it is fairly easy to find support for this technology.

Diff: 3    Type: ES    Page Ref: 141

Topic:  Q4

Skill:  APPLIED

113) What is SQL? Why is it so important for DBMS? Give an example.

Answer:  SQL stands for “Structured Query Language,” and this is the standard query language for all DBMSs. It is a 4GL so it is fairly English-like and easy to learn. A knowledge of generic SQL can be transferred to any of the popular DBMSs easily. There are SQL commands for creating tables, manipulating data, and for maintaining the data. A standard format for a data manipulation type of query is:

SELECT field 1, field 2, ….field n

FROM table 1, table 2, ….table m

WHERE condition 1, condition 2, ….condition p is true

So a typical query might be:

SELECT CustomerNumber, CustomerName

FROM Customer

WHERE Province = ‘AB’

Diff: 3    Type: ES    Page Ref: 144

Topic:  Q5

Skill:  APPLIED

 

114) What is the difference between a personal DBMS and an enterprise DBMS? Give an example of each.

Answer:  A personal DBMS is designed for smaller, simpler database applications. It can be used for personal or small workgroup applications with fewer than 100 users, usually less than 15. Most of the time a personal DBMS is used by a single user for a stand-alone application. The most popular example is MS Access. Enterprise DBMSs like DB2 from IBM process large organizational or workgroup database applications. They may have thousands of users with multiple applications distributed across various networks. They have more sophisticated network and security capabilities than a personal DBMS.

Diff: 3    Type: ES    Page Ref: 149-150

Topic:  Q7

Skill:  APPLIED

 

 

115) If you are a database administrator and you uncover some suspicious transactions in one of your database applications, what should you do?

Answer:  Everyone should be aware that fraud does happen, it is more likely to be due to an employee than an outsider. The first thing to be aware of is you must not speak casually about this situation with anyone. It is important to begin carefully to collect as much data as possible on the situation and document all the names and dates. As soon as possible you should speak with a member of the senior management, possibly a CIO or CFO since the CFO is usually in charge of financial controls. If the matter continues for very long and looks complicated, you should consider contacting your own lawyer to protect your own interests.

Diff: 3    Type: ES    Page Ref: 145

Topic:  Q5

Skill:  APPLIED