Which one of the following is a reason that an INSERT statement might cause an

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.

Question Posted / suresh

1 Answers
6671 Views
Sonata, I also Faced
E-Mail Answers

Which one of the following is a reason that an INSERT statement might cause an error instead of ex..

Answer / tulsi

1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.

we cannot modify more than one base table through a join
view.

Is This Answer Correct ?

9 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

What is mutating error?

0 Answers

How is pl sql different from sql?

0 Answers

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers

What is the Diff b/w Constraints and Trigeer

4 Answers HCL,

Is time a data type in sql?

0 Answers

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers Polaris,

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers

Why are sql stored procedures used?

0 Answers

When do we use triggers?