Answer / Jitendra Kumar Kanaujia

Firstly, check if the Oracle Client software is correctly installed on your machine. If it is, ensure that the TNS_ADMIN environment variable is set to the location of your tnsnames.ora file. Restart your SQL client and try logging in again.

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

How can you gather statistics on a table?

3 Answers  

---

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?

1 Answers  

---

Where would you look for errors from the database engine?

1 Answers   IBM,

---

Can you redefine a table online?

1 Answers   Oracle,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1 Answers  

---

how can you initialize log miner?

1 Answers   Oracle,

---

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

1 Answers  

---

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

1 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

what is a crs resource?

1 Answers   Oracle,

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---