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 is Privilege Auditing ?

1 Answers  

---

What are the database administrators utilities avaliable ?

2 Answers  

---

What are the benefits of distributed options in databases ?

1 Answers  

---

What are the responsibilities of a Database Administrator ?

3 Answers  

---

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

2 Answers  

---

what is different between view and sequence?

4 Answers  

---

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

1 Answers  

---

What dynamic data replication ?

2 Answers  

---

What are the various type of snapshots ?

3 Answers  

---

what is the step for rmanbackup?

1 Answers  

---

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 Answers  

---

What are roles ? How can we implement roles ?

2 Answers  

---