How can you Enforce Referential Integrity in snapshots ?
Answer / nishi
Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the maximum number of CHECK constraints that can be defined on a column ?
What is sequence?
How to resolve name conflicts between variables and columns?
What is a Sequence ?
How can you use check constraints for self referential integrity?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Can a parameter be passed to a cursor?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how to retrive xml data for using sql query?
what is Table ?
How do we get field details of a table?
what is primary key and foreign key when and where have to use