Sail E0 Webinar

MCQs

Total Questions : 17 | Page 2 of 2 pages
Question 11. Data integrity constraints are used to
  1.    Control who is allowed access to the data
  2.    Ensure that duplicate records are not entered into the table
  3.    Improve the quality of data entered for a specific property
  4.    Prevent users from changing the values stored in the table
 Discuss Question
Answer: Option C. -> Improve the quality of data entered for a specific property


Improve the quality of data entered for a specific propertyThe data entered will be in a particular cell (i.e., table column) .


Question 12. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
  1.    Entity Integrity Constraints
  2.    Referential Integrity Constraints
  3.    Domain Integrity Constraints
  4.    Domain Constraints
 Discuss Question
Answer: Option B. -> Referential Integrity Constraints


Referential Integrity Constraints


Question 13. Which one of the following uniquely identifies the elements in the relation?
  1.    Secondary Key
  2.    Primary key
  3.    Foreign key
  4.    Composite key
 Discuss Question
Answer: Option B. -> Primary key


Primary keyPrimary key checks for not null and uniqueness constraint


Question 14. Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
  1.    Attributes
  2.    Data integrity constraints
  3.    Method constraints
  4.    Referential integrity constraints
 Discuss Question
Answer: Option B. -> Data integrity constraints


Data integrity constraintsOnly particular value satsfying the constraints are entered in column .


Question 15. Which of the following can be addressed by enforcing a referential integrity constraint?
  1.    All phone numbers must include the area code
  2.    Certain fields are required (such as the email address, or phone number) before the record is accepted
  3.    Information on the customer must be known before anything can be sold to that customer
  4.    Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than 'a dozen')
 Discuss Question
Answer: Option C. -> Information on the customer must be known before anything can be sold to that customer


Information on the customer must be known before anything can be sold to that customer


Question 16. Drop Table cannot be used to drop a table referenced by a _________ constraint.
  1.    Local Key
  2.    Primary Key
  3.    Composite Key
  4.    Foreign Key
 Discuss Question
Answer: Option D. -> Foreign Key


Foreign KeyForeign key is used when primary key of one relation is used in another relation .


Question 17. ____________ is preferred method for enforcing data integrity
  1.    Constraints
  2.    Stored Procedure
  3.    Triggers
  4.    Cursors
 Discuss Question
Answer: Option A. -> Constraints


ConstraintsConstraints are specified to restrict entries in the relation.


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