what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
Answer Posted / karthik
Join is a keyword which is used to join two or more table.
The unique column in a table is called primary key.
If primary key acting as a normal attribute in some other
table then this attribute is called foreign key.
If table is having more than one unique attribute then the
rest of the attributes of primary key is called candidate key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to download and install microsoft .net framework version 2.0?
What are the requirements to use odbc connections in php scripts?
Explain security with sql azure?
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?
What is the use of stored procedure?
Can you always create a cache of a report?
Define compound operators?
What is sql server transaction log file?
Explain what is dbcc?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is an indexed view?
What is RMS migrations?
Explain transaction isolation levels in sql server?
What is the exact numeric data type in sql?
How to find out what is the default collation in a database?