How will you copy the structure of a table witho

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

121. How will you copy the structure of a table without copying the data?

Answer1
create table xyz
as ( select * from abc where 1=0)

Answer2
create table New_tbl as select * from Old_tbl where rownum

Answer3
select top 0 * into xyz from try

(Continued on next question...)

Other Job Interview Questions

• You see multiple fragments in the SYSTEM tablespace, what should you check first?
• How do I eliminate the duplicate rows ?
• How can you tell if a database object is invalid?
• Give the stages of instance startup to a usable state where normal users may access it.
• How do I eliminate the duplicate rows ?
• Explain what partitioning is and what its benefit is.
• What are the built-in used for getting cell values?
• What are the various sub events a mouse double click event involves?
• What is Database Link?
• What is trigger associated with the timer?
• More...