Answer / guest

o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

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

0 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

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?

0 Answers   EDS,

---

Explain an ORA-01555

2 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---