Quiz 4

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