Answer Posted / mohapatra.gouranga@gmail.com

Recovery is not possible if no backup.
But inconsistent recovery is possible by following method:
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1958

---

what are the benefits of flashback feature?

1089

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2123

---

what are the types of connection load-balancing?

1043

---

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

1260

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1055

---

What is the default port no on which sql server listens? : sql server DBA

1213

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2043

---

What are the steps you will take to improve performance of a poor performing query?

2897

---

how can you process messages in order asynchronously?

1034

---

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

1157

---

What authentication modes does sql server support? : sql server DBA

1265

---

how does an oracle clusterware manage crs resources?

1135

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1361

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2505

---