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 / 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 |
What does data normalization mean?
Why do we use procedures in pl sql?
When are we going to use truncate and delete?
what is meant by forward declaration in functions?
In packages the source code is compiled into p code ? how do we describe the p code
What is where clause in sql?
Is sql between inclusive?
What is Difference Between delete and Truncate?
How many types of primary keys are there?
what is the command for user data type?
What is triggering circuit?
What is the use of partition by in sql?