Interested to Buy Any Domain ? << Click Here >> for more details...
Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
- 1 Answers
- 10801 Views
- I also Faced
- E-Mail Answers
Answer / sapan saxena
Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.
| Is This Answer Correct ? | 41 Yes | 2 No |
What is sql server transaction log file?
How to create a Master database in SQL server ?
What is the purpose of grouping data in a report?
How is a full-text index updated?
Explain the cursor lock types?
Explain transaction server implicit?
What are the steps to follow to configure SQL*Net?
How to execute a sql statement using odbc_exec()?
tell me the disaster recovery plan
What is logshipping and its purpose?
Selet all the data from table where last name is n of employee
What are the instances when triggers are appropriate?
-
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)
