What is the difference between drop and truncate commands?

0 Answers  

---

What sql database should I use?

0 Answers  

---

what is explain plan?

4 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---

What is %type in sql?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is offset in sql query?

0 Answers  

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

How do I trace sql profiler?

0 Answers  

---

Where the sql database files are stored?

0 Answers  

---

What is the execution plan in sql?

0 Answers  

---