Question 1

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.

Accepted Answer

A)  processing
B)  administration
C)  creation
D)  modificationE) A) and C)
F) A) and B)

Question 2

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

Accepted Answer

A)  datasheet
B)  dataflow
C)  database
D)  dataspaceE) None of the above
F) B) and D)

Question 3

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

Accepted Answer

A)  database application
B)  metadata table
C)  database hierarchy
D)  dimension tableE) A) and B)
F) B) and C)

Question 4

Describe the merits of metadata.

Accepted Answer

A database is self-describing in that it...

Question 5

In a database,columns are also called ________.

Accepted Answer

A)  records
B)  tables
C)  files
D)  fieldsE) All of the above
F) A) and C)

Question 6

Describe the elements in a database.

Accepted Answer

A database is a self-describing collecti...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

What are relational databases? Discuss their drawbacks that led to the development of nonrelational style of database processing.

Accepted Answer

Databases that carry their data in the f...

Question 10

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

Accepted Answer

A)  programs used to create,process,and administer a database
B)  special data that describes the structure of a database
C)  data that is stored in a Web site
D)  special data that is unique to a specific userE) B) and C)
F) All of the above

Question 11

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A)  DB2
B)  Access
C)  SQL Server
D)  MySQLE) None of the above
F) All of the above

Question 14

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

Accepted Answer

A)  encrypting emails
B)  encapsulating data objects
C)  administering the database
D)  testing program codesE) B) and D)
F) All of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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) C) and D)

Question 19

The administrative functions of a database management system (DBMS)include backing up database data.

Accepted Answer

A) True 
 B)False

Question 20

DB2 is a popular database management system product that is licensed from Microsoft.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

The administrative functions of a database management system (DBMS)include backing up database data.

Correct AnswerverifiedShow Answer

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

DB2 is a popular database management system product that is licensed from Microsoft.

Correct AnswerverifiedShow Answer

In a database,columns are also called ________.

Correct AnswerverifiedShow Answer

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

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 AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe the merits of metadata.

Correct AnswerverifiedA database is self-describing in that it...View AnswerShow Answer

Describe the elements in a database.

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

What are relational databases? Discuss their drawbacks that led to the development of nonrelational style of database processing.

Correct AnswerverifiedDatabases that carry their data in the f...View AnswerShow Answer

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

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 AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database is self-describing in that it...
View Answer

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

Correct Answer
verified
Databases that carry their data in the f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified