Answer / radha

To check database is in which mode

1. Conn sys/sys as sysdba
2. select log_mode from v$database

To set database in Archivelog mode

1. shutdown immediate;
2. startup mount;
3. alter database archivelog;
4. alter database open;

To set database in NoArchivelog Mode
1. shutdown immediate;
2. startup mount;
3. alter database noarchivelog;
4. alter database open;

What are the system resources that can be controlled through Profile ?

3 Answers  

---

What are the options available to refresh snapshots ?

2 Answers  

---

What is the use of ANALYZE command ?

3 Answers  

---

What is Tablespace Quota ?

2 Answers  

---

How will you enforce security using stored procedures ?

2 Answers  

---

What is a trace file and how is it created ?

2 Answers  

---

How can you enable automatic archiving ?

2 Answers  

---

What are the minimum parameters should exist in the parameter file (init.ora) ?

1 Answers  

---

what is meant by physical order and logical order in clustered index and non clustered index.

2 Answers  

---

What are the different Levels of Auditing ?

1 Answers  

---

How can we reduce the network traffic ?

3 Answers   Keane India Ltd,

---

What is Object Auditing ?

2 Answers  

---