Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer / guest
o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.
Is This Answer Correct ? | 3 Yes | 3 No |
In oracle 10g export, import if we declare rows=y/n what would be the output?
What the different components in replication and what is their use? : sql server DBA
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How can you enable a trace for a session?
What is a correlated sub-query? : sql server DBA
How to determine the service pack currently installed on SQL Server?
what are the differences of where and if in SAS?
Hot backup procedure?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What are statistics, under what circumstances they go out of date, how do you update them?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?