Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of how you might determine the structure
of the table DEPT.
- 2 Answers
- 11473 Views
- I also Faced
- E-Mail Answers
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
What is the default fill factor value? : sql server DBA
how can you implement fine-grained auditing?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Can you redefine a table online?
How would you extract DDL of a table without using a GUI tool?
What are the different types of indexes available in sql server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Query processing is slow(eg select query)how will u solve that
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
which background process invoke at the time of upgradation tell me???
Which autogrowth database setting is good? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
