Answer / guest

NOARCHIEVELOG parameter is used to enable the database in
Achive mode as True or false.
If you need to check database is in which mode use this
command:

1.select log_mode from v$database.
IF database needs to be set in Archivelog Mode
2. Shutdown immediate
3. Startup mount
4. alter database archivelog
5. alter database open

What is the importance of query in database?

0 Answers  

---

Do models have limitations?

0 Answers  

---

Mention how deadlock can be resolved?

0 Answers  

---

What is the purpose of a database table?

0 Answers  

---

what is difference between clustering and mirroring?

2 Answers   Religare,

---

---

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).

5 Answers   Satyam,

---

What is the use of OWNER option in EXP command ?

1 Answers  

---

What are different partitioning techniques in database?

0 Answers  

---

Can you drop all the columns of a table ?

0 Answers   MCN Solutions,

---

What is a candidate key in dbms?

0 Answers  

---

Enlist some commands of dcl?

0 Answers  

---

How a Store Procedure called with a cursor out parameter.?

0 Answers   MCN Solutions,

---