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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Where would you look for errors from the database engine?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you process messages in order asynchronously?
how does an oracle clusterware manage crs resources?
what is a crs resource?
how can you schedule a job in database?
What are the commands used in dcl? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what is a user-defined lock?
Why does Oracle not permit the use of PCTUSED with indexes?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you communicate with operating system files from oracle?