Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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 4

Most organizations develop their own database management systems.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

SQL stands for ________.

Accepted Answer

A)   Standard Query Language
B)   Secondary Query Language
C)   Structured Query Language
D)   Simplified Query LanguageE) A) and C)
F) All of the above

Question 7

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 organizationsE) A) and D)
F) All of the above

Question 8

Describe the usefulness of metadata.

Accepted Answer

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

Question 9

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

Question 10

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

Accepted Answer

A)   record
B)   field
C)   file
D)   tableE) None of the above
F) C) and D)

Question 11

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

Question 12

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

Accepted Answer

A)   table
B)   record
C)   field
D)   matrixE) A) and D)
F) None of the above

Question 13

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 14

What is a NoSQL DBMS?

Accepted Answer

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

Question 15

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

Question 16

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 17

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

Question 18

In a database,bytes are grouped into ________.

Accepted Answer

A)   tables
B)   columns
C)   rows
D)   recordsE) B) and C)
F) None of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Most organizations develop their own database management systems.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct AnswerverifiedShow Answer

In a database,bytes are grouped into ________.

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

SQL stands for ________.

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

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

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

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

Correct AnswerverifiedShow Answer

Which of the following is a function of the DBMS?

Correct AnswerverifiedShow Answer

Describe the usefulness of metadata.

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

What is a NoSQL DBMS?

Correct AnswerverifiedA few years back,Amazon.com determined t...View AnswerShow 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

Correct Answer
verified

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

Correct Answer
verified
A few years back,Amazon.com determined t...
View Answer