• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 161 : - With which function of summary item is the compute at options required?

Answer - 161 : - percentage of total functions.

Question - 162 : - What is a difference between pre-select and pre-query?

Answer - 162 : - Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

Question - 163 : - What are Roles ?

Answer - 163 : - Roles are named groups of related privileges that are granted to users or other roles.

Question - 164 : - What are the different types of Record Groups?

Answer - 164 : - Query Record Groups NonQuery Record Groups State Record Groups

Question - 165 : - How do you reference a parameter indirectly?

Answer - 165 : - To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

Question - 166 : - What are the different Parameter types?

Answer - 166 : - Text ParametersData Parameters

Question - 167 : - 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 - 167 : - True

Question - 168 : - How is link tool operation different bet. reports 2 & 2.5?

Answer - 168 : - In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Question - 169 : - What is the use of ANALYZE command ?

Answer - 169 : - To perform one of these function on an index, table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the object used by object from the data dictionary. - To validate the structure of the object. - To identify migrated and chained rows of the table or cluster.

Question - 170 : - What are different types of modules available in oracle form?

Answer - 170 : - Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners