Answer Posted / amit bhagat

1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1063

---

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

1076

---

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

2710

---

What is dbcc? : sql server DBA

1274

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2671

---

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

1114

---

how can a session indicate its interest in receiving alerts?

1037

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2162

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1072

---

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

2025

---

what is logical system in sap basis

1633

---

Why would you use sql agent? : sql server DBA

1073

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

981

---

What happens on checkpoint? : sql server DBA

1081

---

Where would you look for errors from the database engine?

2844

---