Answer / kittu

in two ways we can check
1) archive log list
2) select log_mode from v$database;

Answer / krishna

archive log list
select log_mode from v$database;

How do you add a data file to a tablespace?

3 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

How would you force a log switch?

4 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

---

what is the use of ocr?

0 Answers   Oracle,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---