Tuesday, March 18, 2014

ER Model - Quiz 1

DBMS Basics and Entity-Relationship Model - Quiz 1

1. ER modeling is primarily used for
    Database Programming
    Organizing Databases
    Designing Databases
    None of the above

2. An Entity Set is
    a set of entities of the same type that share the same properties
    a set of entities of different type that share the same properties
    a set of entities of different type that share the different properties
    None of the above

3. The set of permitted values for an attribute is called as
    Entity Set
    Value Set
    Both Domain and Value Set

4. An attribute which can have many values for a single entity is called as
    Composite Attribute
    Descriptive Attribute
    Derived Attribute
    Multivalued Attribute

5. If a record in table R is associated with only one record in table S, and a record in S is associated with only one record in table R, then the relationship between R and S is

6. The first step in database design is
    Physical Database Design
    Logical Database Design
    Conceptual Database Design
    Requirements Gathering and Analysis

7. A relationship is an association between
    Two or more Entities
    One or more Entities
    Entities and Attributes
    One or more Attributes

8. Which of the following is not the disadvantage of File Processing System?
    Data isolation
    Atomicity Problems
    Data Redundancy
    None of the above

9. The status of a relational table at a particular moment is called
    Logical Schema

10. Data-Manipulation Language (DML) is a language that enables users to
    Design the Database
    Insert Data into the Database
    Control the Transactions in Database
    Define User Privileges

Score =

Correct answers:

No comments:

Post a Comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery