Answer Posted / anand

oracle

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

943

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

---

What according to you is the difference between mysql and sql server performance?

1062

---

What are the differences between local and global temporary tables?

1059

---

What do you mean by an execution plan? Why is it used?

994

---

What have included columns when we talk about sql server indexing?

1016

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2008

---

How to skip remaining statements in a loop block using continue statements?

979

---

What is the difference between lock, block and deadlock? : sql server database administration

1025

---

Determine when an index is appropriate?

1054

---

What is the difference between a function and a trigger?

1061

---

How do I view a trc file?

924

---

Explain the third normal form(3nf)?

923

---

Does union all remove duplicates?

1050

---

What is sql injection and why is it a problem? : sql server security

1113

---