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 not null in sql?
what is the syntax for using sql_variant_property? : Transact sql
How does join work in sql?
How run sql*plus commands that are stored in a local file?
How to revise and re-run the last sql command?
How does left join work in sql?
How to fetch alternate records from a table?
What is sql*loader and what is it used for? : aql loader
Are views faster than queries?
What is an inconsistent dependency?
Is sql a dbms?
what are myisam tables? : Sql dba
What is rank dense_rank and partition in sql?
What is full join?
Can instead of triggers be used to fire once for each statement on a view?