Database Administration Question:
What is the difference between indexes,views,synonyms?
Answer:
An index is a method of allowing faster retrieval of records.
A view is an virtual table formed using a single table or one or more tables.
A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects
A view is an virtual table formed using a single table or one or more tables.
A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects
| Previous Question | Next Question |
| Tell us Do you need a commit after DDL statements? | Explain What are the basic element of base configuration of an Oracle database? |