MIS Ch 5

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

store lists of data involving multiple themes

Databases are required to keep track of lists with multiple themes. (T/F)

True

4) A ________ is a self-describing collection of integrated records.
A) datasheet
B) dataflow
C) database
D) dataspace

database

5) 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.

It is a character of data.

6) In a database, bytes are grouped into ________.
A) tables
B) columns
C) rows
D) records

columns

7) In a database, columns are also called ________.
A) records
B) tables
C) files
D) fields

fields

8) In a database, rows are also called ________.
A) records
B) fields
C) tables
D) files

records

9) In a database, the collection of data for all columns is called a ________.
A) record
B) field
C) file
D) table

record

10) In a database, a group of similar rows is called a ________.
A) table
B) record
C) field
D) matrix

table

11) In a database, a table is also called a ________.
A) record
B) matrix
C) file
D) field

file

13) In a database, a column or group of columns that identifies a unique row in a table is known as a ________.
A) field
B) record
C) file
D) key

key

14) 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) alternate
C) relational
D) candidate

foreign

15) Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
A) hierarchical
B) network
C) relational
D) object

relational

16) In a database, a table is formally referred to as a ________.
A) matrix
B) field
C) record
D) relation

relation

17) Data that describe the data contained in a database are called ________.
A) open matrices
B) primary data
C) metadata
D) closed matrices

metadata

A database is a self-describing collection of integrated records. (T/F)

True

Bytes, which are characters of data, are grouped into rows in a database. (T/F)

False

In a database, columns are also called records. (T/F)

False

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

True

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

False

To find out what a database contains, one can look at the metadata inside the database. (T/F)

True

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

database management system (DBMS)

Which of the following is a database management system (DBMS) product from Microsoft?
A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE

B) SQL Server

________ is a popular enterprise database management system (DBMS) product from IBM.
A) DB2
B) Access
C) SQL Server
D) MySQL

A) DB2

Which of the following is a function of the database management system (DBMS)?
A) implementing lean systems in workstations
B) eliminating bottlenecks in business processes
C) automating workflows in the databases of companies
D) processing a database by inserting or modifying data

D) processing a database by inserting or modifying data

The database management system (DBMS) provides applications for processing operations such as ________.
A) sending and receiving emails
B) generating software codes
C) inserting or deleting information
D) automating business processes

C) inserting or deleting information

SQL stands for ________.
A) Standard Query Language
B) Secondary Query Language
C) Structured Query Language
D) Simplified Query Language

C) Structured Query Language

________ is an international standard language that is used for processing a database.
A) HyperText Markup Language
B) Dynamic HyperText Markup Language
C) Structured Query Language
D) Sybase language

C) Structured Query Language

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.
A) encrypting emails
B) encapsulating data objects
C) administering the database
D) testing program codes

C) administering the database

Which of the following is considered an administrative function of the database management system (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

A) adding structures to improve the performance of database applications

Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________.
A) creation
B) modification
C) processing
D) administration

D) administration

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.
A) processing
B) administration
C) creation
D) modification

B) administration

Most organizations develop their own database management systems. (T/F)

False

HyperText Markup Language is an international standard language for processing a database. (T/F)

False

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
A) database application
B) metadata table
C) database hierarchy
D) dimension table

A) database application

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

D) forms

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

C) reports

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

B) application programs

Traditional database application programs are written in object-oriented languages like ________.
A) Pascal
B) Visual Basic
C) Datalog
D) Unigraphics

B) Visual Basic

Browser-based database applications differ from traditional applications in that they ________.
A) have no security requirements
B) are used only by corporates
C) are usually open to the public
D) fail to support graphical queries

C) are usually open to the public

Which of the following is a major drawback of multi-user processing of a database?
A) lack of data integrity
B) software redundancy
C) lost-update problem
D) limited access to data

C) lost-update problem

Reports in database applications provide security, data consistency, and special-purpose processing. (T/F)

False

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer. (T/F)

False

Traditional database application programs are written in object-oriented languages such as C++. (T/F)

True

Security requirements are more stringent for traditional applications than for browser-based ones. (T/F)

False

Which of the following is a drawback of the relational database processing model?
A) It utilized an extensive amount of storage space.
B) It required powerful processors to function.
C) It was never a natural fit with business documents.
D) It did not enable document piece-making via normalization.

C) It was never a natural fit with business documents.

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.

D) It represents relationships with the help of foreign keys.

Which of the following is a nonrelational data store developed by Amazon.com?
A) Bigtable
B) Dynamo
C) Cassandra
D) MongoDB

B) Dynamo

76) ________ refers to software products 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

A) NoSQL DBMS

MIS Ch 5 - Subjecto.com

MIS Ch 5

Your page rank:

