How write primary and foreign key relationship between two
tables without using constraints? u can use any of
procedure/function/trigger and any sql?



How write primary and foreign key relationship between two tables without using constraints? u can..

Answer / raju

we can achive this using triggers

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How to revise and re-run the last sql command?

0 Answers  


How many types of cursors are available in pl/sql?

0 Answers  


What is procedure in pl sql?

0 Answers  


how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  


What is TABLE SPACE?

4 Answers   ABB, TCS,






How can triggers be used for the table auditing?

0 Answers  


write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,


Why do we create views in sql?

0 Answers  


How many joins in sql?

0 Answers  


what are the advantages a stored procedure? : Sql dba

0 Answers  


I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,


Cite the differences between execution of triggers and stored procedures?

0 Answers  


Categories