Answer / Tanmay Arya

Object Identifiers (OIDs) are used in databases for unique identification of database objects. To generate OIDs, you can use the following methods:nn- Sequences: In PostgreSQL, for example, you can create a sequence and then fetch the next value from it to be used as an OID.n- Functions: Some databases provide built-in functions to generate OIDs, such as the `oid` function in Oracle.

what is difference between primary key and unique key ?

2 Answers  

---

How can I detect whether a given connection is blocked?

1 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1 Answers  

---

Explain about relational operator join?

1 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

What is dbms and its application?

1 Answers  

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

1 Answers  

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

What is data modeling with example?

1 Answers  

---

Which data type cannot be used as a parameter in a udf?

1 Answers  

---

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

1 Answers  

---