Answer Posted / neo devan

Any key may/maynot satisfy 2 conditions :
* Not Null
* Unique
Unique key is tne one which satifies the second condition
but it can have null values.

What happens if you use a wrong connect identifier?

503

---

Explain oracle’s system global area (sga).

626

---

How to empty your oracle recycle bin?

573

---

What is difference between sid and service name in oracle?

519

---

What is the scope of a local variable?

585

---

---

How can I get column names from a table in oracle?

534

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

546

---

What is hot backup and logical backup?

608

---

Explain the use of record option in exp command.

533

---

Explain drop constraint oracle?

589

---

How to use "startup" command to start default instance?

542

---

What is a user role in oracle?

613

---

How to connect to oracle using service name instead of sid?

553

---

What happens in oracle commit?

568

---

What is the string concatenation operator in oracle?

568

---