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

Why would you call update statistics? : sql server DBA

Where would you look for errors from the database engine?

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

Explain what partitioning is and what its benefit is.

Give the two types of tables involved in producing a star schema and the type of data theyhold.

how can you get actual data change values from previous transactions in oracle?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

Query processing is slow(eg select query)how will u solve that

what do you understand by fine-grained auditing?

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

Give two methods you could use to determine what DDL changes have been made.

For more DB Administration Interview Questions Click Here