Question 1

What is a NoSQL database management system?

Accepted Answer

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

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

Question 3

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 4

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

Accepted Answer

A)  table
B)  record
C)  field
D)  matrixE) C) and D)
F) A) and D)

Question 5

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 it is user friendly
C)  very cost-effective but can be enormously disruptive
D)  unnecessary when relational databases meet the needs of organizationsE) B) and C)
F) All of the above

Question 6

Discuss the creation of a database.Explain its working.

Accepted Answer

Database developers use the database man...

Question 7

To find out what a database contains,one can look at the metadata inside the database.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

The database management system (DBMS) provides applications for processing operations such as ________.

Accepted Answer

A)  sending and receiving emails
B)  generating software codes
C)  inserting or deleting information
D)  automating business processesE) A) and B)
F) None of the above

Question 10

Define Structured Query Language (SQL).

Accepted Answer

Structured Query Language (SQL)is an int...

Question 11

Traditional database application programs are written in object-oriented languages like ________.

Accepted Answer

A)  Pascal
B)  Visual Basic
C)  Datalog
D)  UnigraphicsE) B) and C)
F) A) and D)

Question 12

Which of the following is a database management system (DBMS) product from Microsoft?

Accepted Answer

A)  MySQL
B)  SQL Server
C)  DB2
D)  Sybase ASEE) C) and D)
F) B) and D)

Question 13

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

Accepted Answer

A)  hierarchical
B)  network
C)  relational
D)  objectE) B) and D)
F) None of the above

Question 14

In a database,a table is also called a ________.

Accepted Answer

A)  record
B)  matrix
C)  file
D)  fieldE) None of the above
F) All of the above

Question 15

Browser-based database applications differ from traditional applications in that they ________.

Accepted Answer

A)  have no security requirements
B)  are used only by corporates
C)  are usually open to the public
D)  fail to support graphical queriesE) C) and D)
F) None of the above

Question 16

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 17

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)  alternate
C)  relational
D)  candidateE) A) and C)
F) B) and D)

Question 18

Database management system (DBMS)administrative functions include adding structures to improve the performance of database applications.

Accepted Answer

A) True 
 B)False

Question 19

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

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

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

Correct AnswerverifiedShow Answer

Discuss the creation of a database.Explain its working.

Correct AnswerverifiedDatabase developers use the database man...View AnswerShow Answer

Define Structured Query Language (SQL).

Correct AnswerverifiedStructured Query Language (SQL)is an int...View AnswerShow Answer

Which of the following is a database management system (DBMS) product from Microsoft?

Correct AnswerverifiedShow Answer

To find out what a database contains,one can look at the metadata inside the database.

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

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

Correct AnswerverifiedShow Answer

Browser-based database applications differ from traditional applications in that they ________.

Correct AnswerverifiedShow Answer

Database management system (DBMS)administrative functions include adding structures to improve the performance of database applications.

Correct AnswerverifiedShow Answer

The database management system (DBMS) provides applications for processing operations such as ________.

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

In a database,a table is also called a ________.

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

What is a NoSQL database management system?

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

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

Correct AnswerverifiedShow Answer

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

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

Traditional database application programs are written in object-oriented languages like ________.

Correct AnswerverifiedShow Answer

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

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

Correct Answer
verified

Correct Answer
verified
Database developers use the database man...
View Answer

Correct Answer
verified
Structured Query Language (SQL)is an int...
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
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