Answer Posted / nagesh yadav

1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2036

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1112

---

What is the difference between clustered and non-clustered index? : sql server DBA

1091

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2568

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2551

---

What is the default fill factor value? : sql server DBA

1129

---

how can you find out if a table can be redefined?

1016

---

What are the different sql server versions you have worked on? : sql server DBA

1013

---

Explain about your sql server dba experience? : sql server DBA

1088

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2413

---

What are the operating modes in which database mirroring runs? : sql server DBA

1188

---

what is asm?

1052

---

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

2720

---

What are the different types of indexes available in sql server? : sql server DBA

1208

---

how can you implement fine-grained auditing?

1136

---