Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SYNONYM and ALIAS?
- 6 Answers
- 28637 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nandivardhanreddy.n
when the table is dropped automatically synonym is dropped
and it is a private variable.
when the table is dropped alias is not dropped because it
is invalid and it is global variable.
synonym can accesed by the user who creates it
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How will you return the number of records in table?
What are catalog tables in db2?
What action db2 takes when a program aborts in the middle of a transaction?
How do I optimize a query in db2?
Explain packages.
When do you specify the isolation level?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Explain db2.
What is netezza database?
How can deadlocks be resolved?
What are the various data types available in db2?
Is db2 relational database?
Which components manage deadlocks in db2?
What is null indicator in cobol db2?
What is multi row fetch in db2?
