Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between off-line back up and on-line
back up in ibm db2 udb?
- 2 Answers
- 9006 Views
- Zenith, I also Faced
- E-Mail Answers
Answer Posted / guest
online backup:
1.Inconsistent
2.database in open state.
3.Archive mode must set
offline:
1.consistent
2.db in close
3.No need archive mode
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
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?
What are the commands used in dcl? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are statistics, under what circumstances they go out of date, how do you update them?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
which background process invoke at the time of upgradation tell me???
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you trace the traffic hitting a sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the recovery models for a database? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
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.
