what is the use of foreginkey
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Explain what a database is?
Explain about network model?
What is denormalization and when would you go for it?
What are defaults? Is there a column to which a default can't be bound?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me
What are the main phases of database development?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
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?
Explain about relational operator join?
Can you instantiate a COM object by using T-SQL?
What is the maximum length of an extended property?
Who are naive users?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)