Database Administration Question:

Download Job Interview Questions and Answers PDF

What is the difference between indexes,views,synonyms?

Database Administration Interview Question
Database Administration Interview Question

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

Download Database Administration Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us Do you need a commit after DDL statements?Explain What are the basic element of base configuration of an Oracle database?