Oracle General Interview Questions
Questions Answers Views Company eMail

What are Schema Objects ?

2 4425

Can objects of the same Schema reside in different tablespaces.?

3 8230

Can a Tablespace hold objects from different Schemes ?

3 6332

what is Table ?

2 4315

What is a View ?

3 5347

Do View contain Data ?

10 20691

Can a View based on another View ?

3 10654

What are the advantages of Views ?

3 8800

What is a Sequence ?

3 5483

What is a Synonym ?

3 5929

What are the type of Synonyms?

1 5099

What is a Private Synonyms ?

1 4204

What is a Public Synonyms ?

1 4066

What are synonyms used for ?

3 5653

What is an Index ?

2 5818


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

defination of bitmap index

1619


What is an index associated with a constraint?

550


How to use "startup" command to start default instance?

540


How to assign query results to variables?

586


When do we use group by clause in a sql query?

565






Difference between hot backup vs. Cold backup?

602


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1798


What is meant by joins? List out the types of joins.

519


What are the types of partitions in oracle?

536


What do you mean by a deadlock?

513


What is ceil and floor in oracle?

569


How to load excel data sheet to oracle database

582


Explain the use of grant option in exp command.

578


What is the difference between postgresql and oracle?

503


Explain the use of indexes option in exp command.

590