DBMS Basics and ER Model Quiz 7

Entity-Relationship Modeling Quiz 1

1. In a Entity-Relationship data model, an entity becomes a(n) _____________

Attribute
Table
Constraint
Column

2. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

Procedural DML
Non-Procedural DML
Procedural DDL
Non-Procedural DDL

3. Which of the following data model is widely applied in many real world database applications?

Network model
Relational model
Hierarchical model
None of the above

4. The logical design of the database is database __________, a snapshot of the data in the database at a given instant in time is database ________.

Instance, Schema
Relation, Schema
Relation, Domain
Schema, Instance

5. The tuples (records) of the relations (tables) can be of ________ order.

Any
Ascending
Sorted
Descending

6. Which of the following is the collection of interrelated data and set of program to access them?

Data structure
Database
DBMS
Programming Language

7. Database management systems are intended to

Eliminate data redundancy
Establish relationships among records in different files
Manage file access
All of the above

8. ________________defines the database schema, Interacts continuously with users, defines integrity and security checks, defines procedures for backup and recovery

Sophisticated User
Naïve User
DBA
Application Programmer

9. The number of tuples in a relation is called __________ of a relation.

Cardinality
Degree
Tuple
Key

10. The number of attributes (columns) in a relation is called __________ of a relation.

Cardinality
Degree
Tuple
Key

Score =

Correct answers: