Difference between primary key and unique key ?
Answer Posted / dj
Primary key creates Clustered Index.
Unique key creates non-clustered Index
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
What is format trigger?
material view and view disadvantages?
What are the database administrators utilities available?
How to sort output in descending order in oracle?
Is oracle a relational database?
What is oracle server autotrace in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How to delete all rows a table in oracle?
How to create id with auto_increment on oracle?
What is a subquery?
What are the different types of failures that occur in Oracle database?
Explain the use of Merge statement in oracle 11g
What are group functions in oracle?
How to connect to a local oracle 10g xe server?
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.