Deck 7: Database and Content Management

Question 1

The name of the field, its data type, and description are examples of metadata.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

Oracle makes a DBMS packaged called DB2.

Answer 3

False

Question 4

Most large companies develop their own DBMSs.

Question 5

IBM makes a DBMS called SQL Server.

Question 6

A database application consists of forms, reports, and application programs.

Question 7

MySQL is an open-source DBMS product.

Question 8

A DBMS is software that helps manage the operating system.

Question 9

A DBMS and a database are two different things.

Question 10

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

Question 11

A database can have one and only one application.

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

SQL is an international standard language for processing a database.

Question 17

SQL stands for "Standard Query Language."

Question 18

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

Question 19

Metadata is data about data.

Question 20

A database application can have one or more users.

Question 21

Which of the following are NOT considered to be metadata?

A) Field properties
B) Description
C) File name
D) Data type
E) Field name

Question 22

________ is a formal name for a table.

A) File
B) Database
C) Collection
D) Metadata
E) Relation

Question 23

Employees usually insert content directly into a company's website without a controlling editor.

Question 24

A spreadsheet is just another type of relational database.

Question 25

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

A) VBA
B) C++
C) Visual Basic
D) Standard Query Language
E) Structured Query Language

Question 26

Spreadsheets usually track only one "theme," but databases usually involved more than one "theme."

Question 27

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

A) column
B) table
C) row
D) field
E) database

Question 28

The only remaining personal DBMS today is Paradox.

Question 29

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

A) Secondary keys
B) Simple keys
C) Special keys
D) Primary keys
E) Foreign keys

Question 30

________ consists of forms, reports, queries, and application programs.

A) A database application
B) A DBMS program
C) A Visual Basic application
D) A database
E) A Windows application

Question 31

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

A) record
B) relationship
C) row
D) key
E) field

Question 32

Personal DBMS can handle over 100 users.

Question 33

A relational database refers to

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

Question 34

A database consists of

A) rows, tables, instructions.
B) metadata, keyboard, relationships.
C) tables, instructions, relationships.
D) relationships, rows tables.
E) CPU, tables, rows.

Question 35

A group of similar rows or records is called a

A) database.
B) table.
C) instance.
D) attribute.
E) column.

Question 36

What does CMS stand for?

A) Content management system
B) Copy management system
C) Customer management system
D) Customer manipulation system
E) Content manipulation system

Question 37

A database application is a collection of programs, forms, reports, and

A) queries.
B) tables.
C) metadata.
D) keys.
E) printers.

Question 38

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

A) Innovative design
B) Intellectual property
C) Creative writing
D) Programming
E) Digital design

Question 39

Which of the following is a personal DBMS product?

A) Microsoft Access
B) Oracle
C) SQL
D) Microsoft SQL Server
E) IBM DB2

Question 40

________ describe(s) the structure of the database.

A) Metadata
B) Tables
C) Columns
D) A relationship diagram
E) Fields

Question 41

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

A) Preemptive updating
B) Sharing
C) Task switching
D) Locking
E) Multitasking

Question 42

The company that digitized the Oxford English Dictionary is called

A) IBM.
B) Nortel.
C) Microsoft.
D) OpenText.
E) Research In Motion.

Question 43

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

A) open-source
B) work-group
C) personal
D) enterprise
E) powerful

Question 44

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

A) DMS
B) KMS
C) DBMS
D) MIS
E) DBM

Question 45

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

A) Tables
B) Forms
C) Views
D) Reports
E) Queries

Question 46

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

A) )mpg
B) )docx
C) )bmp
D) )xlsx
E) )wav

Question 47

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

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

Question 48

The company OpenText provides companies with "cloud based"

A) sales management software.
B) document management software.
C) Microsoft Office.
D) data storage.
E) accounting software.

Question 49

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

A) mattress.
B) file.
C) old can.
D) spreadsheet.
E) encrypted table.

Question 50

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

A) Customers
B) Web masters
C) Copy editors
D) Managers
E) Employees

Question 51

________ is an example of an enterprise DBMS.

A) Access
B) DB2
C) FoxPro
D) Quattro Pro
E) Paradox

Question 52

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

A) )pdf
B) )wav
C) )mov
D) )bmp
E) )mpg

Question 53

________ is an example of a personal DBMS.

A) Access
B) SQL Server
C) DB2
D) SQL
E) Oracle

Question 54

Columns are also called

A) rows.
B) databases.
C) fields.
D) relations.
E) tables.

Question 55

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

A) )wav
B) )mpg
C) )doc
D) )pdf
E) )bmp

Question 56

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

A) matrix.
B) column.
C) field.
D) row.
E) relation.

Question 57

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

A) row.
B) attribute.
C) table.
D) column.
E) field.

Question 58

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

A) )wav
B) )mov
C) )mpg
D) )pdf
E) )bmp

Question 59

________ is a record in a relational database.

A) A field
B) A table
C) A column
D) A row
E) A key

Question 60

One example of a DBMS is

A) SQL Server.
B) )NET.
C) Java.
D) OEM.
E) Excel.

Question 61

SQL is a

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

Question 62

In today's business world, content is just not about collection and distribution. It is also about

A) the accuracy of the content.
B) the organization of the content.
C) the content management system.
D) the relevance of the content.
E) presenting the content appropriately for the audience.

Question 63

________ describes the data in a database.

Question 64

Modern content management systems

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

Question 65

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

A) object-oriented
B) network
C) relational
D) personal
E) enterprise

Question 66

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

A) of the lack of consistency in both look and accuracy of the website.
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.
C) companies with web sites now have copy editors to prepare web site content.
D) most companies use content management systems today.
E) most web sites are driven by database management systems.

Question 67

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

A) relevant.
B) simple.
C) reconciled.
D) unique.
E) normalized.

Question 68

Content is closely related to

A) intellectual property.
B) words.
C) software.
D) property in the broadest sense.
E) organized materials.

Question 69

SQL stands for

A) Structured Query Language.
B) Standard Query Language.
C) Structured Question Language.
D) Simple Query Language.
E) Standard Question Language.

Question 70

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.

Question 71

Users process data in the database using

A) files.
B) logic.
C) programs.
D) reports.
E) queries.

Question 72

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

A) primary
B) index
C) secondary
D) foreign
E) composite

Question 73

A database differs from a spreadsheet by

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

Question 74

________ is an international standard language for processing a database.

A) VBA
B) SQL
C) Java
D) )NET
E) MySQL

Question 75

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

Question 76

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

Question 77

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

A) attributes.
B) characters.
C) content.
D) overhead.
E) metadata.

Question 78

________ describe(s) the structure of a database.

A) Logic
B) Metadata
C) Models
D) Protocols
E) Content

Question 79

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

A) redundancy
B) lost-update
C) locked file
D) security
E) data integrity

Question 80

One of the DMBS administrative functions includes

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