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 is a nvl function? How can it be used?

565

---

What is oracle used for?

538

---

Explain rename?

557

---

What is transaction control statement and how many types of transaction control statement in Oracle?

565

---

Describe an oracle table?

577

---

---

What is merge statement used for?

573

---

How to Truncate Table in Oracle

659

---

How to revoke create session privilege from a user in oracle?

559

---

What is SQL access advisor in Oracle?

634

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2395

---

How to load data through external tables?

585

---

How to connect to a local oracle 10g xe server?

539

---

What is an Oracle index?

1181

---

What is hot backup and logical backup?

612

---

What is the difference between sharding and replication?

480

---