Answer Posted / gangaram

1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1164

---

what are the performance views in an oracle rac environment?

1121

---

what are the benefits of flashback feature?

1089

---

what do you understand by flashback feature of oracle?

1043

---

What types of replication are supported in sql server? : sql server DBA

1348

---

What are the steps you will take to improve performance of a poor performing query?

2897

---

what is the use of ocr?

1074

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2036

---

What would you do with an "in-doubt" distributed transaction?

1934

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2042

---

Can you redefine a table online?

1154

---

Query processing is slow(eg select query)how will u solve that

8037

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2043

---

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.

2212

---

Where would you look for errors from the database engine?

2897

---