Difference between primary key and unique key ?
- 77 Answers
- 198016 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
query optmization techniques and quwry analyser+projects+ppts
Explain the use of tables option in exp command.
How to use group functions in the select clause using oracle?
Is java required for oracle client?
Who developed oracle & when?
How many data types are supported?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What happens if the update subquery returns multiple rows?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What are the varoius components of physical database structure of oracle database?
What is the sid in oracle?
What is a nvl function? How can it be used?
What are the tools for Oracle ?
What is procedure overloading in oracle?
What is PL/SQL ?
