Answer Posted / kittu_chintu2005
logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the difference between clustered and non-clustered index? : sql server DBA
how can you record information about current session?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how can you implement fine-grained auditing?
How would you go about verifying the network name that the local_listener is currently using?
Where do you find the default index fill factor and how to change it? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what are the performance views in an oracle rac environment?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you enable flashback feature?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is a correlated sub-query? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA