Sail E0 Webinar

MCQs

Total Questions : 60 | Page 6 of 6 pages
Question 51. . If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
  1.    the primary key
  2.    any alternate key
  3.    a surrogate key
  4.    a foreign key
 Discuss Question
Answer: Option A. -> the primary key
Question 52. . Each entity is represented as a(n):
  1.    tuple.
  2.    table.
  3.    attribute.
  4.    file.
 Discuss Question
Answer: Option B. -> table.
Question 53. . Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
  1.    MUST COVER
  2.    MUST NOT
  3.    Both of the above.
  4.    None of the above is correct.
 Discuss Question
Answer: Option A. -> MUST COVER
Question 54. . Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
 Discuss Question
Answer: Option D. -> Data constraints
Question 55. . For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
  1.    Two
  2.    Three
  3.    Four
  4.    Six
 Discuss Question
Answer: Option D. -> Six
Question 56. . If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
  1.    the primary key
  2.    any alternate key
  3.    a surrogate key
  4.    a foreign key
 Discuss Question
Answer: Option A. -> the primary key
Question 57. . For every relationship, how many possible sets of minimum cardinalities are there?
  1.    Two
  2.    Three
  3.    Four
  4.    Six
 Discuss Question
Answer: Option C. -> Four
Question 58. . Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
 Discuss Question
Answer: Option D. -> Data constraints
Question 59. . Each entity is represented as a(n):
  1.    tuple.
  2.    table.
  3.    attribute.
  4.    file.
 Discuss Question
Answer: Option B. -> table.
Question 60. . Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
  1.    MUST COVER
  2.    MUST NOT
  3.    Both of the above.
  4.    None of the above is correct.
 Discuss Question
Answer: Option A. -> MUST COVER

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