what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
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
What is tcl in sql server?
Explain how would you store your query in an SSRS report or a Database server?
What is #temp and @table variable in SQL server?
What is the need for group functions in sql?
What is raid and what are different types of raid levels?
How to test odbc dsn connection settings?
How to insert multiple rows with one insert statement in ms sql server?
What are the various editions of sql server 2017 that are available in the market?
What is an execution plan? How would you view the execution plan?
Explain what is row_number function?
How to configure and test odbc dsn settings?
please differentiate between delete and truncate?
Explain what is the function of sql server agent windows service?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Introduction of rollup clause using sum and group by clause?