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

Why would you call update statistics? : sql server DBA

947

---

who owns the operating system files created by the utl_file package?

1010

---

How would you go about verifying the network name that the local_listener is currently using?

3157

---

what is the use of ocr?

964

---

Where would you look for errors from the database engine?

2792

---

What are the steps you will take to improve performance of a poor performing query?

2792

---

what are the differences of where and if in SAS?

2134

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2192

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1937

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2398

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1188

---

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

986

---

What are the different sql server versions you have worked on? : sql server DBA

964

---

What happens on checkpoint? : sql server DBA

1031

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2447

---