How to restrict the duplicate records in table valuesets

Answers were Sorted based on User's Feedback



How to restrict the duplicate records in table valuesets..

Answer / znaukak

Create unique key for this column where value should be
inserted.

Is This Answer Correct ?    12 Yes 1 No

How to restrict the duplicate records in table valuesets..

Answer / 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

More Oracle General Interview Questions

how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,


what is Single Byte Overhead...?

0 Answers  


what is meant by magic query

0 Answers  


how to select second mauximum value in a given table under salary column

6 Answers   Sapient,


What is Parallel Server ?

3 Answers  


Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  


what is candidate key & super key

1 Answers  


What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  


How does Oracle guarantee data integrity of data changes?

0 Answers  


Whats the benefit of dbms_stats over analyze?

0 Answers  


What is a Sequence ?

3 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)