Database Administration Question:
Download Job Interview Questions and Answers PDF
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
Download Database Administration Interview Questions And Answers
PDF
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? |