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

create a store procedure and created synonms for that store
procedure after modify that store procedure will effect on
synonms?
If we delete the store procedure what happened to that synonms?

Question Posted / shivainduja

Answers were Sorted based on User's Feedback



create a store procedure and created synonms for that store procedure after modify that store proce..

Answer / ankush

A synonym is an alternative name for objects such as
tables, views, sequences, stored procedures, and other
database objects.

So naming convention dose not effect the object if the
object code is update or modify.


The synonym exists in the datbase but it is in a invalid
state.

Is This Answer Correct ?    5 Yes 0 No

create a store procedure and created synonms for that store procedure after modify that store proce..

Answer / shivaindu

If you update in store procedure it will not effort in synonyms.

If we delete the store procedure that synonyms will not
delete but it won’t work.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

Is postgresql a server?

0 Answers  

What jobs use sql?

0 Answers  

Is left join same as join?

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

What are the types of join and explain each?

0 Answers  

Are sql database names case sensitive?

0 Answers  

Enlist the data types that can be used in pl/sql?

0 Answers  

What is Collation Sensitivity ? What are the various type ?

0 Answers  

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

For more SQL PLSQL Interview Questions Click Here
Categories