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
- 6714 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
Can we join two tables without common column?
what is the difference between group by and order by in sql? : Sql dba
how to rename an existing table in mysql? : Sql dba
What is the most important ddl statements in sql are?
how to create a table index in mysql? : Sql dba
What is serial sql?
Is inner join faster than left join?
Can we create table in function?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How we can update the view?
Is pl sql better than sql?
How do I find duplicates in a single column in sql?
What is data modelling in sql?
how is myisam table stored? : Sql dba
What is rtm in testing?
