Deck 5: Database Processing

Question 1

A more formal name for a table is ________.

A) metadata
B) field
C) record
D) relation

Answer 1

D

Question 2

A table is also called a ________.

A) record
B) row
C) file
D) column

Answer 2

C

Question 3

A collection of fields is called a ________.

A) record
B) column
C) file
D) table

Answer 3

A

Question 4

Data type and description are examples of ________.

A) metadata
B) a column
C) rows
D) database

Question 5

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

A) table
B) record
C) row
D) column

Question 6

________ is a popular enterprise DBMS from IBM.

A) DB2
B) Access
C) dBase
D) FoxPro

Question 7

Columns are grouped into ________,which are also called ________.

A) rows; records
B) fields; tables
C) tables; files
D) files; rows

Question 8

Characters of data are grouped into ________.

A) bytes
B) columns
C) rows
D) records

Question 9

Which of the following describes a byte?

A) a character of data
B) group of rows
C) collection of data
D) group of columns

Question 10

Columns that are keys of a different table than the one in which they reside are known as ________ keys.

A) foreign
B) aspect
C) relational
D) variable

Question 11

Which of the following is a DBMS product from Microsoft?

A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE

Question 12

________ software programs assist in creating and maintaining databases.

A) Metadata
B) Knowledge management
C) DBMS
D) Database application system

Question 13

Bytes are grouped into columns,which are also called ________.

A) records
B) rows
C) files
D) fields

Question 14

Databases that carry their data in the form of tables are called ________ databases.

A) foreign
B) meta
C) relational
D) tabular

Question 15

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

A) field
B) byte
C) file
D) key

Question 16

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

A) datasheet
B) metadata
C) database
D) data record

Question 17

A(n)________ is an assembly of forms,reports,queries,and application programs that process a database.

A) SQL server
B) metadata
C) database management system
D) database application system

Question 18

The purpose of a database is to ________.

A) use special technology to monitor a single theme
B) design, write, test, troubleshoot, and maintain the source code of computer programs
C) use a logical data model of information to describe and build architectures
D) keep track of things that involve more than one thing

Question 19

What is metadata?

A) data that can be used to get a clear idea of the content of a Web page
B) special data that describes the structure of a database
C) data that describes a Web page
D) some aspect of an information resource

Question 20

The name of the field,the data type,and the number of characters allowed would be an example of ________.

A) character
B) key
C) metadata
D) byte

Question 21

Which of the following is an example of enterprise DBMS?

A) Paradox
B) dBase
C) R:base
D) MySQL

Question 22

________ is an example of personal DBMS.

A) DB2
B) FoxPro
C) Oracle
D) MySQL

Question 23

During which of the following functions of a database are tools provided for assistance?

A) creating the database
B) querying at Flextime
C) administering the database
D) processing the database

Question 24

Which of the following stands true for personal DBMS products?

A) Personal DBMS products are designed for simple database applications.
B) Personal DBMS products support many users.
C) Personal DBMS products can manage databases that span dozens of different magnetic disks.
D) MySQL is an example of a personal DBMS product.

Question 25

SQL stands for ________.

A) Standard Query Language
B) Standard Question Language
C) Structured Query Language
D) Simplified Query Language

Question 26

Database developers use the ________ to create relationships in the database.

A) DBMS
B) metadata
C) rows
D) columns

Question 27

________ is both a DBMS and an application development product.

A) FoxPro
B) Access
C) Oracle
D) MySQL

Question 28

________ are used to read,insert,modify,and delete data.

A) Markup language codes
B) DBMS applications
C) Data entry forms
D) Application programs

Question 29

________ is an international standard language for processing a database.

A) Hypertext Markup Language
B) Dynamic HTML
C) Structured Query Language
D) Sybase

Question 30

Which of the following is true of database application?

A) A database can have only one application, and each application may have one user.
B) It is a language that processes information in a database management system.
C) Application programs process logic that is specific to a given business need.
D) It uses hypertext markup language to process information in a database.

Question 31

The ________ problem is unique to a multiuser database processing.

