Answer Posted / basobdutta

Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.

Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible

What happens on checkpoint? : sql server DBA

653

---

what is the use of recording information about current session?

658

---

what is ora 24313?what is the procedure to exclude that error?

2197

---

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

759

---

What are the recovery models for a database? : sql server DBA

682

---

---

What are the operating modes in which database mirroring runs? : sql server DBA

725

---

how does an oracle clusterware manage crs resources?

658

---

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

2499

---

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.

1797

---

which background process invoke at the time of upgradation tell me???

2325

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1689

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

691

---

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.

1322

---

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

673

---

what functionality does oracle provide to secure sensitive information?

649

---