Question 1

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

Accepted Answer

A)   report
B)   data model
C)   database administrative function
D)   queryE) B) and C)
F) C) and D)

Question 2

A(n)  ________ is a request for data from a database.

Accepted Answer

A)   form
B)   report
C)   query
D)   applicationE) None of the above
F) A) and D)

Question 3

The columns in a database are called ________.

Accepted Answer

A)   records
B)   tables
C)   files
D)   fieldsE) B) and D)
F) B) and C)

Question 4

Describe entities in the context of data models.

Accepted Answer

An entity is something that the users wa...

Question 5

In an E-R diagram, a line between two entities represents a(n)  ________.

Accepted Answer

A)   attribute
B)   identifier
C)   cardinality
D)   relationshipE) A) and C)
F) None of the above

Question 6

A key is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A) True 
 B)False

Question 7

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

Accepted Answer

A) True 
 B)False

Question 8

Database applications must present data to the users in the same format as the database table.

Accepted Answer

A) True 
 B)False

Question 9

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 10

Developers generally construct a logical representation of database data, called a data model, after building a database.

Accepted Answer

A) True 
 B)False

Question 11

When you modify or delete data present in a database, you are ________.

Accepted Answer

A)   creating a new database
B)   forming a data model
C)   simplifying the data structure
D)   processing the databaseE) B) and C)
F) B) and D)

Question 12

Which of the following is a nonrelational data store developed by Google?

Accepted Answer

A)   Cassandra
B)   Dynamo
C)   SharePoint
D)   BigtableE) None of the above
F) A) and C)

Question 13

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

Accepted Answer

A)   identifiers
B)   foreign keys
C)   crow's feet
D)   entitiesE) A) and B)
F) C) and D)

Question 14

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

Accepted Answer

A) True 
 B)False

Question 15

Every table in a normalized database has a ________.

Accepted Answer

A)   one-to-one relationship between entities
B)   single theme
C)   foreign key
D)   specialized query formatE) A) and D)
F) None of the above

Question 16

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Accepted Answer

A) True 
 B)False

Question 17

A primary key used in a database is a ________.

Accepted Answer

A)   group of rows that are formed to identify a unique table or file
B)   column or group of columns that identifies a unique row in a table
C)   character or byte that represents fields or columns
D)   group of tables or files formed to identify a unique field or rowE) A) and B)
F) None of the above

Question 18

What is a database application?

Accepted Answer

A database application is a collection o...

Question 19

Most organizations develop their own DBMS software in order to obtain control over data.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

A(n) ________ is a request for data from a database.

Correct AnswerverifiedShow Answer

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

Correct AnswerverifiedShow Answer

Most organizations develop their own DBMS software in order to obtain control over data.

Correct AnswerverifiedShow Answer

In an E-R diagram, a line between two entities represents a(n) ________.

Correct AnswerverifiedShow Answer

A key is a column or group of columns that identifies a unique row in a table.

Correct AnswerverifiedShow Answer

Database applications must present data to the users in the same format as the database table.

Correct AnswerverifiedShow Answer

Describe entities in the context of data models.

Correct AnswerverifiedAn entity is something that the users wa...View AnswerShow Answer

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

Correct AnswerverifiedShow Answer

The columns in a database are called ________.

Correct AnswerverifiedShow Answer

What is a database application?

Correct AnswerverifiedA database application is a collection o...View AnswerShow Answer

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

Correct AnswerverifiedShow Answer

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

Correct AnswerverifiedShow Answer

Every table in a normalized database has a ________.

Correct AnswerverifiedShow Answer

Which of the following is a nonrelational data store developed by Google?

Correct AnswerverifiedShow Answer

Developers generally construct a logical representation of database data, called a data model, after building a database.

Correct AnswerverifiedShow Answer

When you modify or delete data present in a database, you are ________.

Correct AnswerverifiedShow Answer

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Correct AnswerverifiedShow Answer

A primary key used in a database is a ________.

Correct AnswerverifiedShow Answer

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An entity is something that the users wa...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database application is a collection o...
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