Interested to Buy Any Domain ? << Click Here >> for more details...
what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 16819 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / jebastin unnatha raja
Joins-> Joins allow You to view and retrive the data from multible related tables in a single result set.
Primary key-> A primary key is used to uniquely identify each row in a table.A primary key columns can not contain a nULL values.
foriegn key-> A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data
super Key-> A superkey is a combination of attributes that can be uniquely used to identify a database record. A table might have many superkeys.
Candidate key-> A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to encrypt data between dialogs?
What are the types of joins in sql?
Is sql server a database?
What are the system database in sql server 2008?
Can you please explain the difference between function and stored procedure?
What does set rowcount do?
Is it possible to have clustered index on separate drive from original table location?
What is policy management?
What is mean by candidate key?
Explain about unique identifier data type in sql server?
What is b tree index?
what is blocking? : Sql server database administration
Explain how dts is used to extract, transform and consolidate data?
How optimize sql query with multiple joins in sql server?
What are the different Topologies in which Replication can be configured?
