Sail E0 Webinar

MCQs

Total Questions : 60 | Page 5 of 6 pages
Question 41.  A foreign key is:
  1.    a column containing the primary key of another table.
  2.    used to define data types.
  3.    used to define null status.
  4.    all of the above are above correct.
 Discuss Question
Answer: Option A. -> a column containing the primary key of another table.
Question 42.  Which of the following columns is(are) are required in a table?
  1.    A foreign key
  2.    An alternate key
  3.    A primary key
  4.    A surrogate key.
 Discuss Question
Answer: Option C. -> A primary key
Question 43. . Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
  1.    Null status
  2.    Data type
  3.    Default value
  4.    Data constraints
 Discuss Question
Answer: Option C. -> Default value
Question 44.  In a 1:1 relationship, the foreign key is placed in:
  1.    either table without specifying parent and child tables.
  2.    the parent table.
  3.    the child table.
  4.    either the parent table or the child table.
 Discuss Question
Answer: Option A. -> either table without specifying parent and child tables.
Question 45. . Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
  1.    A domain constraint
  2.    A range constraint
  3.    An intrarelation constraint
  4.    An interrelation constraint
 Discuss Question
Answer: Option C. -> An intrarelation constraint
Question 46. . The identifier of an entity will become the ________ of the new table.
  1.    foreign key
  2.    main attribute
  3.    primary key
  4.    identity key
 Discuss Question
Answer: Option C. -> primary key
Question 47. . Which is not true about surrogate keys?
  1.    They are short.
  2.    They are fixed.
  3.    They have meaning to the user.
  4.    They are numeric.
 Discuss Question
Answer: Option C. -> They have meaning to the user.
Question 48. . A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
  1.    primary key.
  2.    foreign key.
  3.    composite key.
  4.    surrogate key.
 Discuss Question
Answer: Option D. -> surrogate key.
Question 49. . 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 50. . 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

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