Answer / monal

IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

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

0 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

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

0 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  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

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

0 Answers   Oracle,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---