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

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

Question Posted / guest

2 Answers
10515 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / 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

More DB Administration Interview Questions

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

how can you record information about current session?

0 Answers Oracle,

How many memory layers are in the shared pool?

3 Answers

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

how can you process messages in order asynchronously?

0 Answers Oracle,

what are the differences of where and if in SAS?

0 Answers

When a user process fails, what background process cleans up after it?

1 Answers

How would you determine who has added a row to a table?

4 Answers

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers

What is RAID and what are different types of RAID configurations?

1 Answers

What are the recovery models for a database? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here