Answer / Gopal Ji

An Application Role is a database-level role that represents a group of users from the application level. It allows users to be granted access to specific database objects through roles, simplifying security management across multiple users. A common scenario for using an application role is when you want to grant specific permissions to all users who authenticate to the database through your application.

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Explain about the relational database?

1 Answers  

---

Why does this query return 0?

1 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

What are the main phases of database development?

1 Answers  

---

Explain about the database management systems.

1 Answers  

---

Explain about the storage and physical database design?

1 Answers  

---

What is an application role and explain a scenario when you would use one?

1 Answers  

---

How to replace not in with not exist?

1 Answers  

---

Write short notes on manual refreshes.

1 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---