Multiple Choice Questions for Relational Model

  • 1 Which of the following keyword is used in SQL Query to enforce referential integrity?
    1. Primary Key
    2. References
    3. Foreign Key
    4. Uses

  • 2 An ___________ is a distinct object (a person, place, thing, concept, or event) in the organization that is to be represented in the database.
    1. entity
    2. attribute
    3. both
    4. non of above

  • 3 If candidate having two attributes A &B as composite candidate key, what is right from following options for this composite candidate key?
    1. Attribute A must have unique values, but attribute B may not have unique values
    2. Attribute B must have unique values, but attribute A may not have unique values
    3. Attribute A must have unique values as well as attribute B must have unique values
    4. Attribute A and attribute B collectively must have unique values

  • 4 Which one of the following is NOT a property of a Relation/Table:
    1. Each Relation/table name is distinct in relational schema
    2. Each cell of relation/table contains exactly one atomic (single) value
    3. There can be duplicate tuples/rows in a relation/table
    4. Each attribute has a distinct name

  • 5 What is right for the entity integrity?
    1. It is not necessary that every relation has a primary key
    2. The attribute of primary key must have non-null values
    3. Sometimes the values in primary key may be repeated
    4. All of above options are right

  • 6 In referential integrity constraint, the foreign key value is allowed to be null if:
    1. Value is known
    2. Relationship is mandatory
    3. Relationship is optional
    4. Non of above

  • 7 There is a relation Student (stID, sName, city), where city and sName attributes may have repeated values, but stID cannot have repeated values, then which one of the following can be a candidate key in the relation:
    1. city attribute
    2. stID attribute
    3. sName attribute
    4. None of above

  • 8 A key that consists of two or more attributes is known as:
    1. Primary Key
    2. Composite Key
    3. Unique Key
    4. None of above

  • 9 Which of the following contains entities and is a group of objects with the same properties identified by the enterprise as having an independent existence?
    1. Relationship Type
    2. Entity Type
    3. Database Management System
    4. Database

  • 10 Which type of the following constraint will stop you from inserting a non-numeric value in a field within a numeric attributes?
    1. Domain
    2. Entity
    3. General
    4. Multipliciy

  • 11 Which of the following statements are true for foreign key:
    1. Always unique
    2. Never unique
    3. May be unique
    4. None

  • 12 An attribute, or set of attributes, selected for unique identification of tuple within a relation is called:
    1. Security Key
    2. Foreign Key
    3. Primary Key
    4. Relational Key

  • 13 The set of allowable values for an attribute is called:
    1. Domain
    2. DBMS
    3. Relation
    4. Data Set

  • 14 An attribute is a named column (also called property) of a:
    1. Database
    2. DBMS
    3. Relation
    4. Application

  • 15 Which of the following key CANNOT BE NULL?
    1. Alternate
    2. Primary
    3. Foreign
    4. All

  • 16 Which terminology define the number of attributes in a relation?
    1. Tuple
    2. Cardinality
    3. Degree
    4. Row

  • 17 A Gerund is actually a:
    1. Many-to-Many Relationship
    2. Many-to-One Relationship
    3. One-to-Many Relationship
    4. Always a recursive Relationship

  • 18 The number of entities involved in a relationship is called:
    1. Degree of relationship
    2. Level of relationship
    3. Level of entities
    4. Degree of entities

  • 19 An attribute that can be further divided into sub attributes is called:
    1. Composite attribute
    2. Combined attribute
    3. Collective attribute
    4. Single Attribute

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides the visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

Contact Us
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert