Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 26291 Views
- Amazon, Cap Gemini, Infosys, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ambresh pratap srivastava
primary key is combination of column which uniquely specify a row.A table have at most one primary key. primary key creates Clustered Index.A primary key column allows no row having null value
Unique key can uniquely identify each row in a table and is closely related to super key concept.A unique key comprises a single column or a group of column.A unique key column allows only one row having null value.Unique key creates unclustered Index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert characters to dates in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is set operator oracle?
What are the limitations oracle database 10g xe?
How does oracle handle read consistency?
What is oracle latest version?
Is java required for oracle client?
What are the restrictions in a oracle read only transaction?
How to load excel data sheet to oracle database
How to sort the query output in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain temporal data types in oracle
How to display employee records who gets more salary than the average salary in the department?
What is the difference between formal parameters and actual parameters?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
