Interested to Buy Any Domain ? << Click Here >> for more details...
How to restrict the duplicate records in table valuesets
- 2 Answers
- 7367 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shalini gupta
we can create a unique index as well as primary key
constrains to restrict dulpicate record. unique key allows
one null but primary key constrains does not allow null.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How will you identify oracle database software release?
How a tablespace is related to data files?
how to handle exceptions in post production
How to do clean up if create database failed?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to use "if" statements on multiple conditions?
Explain an extent?
Explain alias?
How to grant create session privilege to a user in oracle?
What is a table index?
How to insert multiple rows with one insert statement in oracle?
How to write numeric literals in oracle?
What are the database administrators utilities available?
Give the various exception types.
