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 |
What does coalescing a tablespace do?
how can you communicate with operating system files from oracle?
In oracle 10g export, import if we declare rows=y/n what would be the output?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
What type of index should you use on a fact table?
Oracle 11g new features?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can a session indicate its interest in receiving alerts?
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
How to determine the service pack currently installed on SQL Server?
Oracle (3259)
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)