Answer / ramesh

From Scott Schema

1.Desc Dept

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

Answer / 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;

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

How many memory layers are in the shared pool?

3 Answers  

---

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

0 Answers  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

Describe what redo logs are.

1 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---