Answer Posted / nageswararao.kamineni

we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.

Give the different types of rollback segments.

1031

---

How would you change old and new values in an insert, delete and update triggers?

1022

---

Differentiate between translate and replace?

1123

---

What is a cognitive schema?

973

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2070

---

How to do a full database export?

1114

---

Explain integrity constraints?

1109

---

What are the database administrators utilities available?

1032

---

What are the uses of a database trigger?

994

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

---

What is the maximum number of triggers that can be applied to a single table?

1029

---

What are the differences between interval year to month and interval day to second?

1028

---

Explain the use of ignore option in imp command.

1037

---

What happens if the update subquery returns multiple rows?

1117

---

How do you store pictures in a database?

1008

---