Give two examples of how you might determine the structure
of the table DEPT.
- 2 Answers
- 10943 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is dcl? : sql server DBA
What is the default fill factor value? : sql server DBA
What purpose does the model database server? : 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 a user-defined lock?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can a session indicate its interest in receiving alerts?
