What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

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

0 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

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?

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

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.

0 Answers  

---

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

0 Answers   Oracle,

---