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
How would you go about verifying the network name that the local_listener is currently using?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what functionality does oracle provide to secure sensitive information?
how can you record information about current session?
What are the different sql server versions you have worked on? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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?
what is logical system in sap basis
What are the recovery models for a database? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
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
what is the use of ocr?