Font size
WorksheetsQuiz 4
Total questions: 20
Worksheet time: 20mins
Which one of the following uniquely identifies the elements in the relation?
Secondary Key
Primary key
Foreign key
Composite key
An entity set that does not have sufficient attributes to form a primary key is termed a __________
Strong entity set
Variant set
Weak entity set
Variable set
Weak entity set is represented as
Underline
Double line
Double diamond
Double rectangle
E-R modelling technique is a :
Top-down approach
Bottom-up approach
Left-right approach
None of the above
The number of entities to which another entity can be associated via a relationship set is expressed as :
Entity
Cardinality
Schema
Attributes
An Identifying relationship in ER diagram is represented by_________
Oval Shape with double line
Rectangular Shape with double line
Square Shape with double line
Rhombus shape with double line
3. Identify the following the correct way/s to delete all rows at a time from salary
DELETE * FROM salary;
TRUNCATE TABLE salary;
DELETE FROM SALARY;
TRUNCATE TABLE FROM salary;
The set of key attributes that identify Weak Entities related to some owner Entity is classified as
Structural key
Partial key
Primary Key
Foreign Key
In ER Diagram the Total Participation is shown by_________
Single Line
Double Line
Dotted Line
Double dotted line
In ER Diagram the Key attributes are represented by________
Oval Shape and Under Line
Oval Shape and Double line
Square Shape and underline
Square Shape and Double line
In ER Diagram the Partial Key is also called as
Subordinate
descriminator
Incremental
cartesian ordinate
In ER Diagram the Existence dependency is shown by
double dotted line
single line
double line
triple dotted line
The Relationship set with degree 3 can be classified as
Unary
Binary
Ternary
Quarternary
The Identifying Entity Type is also called as
Owner Entity Type
String Entity type
Evidence Entity type
Float Entity type
The type of participation constraints are
Total and partial
Intensive and extensive
intensive and extensive
floating and string
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
Simple attribute
Composite attribute
Multi valued attribute
Derived attribute
Which of the following gives a logical structure of the database graphically?
Entity-relationship diagram
Entity diagram
Database diagram
Architectural representation
A recursive relationship is a relationship between an entity and ________
itself
a subtype entity
an archetype entity
an instance entity
Which of the following is NOT a basic element of all versions of the E-R model?
Entities
Attributes
Relationships
Primary keys
In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.A.B.C.D.
parent
child
instance
subtype
