Answer / kittu_chintu2005

logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup

Answer / srinivas

In sqlserver 8 types of backups

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup

Answer / rohit bhosale

In SQL server 2008 we have following types of backup:

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup

Answer / mahinder singh

Type of backup

1. Normal backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

2. copy backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

3. incremental backup(A backup of those files which have
changed since the last backup of any type.)

4. differential backup(A backup of those files which have
changes since the last full backup. Should be performed at
regular intervals.)

Answer / suman

three types of backups that is
1.physical backup:cold backup and hot backup
2.logical backup: export/import utility provided by oracle
3.Rman backup

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

How to start SQL Server in minimal configuration mode?

1 Answers  

How would you go about increasing the buffer cache hit ratio?

2 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

How can you gather statistics on a table?

3 Answers