Sail E0 Webinar

MCQs

Total Questions : 65 | Page 1 of 7 pages
Question 1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
  1.    A → B.
  2.    A → C.
  3.    A → (B,C).
  4.    (B,C) → A.
 Discuss Question
Answer: Option A. -> A → B.
Question 2. The different classes of relations created by the technique for preventing modification anomalies are called:
  1.    normal forms.
  2.    referential integrity constraints.
  3.    functional dependencies.
  4.    None of the above is correct.
 Discuss Question
Answer: Option A. -> normal forms.
Question 3. The primary key is selected from the:
  1.    composite keys.
  2.    determinants.
  3.    candidate keys.
  4.    foreign keys.
 Discuss Question
Answer: Option C. -> candidate keys.
Question 4. Row is synonymous with the term:
  1.    record.
  2.    relation.
  3.    column.
  4.    field.
 Discuss Question
Answer: Option A. -> record.
Question 5. A relation is in this form if it is in BCNF and has no multivalued dependencies:
  1.    second normal form.
  2.    third normal form.
  3.    fourth normal form.
  4.    domain/key normal form.
 Discuss Question
Answer: Option C. -> fourth normal form.
Question 6. Which of the following is a group of one or more attributes that uniquely identifies a row?
  1.    Key
  2.    Determinant
  3.    Tuple
  4.    Relation
 Discuss Question
Answer: Option A. -> Key
Question 7. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
  1.    transitive dependency.
  2.    insertion anomaly.
  3.    referential integrity constraint.
  4.    normal form.
 Discuss Question
Answer: Option C. -> referential integrity constraint.
Question 8. A relation is considered a:
  1.    Column.
  2.    one-dimensional table.
  3.    two-dimensional table.
  4.    three-dimensional table.
 Discuss Question
Answer: Option C. -> two-dimensional table.
Question 9. In the relational model, relationships between relations or tables are created by using:
  1.    composite keys.
  2.    determinants.
  3.    candidate keys.
  4.    foreign keys.
 Discuss Question
Answer: Option D. -> foreign keys.
Question 10. A functional dependency is a relationship between or among:
  1.    tables.
  2.    rows.
  3.    relations.
  4.    attributes.
 Discuss Question
Answer: Option D. -> attributes.

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