Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

What is synonyms and give an example of synonyms?

The CREATE SYNONYM statement allows you to create a synonym which is an alternative name or alias name for a database object such as a table, procedure, view, sequence, stored function, and materialized view.

following is the basic syntax of creating a new synonym:

CREATE [OR REPLACE] [PUBLIC] SYNONYM schema.synonym_name FOR schema.object;

following is the basic example of creating a new synonym:

CREATE PUBLIC SYNONYM product FOR jward.products_data;
After the public synonym is created, you can query the table PRODUCT_DATA with a simple SQL statement:
SELECT * FROM product;


Next 5 interview question(s)

What is a synonyms?
What is an oracle schema?
What is a deadlock? Explain?
What is hash cluster?
Difference between an implicit & an explicit cursor.?