Sign Up Login


  1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

List the parts of a database trigger.

 810

Explain oracle’s server parameter file.

 783

Explain overloading. Can functions be overloaded?

 803

Give the advantages and disadvantages of clusters.

 813

Define oracle database

 815

Explain oracle instance.

 926

What is ceil and floor in oracle?

 828

Can a parameter be passed to a cursor?

 839

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

 844

Explain user account with reference to oracle.

 784

Explain constraining triggers.

 874

What is the maximum limit on the number of columns in a table?

 785

Why do you create or replace procedures rather that drop and recreate.

 776

How would you change old and new values in an insert, delete and update triggers?

 797

Explain oracle’s system global area (sga).

 888

Un-Answered Questions { Oracle }

Which is the best option used to move database from one server to another serve on same network and why?

372

Can group functions be used in the order by clause in oracle?

792

How many concurrent programs you have customized, can you name some of them?

1

Can group functions be mixed with non-group selection fields?

771

What are the key characteristics of rac or why to use rac?

1

Explain the use of Merge statement in oracle 11g

813

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2738

What are the components required to manage oracle real application clusters database?

1

What is snapshot is too old? Give and example for better understand.

1349

What is a dba certification?

409

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2015

Explain the difference between sap and oracle?

792

What is the quickest way to export a table to a flat file?

776

Explain the use of ignore option in imp command.

794

How can we view last record added to a table?

814

For More Un-Answered { Oracle } Questions Click Here