Answer Posted / uday

The best thing would be to create a trigger which checks and not allows duplicate data .

Create or replace trigger trig1
before insert or update on t1
for each row
declare
a number (10);
begin
select count(*) into a from t1 where col2 = :new.col2;
if a >= 1 then
raise_application_error(-20123,'data already present and data will not insert');
elsif a = 0 then
dbms_output.put_line('inserted');
end if;
end;

Name the three major set of files on disk that compose a database in Oracle?

1067

---

what are bitmap indexes? How does they work?

2184

---

What are the benefits of ordbms?

1024

---

How to invoke the data pump export utility?

1117

---

What is translate in oracle?

1051

---

What is oracle latest version?

1039

---

What is the difference between post-database commit and post-form commit?

1108

---

What is BBED in Oracle?

1091

---

In which language oracle has been developed?

1016

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2022

---

What is the difference between I and G in Oracle?

1023

---

Explain about achiever in sql?

981

---

What is an index associated with a constraint?

975

---

does the query needs a hint to access a materialized view?

1817

---

What language does oracle use?

1049

---