Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6691 Views
- Sonata, I also Faced
- E-Mail Answers
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
How to revise and re-run the last sql command?
What are all the different normalizations?
How do you respond to dementia behavior?
How many types of relationship are there?
How many sql statements are used?
What is scalar function in sql?
Which join is default?
Explain what is rdbms?
Can delete statement be rollbacked?
Define union, minus, union all, intersect ?
how to show all tables with 'mysql'? : Sql dba
Define join and name different types of joins?
Define the select into statement.
Why does sql need a server?
What are different joins used in sql?
