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

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

From an end-user perspective,any SQL-bas...

View Answer

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

MySQL is an example of a(n) ____.

A) hierarchical model
B) file system data model
C) relational data model
D) XML data model

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

____ are important because they help to ensure data integrity.

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

In the ____ model,each parent can have many children,but each child has only one parent.

The object-oriented data model was developed in the ____.

Business rules are derived from ____.

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

A data model is usually graphical.

One of the limitations of the ____ model is that there is a lack of standards.

The ____________________ defines the portion of the database "seen" by the application programs that produce information from the data.

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

The ____ data model uses the concept of inheritance.

A manager and a programmer usually have the same view of the same data.

In the ____ model,the basic logical structure is represented as an upside-down tree.

In _________________________,a three-pronged symbol represents the "many" side of the relationship.

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

Oracle 11g is an example of a(n) ____.

A(n)____________________ is a representation of the relational database's entities,the attributes within those entities and the relationships between those entities.

VMS/VSAM is an example of a(n) ____.