Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  field
B)  record
C)  file
D)  keyE) A) and B)
F) All of the above D

Question 3

Which of the following is an open source document-oriented NoSQL DBMS product?

Accepted Answer

A)  Access
B)  MongoDB
C)  SQL Server
D)  DB2E) C) and D)
F) A) and B)

Question 4

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

Accepted Answer

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.E) C) and D)
F) A) and C)

Question 5

Which of the following is a function of the database management system (DBMS) ?

Accepted Answer

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 dataE) C) and D)
F) A) and B)

Question 6

________ is a popular enterprise database management system (DBMS) product from IBM.

Accepted Answer

A)  DB2
B)  Access
C)  SQL Server
D)  MySQLE) B) and D)
F) A) and B)

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  NoSQL DBMS
B)  MySQL DBMS
C)  Traditional DBMS
D)  Relational DBMSE) C) and D)
F) None of the above

Question 9

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

Accepted Answer

A) True 
 B)False  False

Question 10

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

Accepted Answer

A)  Bigtable
B)  Dynamo
C)  Cassandra
D)  MongoDBE) B) and C)
F) A) and B)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 13

Describe the elements in a database.

Accepted Answer

A database is a self-describing collecti...

Question 14

The purpose of a database is to ________.

Accepted Answer

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 themesE) A) and B)
F) B) and C)

Question 15

Databases are static and it is only the information systems that change.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is an international standard language for querying databases?

Accepted Answer

A)  C++
B)  SQL
C)  Python
D)  Visual BasicE) C) and D)
F) None of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A)  matrix
B)  field
C)  record
D)  relationE) All of the above
F) None of the above

Question 19

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

Accepted Answer

A) True 
 B)False  True

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedD

Which of the following is an open source document-oriented NoSQL DBMS product?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a function of the database management system (DBMS) ?

Correct AnswerverifiedShow Answer

________ is a popular enterprise database management system (DBMS) product from IBM.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Most organizations develop their own database management systems.

Correct AnswerverifiedShow Answer

Describe the elements in a database.

Correct AnswerverifiedA database is a self-describing collecti...View AnswerShow Answer

The purpose of a database is to ________.

Correct AnswerverifiedShow Answer

Databases are static and it is only the information systems that change.

Correct AnswerverifiedShow Answer

Which of the following is an international standard language for querying databases?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database is a self-describing collecti...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified