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
- 17233 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
Can the “if update (colname)” statement be used in a delete trigger?
What are the new data types are introduced in sql 2000?
Define cross join in sql server joins?
What are functions in the sql server?
How to invoke a trigger on demand?
How to rebuild indexes with alter index ... Rebuild?
How to insert data with null values?
How to filter out duplications in the returning rows in ms sql server?
Explain about nested stored procedure?
What are trace files?
Can you explain what is sql server english query?
How to query multiple tables jointly?
What is exclusive locks?
What does this statement do @@rowcount?
Give main differences between "Truncate" and "Delete".
