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;

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1 Answers  

---

what is grd?

1 Answers   Oracle,

---

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

1 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

1 Answers  

---

What are the commands used in dcl? : sql server DBA

1 Answers  

---

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?

1 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is a system database and what is a user database? : sql server DBA

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

Where would you look for errors from the database engine?

1 Answers   IBM,

---