Welcome to www.programmer2programmer.net tips for IT Interview Questions of Oracle Forms 3.0 Basic

programmer2programmer.net

 Tips
 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
  
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2017 New Projects
 Project Synopsis Download
  
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
  
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

 Interview questions and Answers for Oracle D2K Forms 3.0 Basic

Home Personal Member Forum Source Project Tips Contact
 

Interview Question > Oracle

Oracle Forms 3.0 Basic
 Interview Questions and Answers

Interview questions and answers for Oracle Forms 3.0 Basic  Interview Questions and Answers

Oracle Forms 3.0 Basic Interview Questions and Answers includes, SQL * FORMS, maximum size of a form, control the constraints, BASE TABLE, join condition, Trigger, types of TRIGGERS, key triggers, difference between a Function Key Trigger and Key Function Trigger, Navigational Trigger, ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger, keystartup and pre-form

Interview Question, Answer
1.  Programming General
2.  Web General
3.  Database General
4.  Visual Basic 6
5.  ASP
6.  Visual Basic .NET and C#
7.  ASP .NET
8.  ORACLE
9.  MS SqlServer
10. MySql
11. COM, DCOM
1. What is an SQL * FORMS?
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
 
2. What is the maximum size of a form?
255 character width and 255 characters Length.
 
3. Name the two files that are created when you generate the form give the filex extension?
INP (Source File)
FRM (Executable File)
 
4. How do you control the constraints in forms?
Select the use constraint property is ON Block definition screen.
 
5. Give the sequence of execution of the various report triggers?
Before form, after form, before report, between page, after report.
 
6. Committed block sometimes refer to a BASE TABLE? True or False.
False.
 
7. Can we create two blocks with the same name in form 3.0?
No.
 
8. While specifying master/detail relationship between two blocks specifying the join condition is a must? True or False.
True.
 
9. What is a Trigger?
A piece of logic that is executed at or triggered by a SQL *forms event.
 
10. What are the types of TRIGGERS?
  1. Navigational Triggers.
2. Transaction Triggers.
 
11. What are the different types of key triggers?
  Function Key
Key-function
Key-others
Key-startup
 
12. What is the difference between a Function Key Trigger and Key Function Trigger?
  Function key triggers are associated with individual SQL*FORMS function keys
You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.
 
13. What does an on-clear-block Trigger fire?
  It fires just before SQL * forms the current block.
 
14. How do you trap the error in forms 3.0?
  Using On-Message or On-Error triggers.
 
15. State the order in which these triggers are executed?
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.
KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
 
16. What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS?
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively.
For Eg, instead of inserting a row in a table an existing row can be updated in the same table.
 
17. When will ON-VALIDATE-FIELD trigger executed?
It fires when a value in a field has been changed and the field status is changed or new and the <NEXT-FIELD> key has been pressed. If the field status is valid then any further change to the value in the field will not fire the on-validate-field trigger.
 
18. A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
PRE-QUERY fires once.
POST-QUERY fires 10 times.
 
19. What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger?
  When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute-query post-chage trigger will fire, on-validate field trigger will not fire.
 
20. What is the difference between an ON-VALIDATE-FIELD trigger and a trigger?
On-validate-field trigger fires, when the field Validation status New or changed.
Post-field-trigger whenever the control leaving form the field, it will fire.
 
21. What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger?
Post-field trigger fires whenever the control leaving from the filed.
Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.
 
22. When is PRE-QUERY trigger executed?
When Execute-query or count-query Package procedures are invoked.
 
23. Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level?
   a. ON-INSERT b. POST-INSERT c. PRE-INSERT
 
24. Can we use GO-BLOCK package in a pre-field trigger?
  No.
 
25. Is a Keystartup trigger fires as result of a operator pressing a key explicitly?
No.
 
26. How can you execute the user defined triggers in forms 3.0?
Execute_Trigger (trigger-name)
 
27. When does an on-lock trigger fire?
It will fires whenever SQL * Forms would normally attempt to lock a row.
 
28. What is Post-Block is a
a. Navigational Trigger.
b. Key trigger
c. Transaction Trigger.
 
29. What is the difference between keystartup and pre-form?
Key-startup triggers fires after successful navigation into a form.
Pre-form trigger fires before enter into the form.
 
30. What is the difference between keystartup and pre-form?
Key-startup triigger fires after successful navigation into a form.
Pre-form trigger fires before enter into the form.

Next  Oracle Package Procedure and Function Interview Questions and Answers          Go back to Interview Question Main

(C) Atanu Maity, 2006-2017