FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Data Models

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

The relational model's foundation is a mathematical concept known as a .

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

A data model is usually graphical.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Which of the following is True of NoSQL databases?

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

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

The data model uses the concept of inheritance.

Oracle 11g is an example of the .

The relational model is hardware-dependent and software-independent.

Describe the three parts involved in any SQL-based relational database application.

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

The hierarchical data model was developed in the .

In the model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

Describe the conceptual model and its advantages. What is the most widely used conceptual model?

A(n) in a hierarchical model is the equivalent of a record in a file system.

M:N relationships are not appropriate in a relational model.

A(n) is a relatively simple representation of more complex real-world data structures.

Which of the following types of HDFS nodes stores all the metadata about a file system?

A(n) is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

are important because they help to ensure data integrity.