Deck 5: Database and Content Management

Question 1

A DBMS and a database are two different things.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

Metadata is data about data.

Question 5

IBM makes a DBMS called SQL-Server.

Question 6

SQL stands for "Standard Query Language".

Question 7

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

Question 8

A DBMS is software that helps manage the operating system.

Question 9

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

Question 10

Oracle makes a DBMS packaged called DB2.

Question 11

SQL is an international standard language for processing a database.

Question 12

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

Question 13

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

Question 14

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

Question 15

Most large companies develop their own DBMSs.

Question 16

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

Question 17

MySQL is an open source DBMS product.

Question 18

A database application can have one or more users.

Question 19

A database can have one and only one application.

Question 20

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

Question 21

A group of similar rows or records is called a ________.

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

Question 22

________ is a formal name for a table.

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

Question 23

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 24

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

A) Queries
B) Tables
C) Metadata
D) Keys
E) Printers

Question 25

________ describe(s)the structure of the database.

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

Question 26

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 27

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 28

________ is a form of creative endeavor 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 29

Which of the following is a personal DBMS product?

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

Question 30

Personal DBMS can handle over 100 users.

Question 31

A spreadsheet is just another type of relational database.

Question 32

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

Question 33

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 34

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 35

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

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

________ consists of forms,formatted 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 38

The only remaining personal DBMS today is Paradox.

Question 39

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

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

Question 40

________ 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 41

________ is a record in a relational database.

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

Question 42

________ 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 43

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

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

Question 44

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

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

Question 45

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 46

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 47

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

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

Question 48

________ is an example of an enterprise DBMS.

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

Question 49

The company that digitized the Oxford English Dictionary is called

A) IBM.
B) Nortel.
C) Microsoft.
D) Open Text.
E) Research in Motion.

Question 50

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 51

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 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

One example of a DBMS is

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

Question 54

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

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

Question 55

________ is an example of a personal DBMS.

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

Question 56

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 57

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

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

Question 58

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

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

Question 59

Columns are also called

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

Question 60

The company Open Text provides companies with "cloud based"

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

Question 61

SQL stands for

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

Question 62

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 web sites.
E) manage all aspects of corporate data.

Question 63

________ is an international standard language for processing a database.

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

Question 64

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

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

Question 65

Users process data in the database using

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

Question 66

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

Question 67

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 68

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

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

Question 69

Discuss the challenges for a multiuser database application.

Question 70

What are the differences between a database and a spreadhseet?

Question 71

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 72

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

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

Question 73

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 74

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 web site.
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 75

Content is closely related to

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

Question 76

________ describe(s)the structure of a database.

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

Question 77

SQL is a

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

Question 78

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 79

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.

Question 80

What is a database application?