what is the difference between hot backup n rman backup?
Answer / ramakrishnachallapalli
To take both backups we should keep database in archive log
mode.
Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify
RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely
Is This Answer Correct ? | 27 Yes | 3 No |
Explain an ORA-01555
How do you tell what your machine name is and what is its IP address?
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Why would you call update statistics? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You're getting high "busy buffer waits" - how can you find what's causing it?
Which environment variables are absolutely critical in order to run the OUI?
What is a correlated sub-query? : sql server DBA
Explain materialized views and how they are used.
Give two methods you could use to determine what DDL changes have been made.