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

Explain top-n analysis in DBMS.

0 Answers   ITC Indian Tobacco Company,

---

Define ddl and dml.

0 Answers  

---

List few restrictions that are imposed while creating views?

0 Answers  

---

Explain the functionality of dml compiler.

0 Answers  

---

What is denormalization and why would someone consider doing so?

0 Answers  

---

From where the Transactions per rollback segment is derived ?

1 Answers  

---

Is access a database program?

0 Answers  

---

how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?

1 Answers   Satyam,

---

What's difference between dbms and rdbms ?

0 Answers  

---

What are the lock types?

0 Answers  

---

What are stored procedures in a database?

0 Answers  

---

What is the use of FILE option in EXP command ?

1 Answers  

---