Answer Posted / hina khuman
foreginkey is use to have relation between two tables,which
requires primary key in master table and that field can be
use by child table through foregin key.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the constraints on severity level in raiseerror?
What is a database development?
What is the physical representation for a many-to-many relationship?
What is database design and development?
What is the database development process?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Explain about the relational database?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How to use timestamp datatypes
Who are end users in dbms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How to replace not in with not exist?
How to combine two function together?
What is dbms explain in brief?