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
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
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?
Why would you use sql agent? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the default port no on which sql server listens? : sql server DBA
What is a correlated sub-query? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
who owns the operating system files created by the utl_file package?
how to restore files with rman?
What happens on checkpoint? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What would you do with an "in-doubt" distributed transaction?