What are the recovery models for a database? : sql server DBA


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

Post New Answer

More DB Administration Interview Questions

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  


What is checkpoint?

3 Answers   Accenture,


Name three advisory statistics you can collect.

1 Answers  


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?

0 Answers  


What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  


What purpose does the model database server? : sql server DBA

0 Answers  


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  


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

1 Answers  


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  


mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,


Explain an ORA-01555

2 Answers  


Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  


Categories