Describe the different type of Integrity Constraints
supported by ORACLE ?

Answers were Sorted based on User's Feedback



Describe the different type of Integrity Constraints supported by ORACLE ?..

Answer / allin

5 Different integrity constraints are given

1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.

Thanks & Regards,
RatnaRao
9833847339

Is This Answer Correct ?    3 Yes 0 No

Describe the different type of Integrity Constraints supported by ORACLE ?..

Answer / prna

SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle General Interview Questions

How to select some rows from a table in oracle?

0 Answers  


What is the usage of analyze command in oracle?

0 Answers  


What suggestions do you have to reduce the network traffic?

0 Answers  


Explain database link?

0 Answers  


What is the disadvantage of User defind function?

0 Answers   CybAge,






What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,


12 RULES OF RDBMS

1 Answers  


What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  


14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,


What are the predefined tablespaces in a database?

0 Answers  


How to connect to the server with user account: sys?

0 Answers  


What is blob datatype?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)