Answer Posted / jijnasa behera
Foreign key is the primary key of the other table which is
helpful for referential integrity. it is helpful when we
make join to more than one table.
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is an application role and explain a scenario when you would use one?
Explain about a primary key?
Why does this query return 0?
What are the constraints on severity level in raiseerror?
Which four data types cannot be used as a return type from a user-defined function?
How is data stored in dbms?
What are the types of database model?
explain detail about ftp in datastage?
How to read and create .LDC data files which are used by linguatic dictionary.
What are data modelling techniques?
Explain about relational operator join?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is the maximum length of an extended property?
Explain about query and reporting.
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?