Total word count: 1357
Pages: 5

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

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

store lists of data involving multiple themes

Databases are required to keep track of lists with multiple themes. (T/F)

True

4) A ________ is a self-describing collection of integrated records.
A) datasheet
B) dataflow
C) database
D) dataspace

database

5) 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.

It is a character of data.

6) In a database, bytes are grouped into ________.
A) tables
B) columns
C) rows
D) records

columns

7) In a database, columns are also called ________.
A) records
B) tables
C) files
D) fields

fields

8) In a database, rows are also called ________.
A) records
B) fields
C) tables
D) files

records

9) In a database, the collection of data for all columns is called a ________.
A) record
B) field
C) file
D) table

record

10) In a database, a group of similar rows is called a ________.
A) table
B) record
C) field
D) matrix

table

11) In a database, a table is also called a ________.
A) record
B) matrix
C) file
D) field

file

13) In a database, a column or group of columns that identifies a unique row in a table is known as a ________.
A) field
B) record
C) file
D) key

key

14) 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) alternate
C) relational
D) candidate

foreign

15) Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
A) hierarchical
B) network
C) relational
D) object

relational

16) In a database, a table is formally referred to as a ________.
A) matrix
B) field
C) record
D) relation

relation

17) Data that describe the data contained in a database are called ________.
A) open matrices
B) primary data
C) metadata
D) closed matrices

metadata

A database is a self-describing collection of integrated records. (T/F)

True

Bytes, which are characters of data, are grouped into rows in a database. (T/F)

False

In a database, columns are also called records. (T/F)

False

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

True

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

False

To find out what a database contains, one can look at the metadata inside the database. (T/F)

True

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

database management system (DBMS)

Which of the following is a database management system (DBMS) product from Microsoft?
A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE

B) SQL Server

________ is a popular enterprise database management system (DBMS) product from IBM.
A) DB2
B) Access
C) SQL Server
D) MySQL

A) DB2

Which of the following is a function of the database management system (DBMS)?
A) implementing lean systems in workstations
B) eliminating bottlenecks in business processes
C) automating workflows in the databases of companies
D) processing a database by inserting or modifying data

D) processing a database by inserting or modifying data

The database management system (DBMS) provides applications for processing operations such as ________.
A) sending and receiving emails
B) generating software codes
C) inserting or deleting information
D) automating business processes

C) inserting or deleting information

SQL stands for ________.
A) Standard Query Language
B) Secondary Query Language
C) Structured Query Language
D) Simplified Query Language

C) Structured Query Language

________ is an international standard language that is used for processing a database.
A) HyperText Markup Language
B) Dynamic HyperText Markup Language
C) Structured Query Language
D) Sybase language

C) Structured Query Language

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.
A) encrypting emails
B) encapsulating data objects
C) administering the database
D) testing program codes

C) administering the database

Which of the following is considered an administrative function of the database management system (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

A) adding structures to improve the performance of database applications

Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________.
A) creation
B) modification
C) processing
D) administration

D) administration

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.
A) processing
B) administration
C) creation
D) modification

B) administration

Most organizations develop their own database management systems. (T/F)

False

HyperText Markup Language is an international standard language for processing a database. (T/F)

False

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
A) database application
B) metadata table
C) database hierarchy
D) dimension table

A) database application

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

D) forms

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

C) reports

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

B) application programs

Traditional database application programs are written in object-oriented languages like ________.
A) Pascal
B) Visual Basic
C) Datalog
D) Unigraphics

B) Visual Basic

Browser-based database applications differ from traditional applications in that they ________.
A) have no security requirements
B) are used only by corporates
C) are usually open to the public
D) fail to support graphical queries

C) are usually open to the public

Which of the following is a major drawback of multi-user processing of a database?
A) lack of data integrity
B) software redundancy
C) lost-update problem
D) limited access to data

C) lost-update problem

Reports in database applications provide security, data consistency, and special-purpose processing. (T/F)

False

All traditional databases require the Internet to transmit traffic between a user’s computer and a database management system (DBMS) server computer. (T/F)

False

Traditional database application programs are written in object-oriented languages such as C++. (T/F)

True

Security requirements are more stringent for traditional applications than for browser-based ones. (T/F)

False

Which of the following is a drawback of the relational database processing model?
A) It utilized an extensive amount of storage space.
B) It required powerful processors to function.
C) It was never a natural fit with business documents.
D) It did not enable document piece-making via normalization.

C) It was never a natural fit with business documents.

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.

D) It represents relationships with the help of foreign keys.

Which of the following is a nonrelational data store developed by Amazon.com?
A) Bigtable
B) Dynamo
C) Cassandra
D) MongoDB

B) Dynamo

76) ________ refers to software products 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

A) NoSQL DBMS

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending