What is Primary key and foreign key? Give an example
Answers were Sorted based on User's Feedback
Answer / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / brajesh kumar srivastava
Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / aaaaaaaaaaaaa
Primary key is a primary key that is an attribute.
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / alquama rizvi
MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.
| Is This Answer Correct ? | 0 Yes | 0 No |
What does it mean to normalize a database and why would you do it?
What is isnull() operator?
What are different replication agents and what's their purpose? : sql server replication
What is SCOPE_IDENTITY() in sql
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How can I change procedure name in sql server?
What are the differences between left join and inner join in sql server?
What are the kinds of subquery?
What is cdc in sql server?
What are different types of statements that are supported by sql?
Write a program to fetch first 10 records from a file?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Oracle (3253)
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)