Menu
Popular Courses
Sail E0 20253 months
Fast Math Tricks165 videos
Quantitative Aptitude645 Videos
Reasoning Aptitude161 Videos
CLASS 8 MATHS(CBSE)417 Videos
CLASS 9 MATHS(CBSE)40 hours, 647 questions
Check All Courses
Search

MCQs

Total Questions : 40 | Page 1 of 4 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.    An intrarelation constraint
  2.    A range constraint
  3.    An interrelation constraint
  4.    A domain constraint
 Discuss Question
Answer: Option D. -> A domain constraint
Question 2. A primary key should be defined as:
  1.    None of these
  2.    Either of the above can be used.
  3.    NULL.
  4.    NOT NULL.
 Discuss Question
Answer: Option D. -> NOT NULL.
Question 3. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
  1.    Default value
  2.    Data constraints
  3.    Data type
  4.    Null status
 Discuss Question
Answer: Option C. -> Data type
Question 4. Which of the following column properties specifies whether or not cells in a column must contain a data value?
  1.    Data type
  2.    Data constraints
  3.    Null status
  4.    Default value
 Discuss Question
Answer: Option C. -> Null status
Question 5. In a 1:N relationship, the foreign key is placed in:
  1.    the child table.
  2.    either the parent table or the child table.
  3.    the parent table.
  4.    either table without specifying parent and child tables.
 Discuss Question
Answer: Option A. -> the child table.
Question 6. In a 1:1 relationship, the foreign key is placed in:
  1.    either table without specifying parent and child tables.
  2.    either the parent table or the child table.
  3.    the child table.
  4.    the parent table.
 Discuss Question
Answer: Option A. -> either table without specifying parent and child tables.
Question 7. A foreign key is:
  1.    used to define data types.
  2.    All of these
  3.    a column containing the primary key of another table.
  4.    used to define null status.
 Discuss Question
Answer: Option C. -> a column containing the primary key of another table.
Question 8. Which of the following situation requires the use of ID-dependent entities?
  1.    Archetype/instance relationships only
  2.    Multivalued attributes only
  3.    All of these
  4.    Association relationships only
 Discuss Question
Answer: Option C. -> All of these
Question 9. 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.    Data type
  2.    Data constraints
  3.    Default value
  4.    Null status
 Discuss Question
Answer: Option C. -> Default value
Question 10. Which of the following columns is(are) are required in a table?
  1.    A surrogate key
  2.    An alternate key
  3.    A primary key
  4.    A foreign key
 Discuss Question
Answer: Option C. -> A primary key

Share this page with your friends!

Share this page with your friends!

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDI 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

Chapter 3.1 : Overview of Finance & Acco Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024