Question 1

The _____ data model is said to be a semantic data model.

Accepted Answer

A)   relational
B)   network
C)   object-oriented
D)   entity relationshipE) A) and C)
F) None of the above

Question 2

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

Accepted Answer

A) True 
 B)False

Question 3

Business rules must be rendered in writing.

Accepted Answer

A) True 
 B)False

Question 4

The _____ data model uses the concept of inheritance.

Accepted Answer

A)   relational
B)   network
C)   object-oriented
D)   entity relationshipE) A) and B)
F) A) and C)

Question 5

Today, most relational database products can be classified as object/relational.

Accepted Answer

A) True 
 B)False

Question 6

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Accepted Answer

A) True 
 B)False

Question 7

MySQL is an example of the _____.

Accepted Answer

A)   hierarchical model
B)   file system data model
C)   relational data model
D)   XML data modelE) A) and C)
F) All of the above

Question 8

A(n)  _____ enables a database administrator to describe schema components.

Accepted Answer

A)   extensible markup language (XML) 
B)   data definition language (DDL) 
C)   unified modeling language (UML) 
D)   query languageE) B) and C)
F) A) and D)

Question 9

A(n)  _____ is the equivalent of a field in a file system.

Accepted Answer

A)   attribute
B)   entity
C)   relationship
D)   constraintE) C) and D)
F) All of the above

Question 10

Each row in the relational table is known as a(n) _____.

Accepted Answer

The answer of Each row in the relational table is...

Question 11

A noun in a business rule translates to a(n)  _____ in the data model.

Accepted Answer

A)   entity
B)   attribute
C)   relationship
D)   constraintE) A) and B)
F) A) and C)

Question 12

Describe the three basic characteristics of Big Data databases.

Accepted Answer

Douglas Laney, a data analyst from the G...

Question 13

Oracle12c, MS SQL Server, and Taminoare examples of _____ data models.

Accepted Answer

A)   hierarchical
B)   file system
C)   relational
D)   XML HybridE) C) and D)
F) B) and C)

Question 14

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Accepted Answer

The answer of The term _____ is used to refer...

Question 15

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

Accepted Answer

A) True 
 B)False

Question 16

Each row in a relation is called a(n) _____.

Accepted Answer

The answer of Each row in a relation is called...

Question 17

VMS/VSAM is an example of the _____.

Accepted Answer

A)   hierarchical model
B)   file system data model
C)   relational data model
D)   XML data modelE) None of the above
F) A) and C)

Question 18

The external model is the representation of the database as "seen" by the DBMS.

Accepted Answer

A) True 
 B)False

Question 19

Students and classes have a _____ relationship.

Accepted Answer

A)   one-to-one
B)   one-to-many
C)   many-to-one
D)   many-to-manyE) A) and B)
F) A) and C)

Question 20

_____ are important because they help to ensure data integrity.

Accepted Answer

A)   Attributes
B)   Entities
C)   Relationships
D)   ConstraintsE) B) and D)
F) A) and B)

Exam 2: Data Models

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

Correct AnswerverifiedShow Answer

A(n) _____ enables a database administrator to describe schema components.

Correct AnswerverifiedShow Answer

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

Correct AnswerverifiedShow Answer

Each row in the relational table is known as a(n) _____.

Correct AnswerverifiedShow Answer

Describe the three basic characteristics of Big Data databases.

Correct AnswerverifiedDouglas Laney, a data analyst from the G...View AnswerShow Answer

A(n) _____ is the equivalent of a field in a file system.

Correct AnswerverifiedShow Answer

The _____ data model uses the concept of inheritance.

Correct AnswerverifiedShow Answer

Each row in a relation is called a(n) _____.

Correct AnswerverifiedShow Answer

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Correct AnswerverifiedShow Answer

VMS/VSAM is an example of the _____.

Correct AnswerverifiedShow Answer

A noun in a business rule translates to a(n) _____ in the data model.

Correct AnswerverifiedShow Answer

_____ are important because they help to ensure data integrity.

Correct AnswerverifiedShow Answer

Business rules must be rendered in writing.

Correct AnswerverifiedShow Answer

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Correct AnswerverifiedShow Answer

Oracle12c, MS SQL Server, and Taminoare examples of _____ data models.

Correct AnswerverifiedShow Answer

MySQL is an example of the _____.

Correct AnswerverifiedShow Answer

Today, most relational database products can be classified as object/relational.

Correct AnswerverifiedShow Answer

The _____ data model is said to be a semantic data model.

Correct AnswerverifiedShow Answer

The external model is the representation of the database as "seen" by the DBMS.

Correct AnswerverifiedShow Answer

Students and classes have a _____ relationship.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Douglas Laney, a data analyst from the G...
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