Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
- 7 Answers
- 21620 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kittu
using hot backup u can backup controlfile @ oracle lever by issuing the "alter database backup controlfile to trace;" or "alter database backup controlfile to '/userdefined_path/control_backup.ctl"
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Why would you use sql agent? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
what is asm?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is dbcc? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
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.
What are the different ways you can create databases in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
