Answer Posted / amrutharao d

1. SQL>Desc Dept

2. SQL>Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

3. SQL>set long 99999
SQL>select dbms_metadata.get_ddl('TABLE','DEPT') from
dual;

Can you redefine a table online?

1117

---

What the different types of replication and why are they used? : sql server DBA

1178

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2203

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

994

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1975

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1976

---

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

2115

---

how does an oracle clusterware manage crs resources?

1088

---

what is logical system in sap basis

1641

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1985

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1081

---

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?

1987

---

how can you record information about current session?

1049

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2568

---

How do you open a cluster administrator? : sql server DBA

1103

---