Tuesday, 18 March 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
    Domain
    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
    One-to-Many
    Many-to-One
    One-to-One
    Many-to-Many

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
    Metadata
    Instance
    Subschema

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

Nlp and machine learning online lectures

Links to Natural Language Processing (NLP) and Data Science online lectures An introduction to Bayes theorem and Hidden Markov model ...