Sail E0 Webinar

MCQs

Total Questions : 60 | Page 1 of 6 pages
Question 1. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
  1.    A domain constraint
  2.    A range constraint
  3.    An intrarelation constraint
  4.    An interrelation constraint
 Discuss Question
Answer: Option A. -> A domain constraint
Question 2. In a 1:N 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 C. -> the child table.
Question 3. A primary key should be defined as:
  1.    NULL.
  2.    NOT NULL.
  3.    Either of the above can be used.
  4.    None of the above are correct.
 Discuss Question
Answer: Option B. -> NOT NULL.
Question 4. Which of the following situation requires the use of ID-dependent entities?
  1.    Association relationships only
  2.    Multivalued attributes only
  3.    Archetype/instance relationships only
  4.    All of the above use ID dependent entities
 Discuss Question
Answer: Option D. -> All of the above use ID dependent entities
Question 5. 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 6. 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 7. 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 8. 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 9. 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 10. 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

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