Wednesday, March 19, 2014

ER Model Quiz 2

DBMS Basics and Entity-Relationship Model - Quiz 2


1. Execution of a Data Definition Language (DDL) statement will
    Create a Table
    Update Data Dictionary
    Both Create a Table and Update Data Dictionary
    Define the User Privileges

2. ________________ need an user to specify in a query "What data are required and how to retrieve the required data?"
    Procedural DML
    Declarative DML
    Non-Procedural DML
    Transaction Control Language

3. Which of the following users interact with the database directly using Query languages?
    Naive Users
    Specialized Users
    Sophisticated Users
    Applicaton Programmers

4. Which of the following is one of the main tasks of Database Administrator (DBA)?
    Interface Program Development
    Writing DML Precompilers
    Schema Definition
    None of the above

5. The number of entity sets linked through a single relationship set is
    Degree of Relationship set
    Degree of Entity set
    Degree of Attribute set
    All of the above

6. If single record in relation R is associated with zero or more number of records in relation S, and single record in S is associated with any number of records in R, then the relationship is
    One-to-One
    One-to-Many
    Many-to-One
    Many-to-Many

7. If single record in relation R is associated with zero or more number of records in relation S, and any single record in S is associated with only one record in R, then the relationship is
    One-to-One
    One-to-Many from R to S
    Many-to-One from R to S
    Many-to-Many

8. A minimal super key (i.e, one of the super keys for which no proper subset is a super key) is called
    Super Key
    Candidate Key
    Primary Key
    Both Candidate and Primary key

9. An entity set which does not have enough attributes to form a Primary key is
    Strong Entity Set
    Weak Entity Set
    Strong Relationship Set
    Weak Relationship Set

10. In an ER Diagram, a double ellipse is used to represent
    Simple Attribute
    Composite Attribute
    Descriptive Attribute
    Multi-valued Attribute

Score =

Correct answers:

2 comments:

  1. Answer of question 7 should be many to one

    ReplyDelete
    Replies
    1. Thanks Bharat. Actually the given answers do not have enough information. Now I have include the from and to entity sets. According to the question, the answer is One-to-many from R to S. R is one side. S is many side. If you don't understand, please write to me.

      Delete

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