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.






Which one of the following is a reason that an INSERT statement might cause an error instead of ex..

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

Post New Answer




More SQL PLSQL Interview Questions

What is Difference Between delete and Truncate?

9 Answers  


Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,


a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   IBM, CGI,


What is Temp Table and type of temp table?

1 Answers   HP, SLK,


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,






Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,


what is oltp (online transaction processing)? : Sql dba

0 Answers  


how to create table with in the procedure or function?

2 Answers   HCL, Genpact,


What is the basic structure of PL/SQL ?

6 Answers  


If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  


How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   KCP, Fidelity,


Explain unique key in sql.

0 Answers  






Categories