What are the recovery models for a database? : sql server DBA
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
What is checkpoint?
Name three advisory statistics you can collect.
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 is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What purpose does the model database server? : sql server DBA
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Give the stages of instance startup to a usable state where normal users may access it.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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?
Explain an ORA-01555
Compare and contrast TRUNCATE and DELETE for a table.