what are primary key and foreign key ?
- 4 Answers
- 6001 Views
- Tesco, I also Faced
- E-Mail Answers
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 |
Why are recursive relationships are bad? How do you resolve them?
Briefly describe an outer join.
What's the difference between file and database?
What are new features postgre 9.1?
Is there a database program for mac?
What is network database?
How to do replication of firebird databases?
RDBMS file system can be defined as
Which database is best for storing images?
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
Explain all codd's rules for relational database system?
What are the characteristics of dbms?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
