Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18035 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / kirti
Yes.When a column is assigned primary key it means it
contains unique value(i.e. no duplicate value is allowed) &
it can't accept null values.
Whereas unique key means no duplicare value is allowed, but
null value is allowed. And not null means no null value is
accepted but duplicate value can be passed.
So when we assign primary key to a column, the column
becomes both unique & not null.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I reset a sequence in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is oracle join syntax?
What is a user role in oracle?
Explain the truncate in oracle?
Explain the difference between replace() and translate() functions in oracle?
Explain what does a control file contain?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a sub query? Describe its types?
What is program global area (pga) in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Can sub procedure/function be called recursively?
How to create a new table by selecting rows from another table?
Can we create database in oracle using command line ?
