Difference between primary key and unique key ?
Answer Posted / satendra dixit
Primary Key
1. Not Null
2. One primary key can be defined at on table
Unique Key
1. May be Null
2. one or more then 1, can be implemented
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
what is insert all statement in sql
Differentiate between pre-select and pre-query?
How to export data with a field delimiter?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Write a syntax for update query in oracle?
What is meant by an index?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to load a large xml file?
What are the ansi data types supported in oracle?
What are the varoius components of physical database structure of oracle database?
State and explain about oracle instance?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to start your 10g xe server from command line?