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.
Answer Posted / 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 View All Answers
Is sql a oracle?
What is sql constant?
What is coalesce sql?
What port does sql server use?
how to get a list of columns in an existing table? : Sql dba
How many types of indexes are there in sql?
how to calculate the difference between two dates? : Sql dba
Why truncate is faster than delete?
how to extract a unit value from a date and time? : Sql dba
What is mdb stand for?
What are local and global Indexes and where they are useful.
What are the two different parts of the pl/sql packages?
What is sql trigger example?
What is the maximum number of columns in sql table?
which types of join is used in sql widely? : Sql dba