To include integrity constraint in a existing relation use : Options: A . &nbspCreate table B . &nbspModify table C . &nbspAlter table

To include integrity constraint in a existing relation use :

Question

To include integrity constraint in a existing relation use :

Options:

A . Create table

B . Modify table

C . Alter table

Answer: Option C

Alter tableSYNTAX “ alter table table-name add constraint , where constraint can be any constraint on the relation.

Was this answer helpful ?

Next Question

Question 1. Domain constraints, functional dependency and referential integrity are special forms of _________. ....

Question 2. Foreign key is the one in which the ________ of one relation is referenced in another relation. ....

Question 3. Which of the following is the right syntax for assertion? ....

Question 4. Data integrity constraints are used to: ....

Question 5. _____________, express the number of entities to which another entity can be associated via a relationship set. ....

Question 6. Which of the following can be addressed by enforcing a referential integrity constraint? ....

Question 7. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in ....with at most one entity in A.This is called as

Question 8. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (....with any number (zero or more) of entities in A.

Question 9. Data integrity constraints are used to ....

Question 10. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relation....that relates two relations & maintains consistency across the relations.

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

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