• +91 9971497814
  • info@interviewmaterial.com

Oracle Interview Questions Answers

Question 1 : What use of command line parameter cmd file?

Answer 1 : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

Question 2 : What is mean by Program Global Area (PGA)?

Answer 2 : It is area in memory that is used by a single Oracle user process.

Question 3 : What are the three types of user exits available ?

Answer 3 : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

Question 4 : What is a SNAPSHOT ?

Answer 4 : Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.

Question 5 : How can values be passed bet. precompiler exits & Oracle call interface?

Answer 5 : By using the statement EXECIAFGET & EXECIAFPUT.

Question 6 : What is Tablespace Quota ?

Answer 6 : The collective amount of disk space available to the objects in a schema on a particular tablespace.

Question 7 : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Answer 7 : True

Question 8 : What are the built-ins that are used for setting the LOV properties at runtime?

Answer 8 : get_lov_property set_lov_property

Question 9 : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Answer 9 : False

Question 10 : What is the use of image_zoom built-in?

Answer 10 : To manipulate images in image items.

Oracle Contributors


Share your email for latest updates


Our partners