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

How insert into statements in sql?

0 Answers  

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

What is interval partition?

0 Answers  

What is a temporal table?

0 Answers  

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

What kind of join is join?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

What is the use of triggers?

0 Answers  

What are database links used for?

0 Answers  

Give the structure of the procedure ?

1 Answers  

how to create a new view in mysql? : Sql dba

0 Answers  

What is sql server and ase?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories