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
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to create a testing table with test data in ms sql server?
what is difference between view and Dip.
Explain different types of index?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What do you mean by normalisation?
What is the default server name for sql server?
What is data compression? : sql server database administration
What are the database roles? : sql server security
Can group functions be mixed with non-group selection fields in ms sql server?
What is linked report?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Explain syntax for disabling triggers?
explain how to create a new schema in a database? : Sql server database administration
Explain what is dbcc?