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

Answer Posted / ramesh

From Scott Schema

1.Desc Dept

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

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1711


Where would you look for errors from the database engine?

2574


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2272


how can you process messages in order asynchronously?

731


how does an oracle clusterware manage crs resources?

763


what is a crs resource?

839


how can you schedule a job in database?

797


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

763


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

753


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3484


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

811


what is a user-defined lock?

757


Why does Oracle not permit the use of PCTUSED with indexes?

2574


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

889


how can you communicate with operating system files from oracle?

771