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.

What is the quickest way to export a table to a flat file?

968

---

Compare and contrast between sql and sql server and explain its various functions?

964

---

What is a oracle database?

1055

---

Whether any commands are used for months calculation? If so, what are they?

1097

---

What is a connect identifier?

1039

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---

material view and view disadvantages?

1073

---

How can you use check constraints for self referential integrity?

971

---

How to select some columns from a table in oracle?

1095

---

How to set a transaction to be read only in oracle?

1093

---

Explain the use of online redo log files in oracle.

1038

---

How to count duplicated values in a column in oracle?

1043

---

Please explain compound trigger in oracle?

1058

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2623

---

How to invoke the original export import utilities?

1064

---