Sail E0 Webinar

MCQs

Total Questions : 29 | Page 1 of 3 pages
Question 1. A transitive dependency is which of the following?
  1.    A functional dependency between two or more key attributes.
  2.    A relation that is in first normal form.
  3.    A relation that is in second normal form.
  4.    A functional dependency between two or more nonkey attributes.
 Discuss Question
Answer: Option D. -> A functional dependency between two or more nonkey attributes.
Question 2. A foreign key is which of the following?
  1.    The same thing as a primary key
  2.    An attribute that serves no purpose
  3.    An attribute that serves as the primary key of another relation
  4.    Any attribute
 Discuss Question
Answer: Option C. -> An attribute that serves as the primary key of another relation
Question 3. The entity integrity rule states that:
  1.    no primary key attribute may be null.
  2.    no primary key may be equal to a value in a foreign key.
  3.    no primary key may be unique.
  4.    no primary key can be composite.
 Discuss Question
Answer: Option A. -> no primary key attribute may be null.
Question 4. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
  1.    First normal form
  2.    Third normal form
  3.    Second normal form
  4.    Fourth normal form
 Discuss Question
Answer: Option C. -> Second normal form
Question 5. When mapping a many-to-many unary relationship into a relation which of the following is true?
  1.    Four relations are created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    One relation is created.
 Discuss Question
Answer: Option B. -> Two relations are created.
Question 6. If no multivalued attributes exist in a relation, then the relation is in what normal form?
  1.    Fourth normal form
  2.    Third normal form
  3.    Second normal form
  4.    First normal form
 Discuss Question
Answer: Option C. -> Second normal form
Question 7. When mapping a binary many-to-many relationship into a relation which of the following is true?
  1.    Four relations are created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    One relation is created.
 Discuss Question
Answer: Option C. -> Three relations are created.
Question 8. A primary key is which of the following?
  1.    An attribute that uniquely identifies each column
  2.    A derived attribute
  3.    An attribute that uniquely identifies each row
  4.    Any attribute
 Discuss Question
Answer: Option C. -> An attribute that uniquely identifies each row
Question 9. When mapping a multivalued attribute into a relation which of the following is true?
  1.    Four relations are created.
  2.    Two relations are created.
  3.    One relation is created.
  4.    Three relations are created.
 Discuss Question
Answer: Option B. -> Two relations are created.
Question 10. The relational model consists of:
  1.    data redundancy.
  2.    operations using non-SQL languages.
  3.    data in the form of tables.
  4.    unorganized data.
 Discuss Question
Answer: Option C. -> data in the form of tables.

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0