Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5570 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Synonym is alternate name for a table.
Use of synonyms avoids changes to programs when you migrate
programs from test to production.
create synonym abc for test.abc in test
create synonym abc for prod.abc in production
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vinod
A synonym is used to reference a table or view by another
name. The other name can then be written in the application
code pointing to test tables in the development stage and to
production entities when the code is migrated. The synonym
is linked to the AUTHID that created it.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is RUNSTATS?
What is a view? Why use it?
How Plan is created while executing the query using SPUFI?
What is db2 optimizer?
Explain transactions, commits and rollbacks in DB2.
where will u check for sqlcode ?
What is a composite index and how does it differ from a multiple index?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is a view? Why use it?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What are the disadvantages of using VARCHAR?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
COBOL 
