Deck 5: Database Processing

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

A

Question 3

________ is a popular enterprise DBMS product from IBM.

A)DB2
B)Access
C)SQL Server
D)MySQL

Answer 3

A

Question 4

What is metadata?

A)data that cannot be used as an information resource
B)special data that describes the structure of a database
C)data that describes a Web page
D)special data that is unique to a specific user

Question 5

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

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

Question 6

For which of the following operations do applications use DBMS?

A)send emails
B)write a software program
C)modify data
D)track sample data

Question 7

A group of similar rows is called a ________.

A)table
B)record
C)field
D)matrix

Question 8

The name of the field and the data type would be an example of ________.

A)an open matrix
B)datamining factors
C)metadata
D)a closed matrix

Question 9

Characters of data are grouped into ________.

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

Question 10

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

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

Question 11

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

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

Question 12

Which of the following is a DBMS product from Microsoft?

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

Question 13

A more formal name for a table is ________.

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

Question 14

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)help people keep track of things

Question 15

Which of the following is a function of the DBMS?

A)enabling multiuser processing
B)tracking sample data
C)preparing reports
D)processing the database

Question 16

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

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

Question 17

A table is also called a ________.

A)record
B)matrix
C)file
D)field

Question 18

The collection of data for all columns is called a ________.

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

Question 19

A ________ is a program used to create,process,and administer a database.

A)metadata system
B)knowledge management system
C)database management system
D)database application system

Question 20

Which of the following describes a byte?

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

Question 21

Which of the following is true of enterprise DBMS products?

A)Enterprise DBMS products are designed for small and simple database applications.
B)Enterprise DBMS products manage databases that span dozens of different magnetic disks.
C)Paradox is an example of an enterprise DBMS product.
D)The great bulk of databases in enterprise DBMS products have only a single user.

Question 22

Which of the following is an example of an enterprise DBMS product?

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

Question 23

________ products process large organizational and workgroup databases.

A)Relational DBMS
B)Personal DBMS
C)Enterprise DBMS
D)Structured DBMS

Question 24

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

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

Question 25

________ is an international standard language for processing a database.

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

Question 26

Databases are required to keep track of lists with multiple themes.

Question 27

________ products are designed for smaller,simpler database applications.

A)Relational DBMS
B)Personal DBMS
C)Enterprise DBMS
D)Structured DBMS

Question 28

________ refers to software systems that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.

A)NoSQL DBMS
B)MySQL DBMS
C)Enterprise DBMS
D)Personal DBMS

Question 29

To prevent the ________ problem,locking must be used to coordinate the activities of users who know nothing about one another.

A)data integrity
B)redundancy
C)lost-update
D)data access

Question 30

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

A)Markup language codes
B)Query forms
C)Data entry forms
D)Data access programs

Question 31

Which of the following functions of a database involves setting up user accounts,passwords,permissions,and limits for processing the database?

A)administering the database
B)creating the database
C)modifying the database
D)processing the database

Question 32

Which of the following is true of 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)IBM's DB2 is an example of a personal DBMS product.

Question 33

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

A)database application
B)database function
C)database management system
D)database structure

Question 34

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

A)creating the database
B)modifying the database
C)administering the database
D)processing the database

Question 35

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

Question 36

Bytes,which are characters of data,are grouped into rows.

Question 37

________ is an example of a personal DBMS product.

A)DB2
B)FoxPro
C)Oracle Database
D)SQL Server

Question 38

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

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

Question 39

Which of the following is true of a database application?

A)A database can have only one application,and each application has one user.
B)It provides tools to assist in the administration of the database.
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 40

SQL stands for ________.

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

Question 41

DB2 is a popular DBMS product that is licensed from Microsoft.

Question 42

Columns are also called records.

Question 43

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

Question 44

Hypertext Markup Language is an international standard language for processing a database.

Question 45

Most organizations develop their own DBMS.

Question 46

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

Question 47

DBMS administrative functions include adding structures to improve the performance of database applications.

Question 48

The application program serves as an intermediary between the Web server and the database.

Question 49

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

Question 50

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

Question 51

The collection of data for all columns is called a file.

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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 57

Query forms are used to read,insert,modify,and delete data.

Question 58

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

Question 59

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

Question 60

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

Question 61

NoSQL DBMS products are very technical and can be used only by those with a deep background in computer science.

Question 62

MySQL DBMS refers to software systems that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.

Question 63

Explain enterprise DBMS products.

Question 64

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

Question 65

How are database application programs useful?

Question 66

What are personal DBMS products?

Question 67

Explain database management systems.

Question 68

What is the function of a database application system?

Question 69

What are relational databases?

Question 70

Paradox and FoxPro are examples of personal DBMS products.

Question 71

What is a NoSQL DBMS?

Question 72

Describe the usefulness of metadata.

Question 73

Briefly describe the elements of a database application.

Question 74

What are the differences between a spreadsheet and a database?

Question 75

Describe the contents of a database.

Question 76

How does one create a database and its structures?

Question 77

Define SQL.

Question 78

Describe the functions of a database management system.

Question 79

The great bulk of databases in personal DBMS products have only a single user.

Question 80

What is a database application?