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
- 16969 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / vikash kr pandey
1> JOIN:- JOIN IS USED TO VIEW AND RETRIEVE DATA FROM MULTIPLE TABLE OR RELATED TABLES IN A SINGLE RESULT SET.
2> PRIMARY KEY:-PRIMARY KEY IS A SET OF COLUMNS WHOSE VALUES UNIQUELY IDENTIFY ALL THE ROWS IN A TABLE AND CAN NOT CONTAIN NULL VALUES.
3> FORIEGN KEY:-A COLUMN IN ONE TABLE WHOSE VALUES MATCH THE PRIMARY KEY IN SOME OTHER TABLE IS CALLED A FORIEGN KEY.
4> CANDIDATE KEY:-ANY ATTRIBUTE THAT IS UNIQUELY IDENTIFIES A ROW IN A TABLE IS A CANDIDATE FOR THE PRIMARY KEY. THIS TYPE OF ATTRIBUTE IS CALLED CANDIDATE KEY.
5> SUPER KEY:-THE SUPERTYPE IS DESCRIBED BY ATTRIBUTES THAT BELONGS TO ALL SUBTYPES AND CONNECTED TO THE RELATIONSHIP WITH A LINE CONTAINING A CROSSBAR.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Do you know what is user defined datatypes and when you should go for them?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Mention the differences between local and global temporary tables.
Can coalesce return null?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What does it mean to normalize data?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Explain the disadvantages of cursors?
What is a view and what are its advantages?
What is the difference between the application object and session object?
What is the difference between indexing and hashing?
How to compare the top two records using sql?
Difference between Inner vs outer joins?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
what method you can use to reduce the overhead of Reporting Services data sources?
