Deck 5: Database Processing

Question 1

In a database,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) continuous

Answer 1

A

Question 2

Which of the following is a DBMS product from Microsoft?

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

Answer 2

B

Question 3

Which of the following best describes the metadata in a database?

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

Answer 3

B

Question 4

The DBMS provides applications for processing operations such as ________.

A) sending and receiving emails
B) writing software programs
C) inserting or deleting data
D) automating business processes

Question 5

In a database,bytes are grouped into ________.

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

Question 6

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

A) decision support system (DSS)
B) knowledge management system (KMS)
C) database management system (DBMS)
D) enterprise planning system (EPS)

Question 7

Which of the following best describes a byte in a database?

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

Question 8

In a database,columns are also called ________.

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

Question 9

In a database,a table is formally referred to as a ________.

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

Question 10

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

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

Question 11

In a database,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 12

Which of the following is a function of the DBMS?

A) analyzing business data to predict future performance
B) eliminating bottlenecks in business processes
C) automating workflows in companies
D) processing a database by inserting or modifying data

Question 13

In a database,a table,which is a group of similar rows,is also called a ________.

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

Question 14

The purpose of a database is to ________.

A) test and troubleshoot newly installed software
B) design the source code for computer programs
C) describe and build computer architectures
D) store lists of data involving multiple themes

Question 15

In a database,a group of similar rows is called a ________.

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

Question 16

In a database,rows are also called ________.

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

Question 17

________ is a popular enterprise DBMS product from IBM.

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

Question 18

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

A) datasheet
B) spreadmart
C) database
D) dataspace

Question 19

In a database,the collection of data for all columns is called a ________.

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

Question 20

Special data that describe the data contained in a database are called ________.

A) open matrices
B) primary data
C) metadata
D) closed matrices

Question 21

Which of the following is a drawback of the relational database processing model?

A) It utilizes an extensive amount of storage space.
B) It requires powerful processors to function.
C) It was never a natural fit with business documents.
D) It does not enable document piece-making via normalization.

Question 22

Traditional database application programs are written in object-oriented languages like ________.

A) Information Systems Base Language
B) VisualBasic
C) Datalog
D) Structured Query Language

Question 23

SQL stands for ________.

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

Question 24

Which of the following elements of a database application provides security,data consistency,and special-purpose processing?

A) query applications
B) application programs
C) reports
D) forms

Question 25

Monitoring the performance of a database after providing solutions for improving its performance is a(n)________ of the DBMS.

A) creation function
B) modification function
C) processing operation
D) administrative function

Question 26

Browser-based database applications differ from traditional applications in that they ________.

A) have no security requirements
B) mostly run within a corporate network that is protected from the Internet
C) are usually open to the public
D) fail to support graphical queries

Question 27

Which of the following is a major problem posed by multi-user processing of a database?

A) lack of data integrity
B) software redundancy
C) lost-update problem
D) limited access to data

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) Traditional DBMS
D) Relational DBMS

Question 29

Which of the following is a nonrelational data store developed by Amazon.com?

A) Bigtable
B) Dynamo
C) Cassandra
D) MongoDB

Question 30

________ is an international standard language that is used for processing a database.

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

Question 31

Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?

A) reports
B) application programs
C) queries
D) forms

Question 32

One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.

A) storing data types such as images, audio, and videos in organizations
B) gaining faster performance by limiting the number of servers used
C) breaking up sales orders via normalization
D) limiting the use of open-source document-oriented DBMS

Question 33

Which of the following elements of a database application presents data in a structured manner using sorting,grouping,filtering,and other operations?

A) queries
B) forms
C) reports
D) application programs

Question 34

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

A) database application
B) database administrator
C) knowledge management system
D) dimension table

Question 35

The conversion of the existing traditional databases in organizations to NoSQL databases is ________.

A) highly efficient and is being practiced by many organizations
B) highly recommended because any technology-tolerant business professional can use NoSQL
C) very cost-effective, but can be enormously disruptive
D) unnecessary in cases where relational databases meet the needs of organizations

Question 36

Which of the following is true of browser-based database applications?

A) They are written in object-oriented languages like Structured Query Language.
B) The application, DBMS, and the database all reside on the user's computer.
C) They are thin-client applications that need not be pre-installed on a user's computer.
D) They use C++ as the standard language for user-side processing.

Question 37

One of the important functions of a DBMS is to provide the necessary tools for ________.

A) encrypting e-mails
B) encapsulating data objects
C) administering the database
D) testing program codes

Question 38

Which of the following is true of the relational database processing model?

A) It supports very high transaction rates.
B) It can efficiently store files with large collections of bits.
C) It helps organizations store new data types such as images, audio, and videos.
D) It represents relationships with the help of foreign keys.

Question 39

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n)________ of the DBMS.

A) processing operation
B) administrative function
C) creation function
D) modification function

Question 40

Which of the following is considered an administrative function of the DBMS?

A) adding structures to improve the performance of database applications
B) testing program codes in the system for errors
C) creating tables, relationships, and other structures in databases
D) using international standard languages for processing database applications

Question 41

The DBMS can be used to set up a security system involving user accounts,passwords,permissions,and limits for processing the database.

Question 42

A DBMS is also referred to as a database.

Question 43

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

Question 44

In a database,columns are also called records.

Question 45

Queries in database applications present data in a structured manner using operations such as sorting,grouping,and filtering.

Question 46

The administrative functions of a DBMS include backing up database data.

Question 47

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

Question 48

In a database,a key is a column or group of columns that identifies a unique row in a table.

Question 49

A database application serves as an intermediary between users and database data.

Question 50

Most organizations develop their own database management systems.

Question 51

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

Question 52

To find out what a database contains,one can look at the metadata inside the database.

Question 53

In a database,a group of similar rows or records is called a table.

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

Bytes,which are characters of data,are grouped into rows in a database.

Question 59

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

Question 60

In a database,the collection of data for all columns is called a file.

Question 61

What are the differences between a spreadsheet and a database?

Question 62

Reports in database applications provide security,data consistency,and special-purpose processing.

Question 63

Security requirements are more stringent for traditional applications than for browser-based ones.

Question 64

Describe the functions of a database management system.

Question 65

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 66

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

Question 67

Describe the contents of a database.

Question 68

What is a database application?

Question 69

Browser applications are thin-client applications that need not be pre-installed on the users' computers.

Question 70

In single-user databases,the application,the DBMS,and the database all reside on a user's computer.

Question 71

Traditional database application programs are written in object-oriented languages such as C++.

Question 72

How does one create a database and its structures?

Question 73

Explain database management systems (DBMS).

Question 74

What are relational databases? What has led to the development of new nonrelational styles of database processing?

Question 75

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

Question 76

Browser database application forms,reports,and queries are displayed and processed using html.

Question 77

What is a NoSQL DBMS?

Question 78

Describe the usefulness of metadata.

Question 79

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

Question 80

Define SQL.