Sail E0 Webinar

MCQs

Total Questions : 65 | Page 5 of 7 pages
Question 41.  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 42.  Row is synonymous with the term:
  1.    record.
  2.    relation.
  3.    column.
  4.    field.
 Discuss Question
Answer: Option A. -> record.
Question 43.  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 44.  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 45.  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 46.  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 47.  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 48. . For some relations, changing the data can have undesirable consequences called:
  1.    referential integrity constraints.
  2.    modification anomalies.
  3.    normal forms.
  4.    transitive dependencies.
 Discuss Question
Answer: Option B. -> modification anomalies.
Question 49. . A functional dependency is a relationship between or among:
  1.    tables.
  2.    rows.
  3.    relations.
  4.    attributes.
 Discuss Question
Answer: Option D. -> attributes.
Question 50. . Which of the following is not a restriction for a table to be a relation?
  1.    The cells of the table must contain a single value.
  2.    All of the entries in any column must be of the same kind.
  3.    The columns must be ordered.
  4.    No two rows in a table may be identical.
 Discuss Question
Answer: Option C. -> The columns must be ordered.

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