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
- 6725 Views
- Sonata, I also Faced
- E-Mail Answers
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 is union? : Sql dba
What is ROWID?
what is mean by forward declaration and where we'll use it.
How to run sql functions in pl/sql?
how to add a new column to an existing table in mysql? : Sql dba
What makes a good primary key?
What is primary key secondary key alternate key candidate key?
What is form and report?
How can we implement rollback or commit statement in a trigger?
Define sql delete statement.
What is mutating trigger?
How can you know that statistics should be updated?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
