Answer Posted / k

Schema is simply an user to the database wherein the user
can create its own objects in the database.

Are truncate and delete commands same? If so why?

644

---

How to convert character types to numeric types?

566

---

How to use select statement to count the number of rows in oracle?

546

---

Where is the export dump file located?

565

---

How to upsert (update or insert into a table)?

529

---

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1441

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1464

---

What are the roles of dba?

606

---

How to write date and time interval literals in oracle?

563

---

What is transport network substrate (tns) in oracle?

583

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3817

---

How can we find out the duplicate values in an oracle table?

600

---

How to convert characters to numbers in oracle?

584

---

What is a user account in oracle?

618

---

How do I recompile a procedure in oracle?

522

---