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,

---

how many tupples can insert in 1 second in sql

1 Answers  

---

What is spool?

0 Answers  

---

What are the advantages of stored procedure?

0 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

Why partition by is used in sql?

0 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

What are the parts of a sql statement?

0 Answers  

---

What is sql table?

0 Answers  

---

What are the triggers associated with image items?

0 Answers  

---

Why do we use joins?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---