Answer / vaishnav

4. No. B'coz for online Backups database should be in
ARCHIVELOG mode.

Answer / muhammad masood

1-HOT BACKUP AND COLD BACKUP
2- Cold
3- No... Should take complete backup as no incarnation
level is defined.
4- No without Archive loging.

Answer / guest

2.cold backup
4.No

Answer / gangaram

1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.

Answer / s. manzoor ahamed

1. Type of Backups option in oracle are
Cold backup / Hot (Online) backup, Logical backups
using Exp and imp client utilities, RMAN Backups.

2. Only Cold backup can be taken and no other options.

3. No. Need to take full consistent backup.

4. No. You can't take online backup if the db is configured
in Noarchivelog mode.

Answer / vinay prakash

1.cold backup, hot backup

2.cold backup

3.No

4. no (in Archivelog mode backup is in online)

Answer / ashok

logical backups:... exp imp datapump
physical backup:... cold,hot rman

2)cold only

3)no

4) no

Answer / srihari macha

1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.

Answer / harshith

1.logical backup
expdp

2.physical backup
rman
hot backup
cold backup

Answer / sree

1. physical and Logical backup
2.cold backup
3.No.. we can't take partial backup in no archivelog mode
4.No... we can't take online backups if the database running in noarchivelog mode.

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

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

2 Answers  

Hot backup procedure?

2 Answers  

How would you determine the time zone under which a database was operating?

2 Answers  

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

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

2 Answers