Answer / ankush

Data integrity refers to the validity of data, meaning data
is consistent and correct.

Answer / avr murthy

Data integrity allows to define certain data quality
requirements that the data in the database needs to meet.
If a user tries to insert data that doesn't meet these
requirements, Oracle will not allow so.

Answer / naidu

Data integrity is which all the data values stored in the
database are correct and enforcing data integrity ensures
the quality of the data in the database

Can we create table in function?

0 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

Is a view faster than a stored procedure?

0 Answers  

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

Is sql procedural language?

0 Answers  

---

Is primary key an index?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

what is definer rights invoke rights?

1 Answers  

---

what is user defined functions? : Sql dba

0 Answers  

---