Answer Posted / chandrashekar

These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources just so long as it conforms to ASCII formatted or delimited files.

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1985

---

what functionality does oracle provide to secure sensitive information?

993

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2064

---

Can you redefine a table online?

1115

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1005

---

What is the default port no on which sql server listens? : sql server DBA

1161

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

993

---

how can you connect from 10g user to 11g user??

2113

---

How to start SQL Server in minimal configuration mode?

7969

---

Where would you look for errors from the database engine?

2849

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1067

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1759

---

what do you understand by flashback feature of oracle?

993

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1078

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2112

---