Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

Describe the usefulness of metadata.

Accepted Answer

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

Question 5

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

SQL stands for ________.

Accepted Answer

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

Question 11

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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 15

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

Accepted Answer

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

Question 16

In a database,bytes are grouped into ________.

Accepted Answer

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

Question 17

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

Accepted Answer

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 18

What is a NoSQL DBMS?

Accepted Answer

A few years back,Amazon.com determined t...

Question 19

Which of the following is a function of the DBMS?

Accepted Answer

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 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

What is a NoSQL DBMS?

Correct AnswerverifiedA few years back,Amazon.com determined t...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a function of the DBMS?

Correct AnswerverifiedShow Answer

SQL stands for ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a database,bytes are grouped into ________.

Correct AnswerverifiedShow Answer

Most organizations develop their own database management systems.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe the usefulness of metadata.

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

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
A few years back,Amazon.com determined t...
View 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

Correct Answer
verified

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

Correct Answer
verified