Exam 2: Data Models
Exam 1: Database Systems70 Questions
Exam 2: Data Models70 Questions
Exam 3: The Relational Database Model100 Questions
Exam 4: Entity Relationship (ER)Modeling100 Questions
Exam 5: Advanced Data Modeling70 Questions
Exam 6: Normalization of Database Tables100 Questions
Exam 7: Introduction to Structured Query Language (SQL)100 Questions
Exam 8: Advanced SQL100 Questions
Exam 9: Database Design100 Questions
Exam 10: Transaction Management and Concurrency Control70 Questions
Exam 11: Database Performance Tuning and Query Optimization70 Questions
Exam 12: Distributed Database Management Systems70 Questions
Exam 13: Business Intelligence and Data Warehouses100 Questions
Exam 14: Database Connectivity and Web Technologies100 Questions
Exam 15: Database Administration and Security100 Questions
Select questions type
The relational data model was developed in the ____.
Free
(Multiple Choice)
4.9/5
(33)
Correct Answer:
B
A(n)____________________ in a hierarchical model is the equivalent of a record in a file system.
Free
(Short Answer)
4.9/5
(32)
Correct Answer:
segment
The ____ model uses the concept of inheritance.
Free
(Multiple Choice)
4.9/5
(29)
Correct Answer:
C
Describe the three parts involved in any SQL-based relational database application.
(Essay)
4.9/5
(27)
A verb associating two nouns in a business rule translates to a(n)____ in the data model.
(Multiple Choice)
4.8/5
(38)
In ____________________,relationships are represented by a diamond connected to the related entities through a relationship line.
(Short Answer)
4.9/5
(33)
The ____ model uses the term connectivity to label the relationship types.
(Multiple Choice)
4.8/5
(27)
When you can change the internal model without affecting the conceptual model,you have ____________________ independence.
(Short Answer)
4.9/5
(31)
A noun in a business rule translates to a(n)____ in the data model.
(Multiple Choice)
4.8/5
(42)
Business rules apply to businesses and government groups,but not to other types of organizations such as religious groups or research laboratories.
(True/False)
4.9/5
(31)
A manager and a programmer usually have the same view of the same data.
(True/False)
4.9/5
(34)
The terms data model and database model are often used interchangeably.
(True/False)
4.8/5
(39)
One of the limitations of the ____ model is that there is a lack of standards.
(Multiple Choice)
4.7/5
(40)
The entity relationship model is limited to conceptual modeling,with no implementation component.
(True/False)
4.9/5
(37)
Each column in a relation represents a(n)____________________.
(Short Answer)
4.8/5
(34)
Showing 1 - 20 of 70
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)