Answer Posted / ramesh

SQL Loader and IMPORT are ORACLE utilities

SQL Loader is used to Load the Data from Delimiter Seperted
files and files with fixed and Vaariable width Text
One can also use plsql functions and procedures to load
desired foramtted data


Import is the Utility that can only tool that understands
Oracle Export Utility used to manke logical backup against
Database/Schemas

what is grd?

1084

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1094

---

What are the operating modes in which database mirroring runs? : sql server DBA

1171

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2797

---

what is the use of recording information about current session?

1046

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

979

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2671

---

Why would you use sql agent? : sql server DBA

1073

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1898

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3401

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2326

---

What would you do with an "in-doubt" distributed transaction?

1879

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2347

---

What is dbcc? : sql server DBA

1274

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1029

---