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 fill factor? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What authentication modes does sql server support? : sql server DBA
what is the difference between hot backup n rman backup?
how can a session indicate its interest in receiving alerts?
Give two examples of how you might determine the structure of the table DEPT.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the difference between Datapump & export/import?
How would you extract DDL of a table without using a GUI tool?
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
If we issue alter database begin backup. What happens to database?
How many packages we have in db