How will you a activate/deactivate integrity constraints?
Answer Posted / j
Alter table table_name ENABLE constraint constraint_name;
Alter table table_name DISABLE constraint constraint_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are all the common sql functions?
How many row comparison operators are used while working with a subquery?
what does it mean to have quoted_identifier on? : Sql dba
What is rtm stands for?
what is bdb (berkeleydb)? : Sql dba
Is join and inner join the same?
Explain the difference between sql and mysql.
When do we use triggers?
What is the location of pre_defined_functions.
explain the difference between delete , truncate and drop commands? : Sql dba
Name the operator which is used in the query for pattern matching?
What is record data type?
What is the difference between the conventional and direct path loader? : aql loader
What schema means?
What is an escape character in sql?