Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / suresh


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 are the various levels of constraints?

0 Answers  

how to do backup entire database? : Transact sql

0 Answers  

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

What does := mean in pl sql?

0 Answers  

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

What is the sql*loader? : aql loader

0 Answers  

define join and explain different type of joins? : Sql dba

0 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

What is union and union all keyword in sql and what are their differences?

0 Answers  

How do I view a view in sql?

0 Answers  

Does sql backup shrink transaction log?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories