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 difference between hot backup n rman backup?

1 Answers   Value Labs,

---

Oracle 11g new features?

2 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

What is fill factor? : sql server DBA

0 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

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

0 Answers  

---

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

1 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---