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
How would you go about increasing the buffer cache hit ratio?
Name a tablespace automatically created when you create a database.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is blocking and how would you troubleshoot it?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Where in the Oracle directory tree structure are audit traces placed?
When a user process fails, what background process cleans up after it?
Why would you call update statistics? : sql server DBA
Hot backup procedure?
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?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)