Answer Posted / nishi

Time the references to occur when master tables are not in use. Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.

How to use values from other tables in update statements using oracle?

1024

---

what is IDE,DMV in sql server?

2753

---

How many types of auditing in Oracle?

980

---

What is hash cluster in oracle?

1087

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1934

---

What is a initialization parameter file in oracle?

987

---

Please explain oracle left join with an example?

958

---

How to insert a record into a table?

1019

---

Can we insert data in view oracle?

958

---

How to list all indexes in your schema?

1031

---

What is materialized view in Oracle?

1042

---

How to build data dictionary view an new database?

958

---

State the various uses of dbcc command?

989

---

What do you mean by redo log file mirroring?

975

---

interview questions with answer for cts

2532

---