What are synonyms used for ?

Question Posted / guest

3 Answers
6873 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are synonyms used for ?..

Answer / swapna

Synonyms are used to provide alternate name for a table
permanently.

Is This Answer Correct ?

4 Yes

0 No

What are synonyms used for ?..

Answer / annu rajput

Synonym is used to give the global name to the table name
in the database.
In other words we can say that it is the annother
permanent name for
the table.

Thanks
Annu_Rajput

Is This Answer Correct ?

3 Yes

0 No

What are synonyms used for ?..

Answer / nishi

- Mask the real name and owner of an object.

- Provide public access to an object

- Provide location transparency for tables, views or program units of a remote database.

- Simplify the SQL statements for database users.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What types of joins are used in writing subqueries?

0 Answers

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers

can u plz provide me oca sql dumps please i need them

0 Answers

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers Bravura Solutions, Cap Gemini,

What are a collation and state the different types of collation sensitivity?

0 Answers

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?