You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
No Answer is Posted For this Question
Be the First to Post Answer
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
what do you understand by fine-grained auditing?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Which environment variables are absolutely critical in order to run the OUI?
Explain the use of table functions.
How do you open a cluster administrator? : sql server DBA
how to restore files with rman?
Give the reasoning behind using an index.