what are primary key and foreign key ?
Answers were Sorted based on User's Feedback
Answer / neo devan
Primary key is the attribute which satisfies both
uniqueness and Not null constraints.
The foreign key is a attribute that points to a valid
column in a parent table.
its used for referencing primary key.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rukumanikhandhan
primary key is the key which follows uniqueness in the
entire table.
primary key of one table will be called as foreign key in
another table.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / sabeena parveen
primary key is an attribute which uniquely identifies each
record in the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / radha
Columns acting as a primary key will always hold unique
values.
Foreign key should always be a primary key of some table
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the best database software?
Explain the hierarchical database?
What are the steps involved in Instance Recovery ?
When connection to database is failed, Which exception will be thrown?
How do I create a database?
What is the use of RECORD LENGTH option in EXP command ?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What is openedge abl in terms of taking the perspective of the developer?
What is primary key in dbms?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
Why is group-clause used?
What is actional flow mapping?
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)