A) data integrity
B) redundancy
C) lost-update
D) scrambled report

Question 32

________ process(es)large organizational and workgroup databases.

A) FoxPro
B) Personal DBMS
C) Enterprise DBMS
D) Paradox

Question 33

Which of the following stands true for enterprise DBMS products?

A) Enterprise DBMS products are designed for small and simple database applications.
B) Enterprise DBMS products support many (perhaps thousands) of users and many different database applications.
C) Paradox is an example of an enterprise DBMS product.
D) Most of the enterprise DBMS products are out of business today.

Question 34

For which of the following operations do applications use DBMS?

A) send e-mails
B) write a software program
C) modify data
D) track simple data

Question 35

Which of the following is the most significant personal DBMS product available in the market today?

A) MS Access
B) FoxPro
C) dBase
D) Paradox

Question 36

Personal DBMS products are designed ________.

A) to process large organizational and workgroup databases
B) to span dozens of different magnetic disks with hundreds of gigabytes or more of data
C) to support many users and many different database applications
D) for smaller, simpler database applications

Question 37

To locate something in the database,one must type in the keyword into the ________ of the application.

A) report
B) query form
C) data entry form
D) data column

Question 38

A ________ is a collection of reports,forms,and queries that process a database.

A) database application
B) SQL query
C) DBMS
D) database structure

Question 39

In a typical database application,a(n)________ shows data in a structured context.

A) application
B) entry form
C) query
D) report

Question 40

Which of the following is a function of the DBMS?

A) considering multiuser processing
B) mastering database application programs
C) preparing reports
D) processing the database

Question 41

Pure database data in raw form are most pertinent and useful.

Question 42

Each of the elements of the database application system calls on the database management system (DBMS)to process the database tables.

Question 43

SQL Server is an open source DBMS product that is free for most applications.

Question 44

A more formal name for a table is grid.

Question 45

Relational databases have almost disappeared from use.

Question 46

Bytes,which are characters of data,are grouped into rows,which are also called tables.

Question 47

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

Question 48

Databases are required to keep track of things that involve multiple themes.

Question 49

DBMS administrative functions include backing up database data,adding structures to improve the performance of database applications,removing data that are no longer wanted or needed,and similar tasks.

Question 50

Columns are also called fields.

Question 51

Application programs process logic that is specific to a given business need.

Question 52

To modify an existing table - for example,to add a new column - the developer opens the metadata form for that table and adds a new row of metadata.

Question 53

The DBMS uses a keyword form to locate records or items in the database.

Question 54

SQL statements can be issued directly to the DBMS by an application program.

Question 55

Most organizations develop their own DBMS.

Question 56

To find out what a database contains,we just look at the metadata inside the database.

Question 57

Databases are self-describing because they contain not only data,but also data about the data in the database.

Question 58

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

Question 59

A database cannot have more than one application running on it.

Question 60

The format of metadata depends on the software product that is processing the database.

Question 61

The bulk of databases in the personal DBMS category have multiple users.

Question 62

Enterprise DBMS products are designed for smaller,simpler database applications.

Question 63

Today,the only remaining personal DBMS of significance is Microsoft SQL Server.

Question 64

What are relational databases?

Question 65

What is the function of a database application system?

Question 66

One of the uses of the application program is that the application program serves as an intermediary between the Web server and the database.

Question 67

What are the differences between a spreadsheet and a database?

Question 68

The lost-update problem can be prevented by a type of locking which must be used to coordinate the activities of users who know nothing about one another.

Question 69

Describe the functions of a database management system.

Question 70

What are personal DBMS products?

Question 71

Explain enterprise DBMS products.

Question 72

How can one prevent the lost-update problem of multiuser processing?

Question 73

Describe the contents of a database.

Question 74

How does one create a database and its structures?

Question 75

How are database application programs useful?

Question 76

Explain database management systems.

Question 77

What is a database application?

Question 78

Define SQL.

Question 79

Briefly describe the elements of a database application.

Question 80

Describe the usefulness of metadata.