what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / patel gopikumar
PRIMARY KEY : it is a key that not allow null value in database tables field....
UNIQUE KEY : it is a key that store or manage data uniquely...
FOREIGN KEY : it is key that use is...connect two fields in the different tables........with foreign key......
thnks........
s-150907-007 PATEL GOPIKUMAR
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
5. Explain about relational algebra.
What is database client?
What does specialization in DBMS mean?
When should you not use firebase?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What are the types of indexes that are present inside a database?
How heap is implemented in database?
Which is the best graph database?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Give the syntax of exception handling used in DBMS?
What happens when shared and exclusive locks are applied on data item?
Explain the various types of normalization.