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.






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

how mysql optimizes distinct? : Sql dba

0 Answers  


how view used for security purposes?

3 Answers   Glam India,


what is auto increment? : Sql dba

0 Answers  


how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  


Is pl sql still used?

0 Answers  






What are sql ddl commands?

0 Answers  


What is NOCOPY?

6 Answers   DELL,


Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,


What is embedded sql what are its advantages?

0 Answers  


what is a composite primary key ? : Sql dba

0 Answers  


I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  


What is sorting in sql?

0 Answers  






Categories