• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 131 : - What are the built-ins that are used to Attach an LOV programmatically to an item?

Answer - 131 : - set_item_property get_item_property (by setting the LOV_NAME property)

Question - 132 : - What are built-ins used for Processing rows?

Answer - 132 : - GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION_COUNT(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(procedure) SET_GROUP_SELECTION(procedure) UNSET_GROUP_SELECTION(procedure)

Question - 133 : - What is an administrative (privileged) user?

Answer - 133 : - Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow access to a database instance even if it is not running. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.

Question - 134 : - Explain about horizontal, Vertical tool bar canvas views?

Answer - 134 : - Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window

Question - 135 : - What is snapshot log ?

Answer - 135 : - It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available for simple snapshots. It should be created before creating snapshots.

Question - 136 : - What is new_form built-in?

Answer - 136 : - When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.

Question - 137 : - What is Two-Phase Commit ?

Answer - 137 : - Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

Question - 138 : - How do you reference a Parameter?

Answer - 138 : - In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

Question - 139 : - How do you create a new session while open a new form?

Answer - 139 : - Using open_form built-in setting the session option Ex. Open_form('Stocks ',active, session). when invoke the multiple forms with open form and call_form in the same application, state whether the following are true/False

Question - 140 : - What is a public synonym?

Answer - 140 : - Any database user can access a public synonym.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners