Answer Posted / guest

2.cold backup
4.No

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1012

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1126

---

how can you initialize log miner?

1153

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1204

---

What is a correlated sub-query? : sql server DBA

1094

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2285

---

how can you schedule a job in database?

1131

---

How do you trace the traffic hitting a sql server? : sql server DBA

1579

---

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?

1987

---

what is the role of dip user in our database?

2417

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1022

---

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.

1736

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2048

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2447

---

What happens on checkpoint? : sql server DBA

1099

---