Deck 5: Database Processing

Question 1

One example of a DBMS is

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

Answer 1

C

Question 2

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

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

Answer 2

E

Question 3

Columns are also called

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

Answer 3

C

Question 4

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

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

Question 5

__________describe(s)the structure of a database.

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

Question 6

__________are used to read,insert,modify,and delete data.

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

Question 7

Which of the following is a personal DBMS product?

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

Question 8

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)presenting the content appropriately for the audience.
D)the content management system.
E)the relevance of the content.

Question 9

__________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)Programming
C)Digital design
D)Intellectual property
E)Creative writing

Question 10

SQL is a

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

Question 11

Database administration includes

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

Question 12

A relational database refers to

A)a set of files that have similar names.
B)databases that have related objects related by similar attributes.
C)a set of tables that contains similar content.
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 13

Users process data in the database using

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

Question 14

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

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

Question 15

In the early days of corporate web sites employees where allowed to add content directly to the sites.Today this is not the case because

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

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

Content is

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

Question 20

Most organizations have a __________ against taking sensitive data home.

A)record
B)manual
C)policy
D)statement
E)memo

Question 21

__________is an enterprise DBMS.

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

Question 22

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

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

Question 23

__________consists of forms,formatted reports,queries,and application programs.

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

Question 24

MySQL is popular because it is a(n)__________DBMS.

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

Question 25

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

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

Question 26

__________software assists in creating,maintaining,and manipulating databases.

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

Question 27

The__________ problem is unique to a multi -user database environment.

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

Question 28

A__________ is a self -describing collection of integrated records.

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

Question 29

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

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

Question 30

Modern content management systems DBMS.

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

Question 31

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

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

Question 32

Sometimes employees such as salespeople prefer not to use the centralized database application because they are unwilling to __________their data on customer leads and contacts.

A)query
B)update
C)format
D)share
E)retrieve

Question 33

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

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

Question 34

SQL stands for

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

Question 35

What is a CMS?

A)Customer Management System
B)Content Manipulation System
C)Content Management System
D)Customer Manipulation System
E)Copy Management System

Question 36

A database differs from a spreadsheet by

A)having only rows.
B)being much more complex to construct.
C)having only columns.
D)involving list of multiple themes.
E)involving lists of a single themes.

Question 37

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

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

Question 38

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 39

__________is an international standard and comes with all relational DBMSs.

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

Question 40

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

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

Question 41

A database consists of

A)metadata.
B)relationships.
C)rows.
D)tables.
E)all of the above.

Question 42

__________is an example of a personal DBMS.

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

Question 43

To prevent the lost -update problem,the DBMS should have some type of __________mechanism.

Question 44

__________is a record in a relational database.

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

Question 45

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

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

Question 46

__________is a formal name for a table.

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

Question 47

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.

Question 48

Which of the following are not considered to be metadata?

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

Question 49

Another,more formal name for a table in a relational database is a(n)__________.

Question 50

Bytes are grouped into columns or __________.

Question 51

The company that digitized the Oxford English Dictionary is called

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

Question 52

__________describes the structure of the database.

Question 53

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

Question 54

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

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

Question 55

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

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

Question 56

Forms and reports are usually part of a database__________ .

Question 57

Setting up the database security is a part of database__________ .

Question 58

__________describe(s)the structure of the database.

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

Question 59

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

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

Question 60

A(n)__________describes a characteristic of something in a database table.

Question 61

__________database products like MS Access are designed for individual users or small workgroups of no more than 15 users.

Question 62

SQL stands for "Standard Query Language".

Question 63

A DBMS and a database are two different things.

Question 64

A__________ is a self -describing collection of integrated records.

Question 65

__________of information are represented by individual bytes.

Question 66

__________is a query language that is portable between all relational DBMSs.

Question 67

__________-level DBMS like DB2 are designed for large,corporate database applications.

Question 68

Data type and description are examples of__________ .

Question 69

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

Question 70

A(n)__________is another name for a table in relational database terms.

Question 71

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

Question 72

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

Question 73

If you are fired from your job because you have uncovered some unusual activity in the database applications that may be illegal,you should probably see a(n)__________.

Question 74

A database is a collection of tables,metadata,and __________.

Question 75

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 76

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

Question 77

If a user stores their data in a spreadsheet,it is difficult to__________that data back into an existing database application.

Question 78

A collection of columns or fields is called a row or a(n)__________.

Question 79

A web______helps to enable a company to standardize the look and feel of a web site.

Question 80

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