A table is classified as a parent table and you want to drop and re-create it.

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?

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

More DB Administration Interview Questions

what is the difference between catalog & nocatalog?

Name two files used for network connection to a database.

What types of replication are supported in sql server? : sql server DBA

What are the different ways you can create databases in sql server? : sql server DBA

What background process refreshes materialized views?

How can you gather statistics on a table?

what is the diffrence between core dba and apps dba?

Give the stages of instance startup to a usable state where normal users may access it.

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

What is the default port no on which sql server listens? : sql server DBA

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

For more DB Administration Interview Questions Click Here