Answer Posted / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Where do you find the default index fill factor and how to change it? : sql server DBA

1121

---

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

1362

---

how can you connect from 10g user to 11g user??

2164

---

how can you record information about current session?

1101

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2268

---

how can you enable flashback feature?

1007

---

what functionality does oracle provide to secure sensitive information?

1049

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1794

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2025

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1996

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2553

---

What is dbcc? : sql server DBA

1348

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2520

---

What are the different ways you can create databases in sql server? : sql server DBA

1191

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2036

---