Oracle Form

Oracle Form interview questions

<<Previous  Next>> 

What is an SQL *FORMS? Oracle Forms is part of Oracle's Internet Developer Suite. Its earlier versions were called SQL*Forms............... Read answer How do you control the constraints in forms? This can be done by selecting the Use Constrain Property to ON............  Read answer When will ON-VALIDATE-FIELD trigger executed? ON-VALIDATE-FIELD triggers are used for field validation. It fires when the field validation status is New or changed............... Read answer What is the difference between system.current_field and system.cursor_field? The only difference between these two is that System.current_field gives name of the field and................ Read answer What are dynamic reports? How will you create them? Following steps should be followed to build a Dynamic Report: Create a temporary table first.............. Read answer Difference between Oracle Forms and Apps Forms. Oracle FormsOracle Forms renders applications using metadata stored in an .fmx file. It runs client-side PL/SQL................. Read answer Sequence of firing triggers in forms  The following sequence should be used to fire triggers when a form opens: 1. Pre-Form  2. Pre-Block.............. Read answer What is a record Group? What are different types of record group? A record group is an oracle forms data structure that has a column/row framework similar to a database table................ Read answer Also read Difference between open_form and call_form Open_form opens the indicated form. Call_form not just opens the indicated form, but also keeps the parent form alive............... Oracle Form What is an SQL *FORMS?, How do you control the constraints in forms?, When will ON-VALIDATE-FIELD trigger executed?, What is the difference between system.current_field and system.cursor_field?............... Use of Roles in oracle Roles in Oracle can be used to grant privileges to a specific group of users for security. The database manager is usually responsible for granting privileges to a Role.......... Oracle large objects What is large object in oracle? Explain its purposes, Explain types of large objects in oracle, i.e. BLOB, LLOB,NCLOB and BFILE............ Oracle Security Explain the security features in Oracle, What are roles? How can we implement roles?, What is user Account in Oracle database?, What is a trace file and how is it created?, What are Tablespace Quota and default tablespace?............ <<Previous  Next>>