What are the advantages of having a Package ?

ORACLE Interview Questions and Answers (Part 3)

(Continued from previous question...)

505. What are the advantages of having a Package ?

Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

(Continued on next question...)

Other Interview Questions

• What is the difference between restricted and unrestricted package procedure ?
• A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
• Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
• State the order in which these triggers are executed ?
• What the PAUSE package procedure does ?
• What do you mean by a page ?
• What are the type of User Exits ?
• What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
• Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
• Is a Key startup trigger fires as result of a operator pressing a key explicitly ?
• Can we use GO-BLOCK package in a pre-field trigger ?
• Can we create two blocks with the same name in form 3.0 ?
• What is Post-Block is a. ???
• What does an on-clear-block Trigger fire?
• Name the two files that are created when you generate the form give the filex extension ?
• What package procedure used for invoke sql *plus from sql *forms ?
• What is the significance of PAGE 0 in forms 3.0 ?
• What are the different types of key triggers ?
• What is the difference between a Function Key Trigger and Key Function Trigger ?
• Committed block sometimes refer to a BASE TABLE ?
• Error_Code is a package proecdure ?
• When is cost based optimization triggered? (for DBA
• How can one optimize %XYZ% queries? (for DBA
• What Enter package procedure does ?
• Where can one find I/O statistics per table? (for DBA
• My query was fine last week and now it is slow. Why? (for DBA
• Why is Oracle not using the damn index? (for DBA
• When should one rebuild an index? (for DBA
• What are the unrestricted procedures used to change the popup screen position during run time ?
• What is an Alert ?
• Deleting a page removes information about all the fields in that page ? a. True. b. False?
• Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ? a. True. b. False?
• Classify the restricted and unrestricted procedure from the following: ...
• What is an User Exits ?
• What is a Trigger ?
• What is a Package Procedure ?
• What is the maximum size of a form ?
• What is the difference between system.current_field and system.cursor_field ?
• List the system variables related in Block and Field?
• What are the types of TRIGGERS ?
• Identify package function from the following ?
• Can you attach an lov to a field at run-time? if yes, give the build-in name.?
• Is it possible to attach same library to more than one form?
• Can you attach an lov to a field at design time?
• List the windows event triggers available in Forms 4.0?
• What are the triggers associated with the image item?
• What is a visual attribute?
• How many maximum number of radio buttons can you assign to a radio group?
• How do you pass the parameters from one form to another form?
• What is a Layout Editor?
• List the Types of Items?
• List system variables available in forms 4.0, and not available in forms 3.0?
• What are the display styles of an alert?
• What built-in is used for showing the alert during run-time?
• What built-in is used for changing the properties of the window dynamically?
• What are the different types of windows?
• What is a predefined exception available in forms 4.0?
• What is a radio Group?
• What are the different type of a record group?
• What are the menu items that oracle forms 4.0 supports?
• Give the equivalent term in forms 4.0 for the following. Page, Page 0?
• What triggers are associated with the radio group?
• What are the triggers associated with a check box?
• Can you attach an alert to a field?
• Can a root window be made modal?
• What is a list item?
• List some built-in routines used to manipulate images in image_item?
• Can you change the alert messages at run-time?
• What is the built-in used to get and set lov properties during run-time?
• What is the built-in routine used to count the no of rows in a group?
• Give the Types of modules in a form?
• Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL?
• List the built-in routine for controlling window during run-time?
• List the built-in routine for controlling window during run-time?
• What is the built-in function used for finding the alert?
• List the editors availables in forms 4.0?
• What buil-in routines are used to display editor dynamicaly?
• What is an Lov?
• What is a record Group?
• Give built-in routine related to a record groups?
• List the built-in routines for the controlling canvas views during run-time?
• System.effective_date system variable is read only True/False?
• What are the built_in used to trapping errors in forms 4?
• What is Oracle Financials? (for DBA
• What are the design facilities available in forms 4.0?
• What is the most important module in Oracle Financials? (for DBA
• What are the types of canvas-views?
• What is the MultiOrg and what is it used for? (for DBA
• What is the difference between Fields and FlexFields? (for DBA
• Explain types of Block in forms4.0?
• What is an Alert?
• What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
• What is a record Group?
• What is a Navigable item?
• What is a library in Forms 4.0?
• How image_items can be populate to field in forms 4.0?
• What is the content view and stacked view?
• What is a Check Box?
• What is a canvas-view?
• Explain the following file extension related to library?
• Explain the usage of WHERE CURRENT OF clause in cursors ?
• Name the tables where characteristics of Package, procedure and functions are stored ?
• Explain the two type of Cursors ?
• What are two parts of package ?
• What are two virtual tables available during database trigger execution ?
• What is Fine Grained Auditing? (for DBA
• What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?
• What is Fine Grained Access Control? (for DBA
• What is a Virtual Private Database? (for DBA
• What is Raise_application_error ?
• What is Oracle Label Security? (for DBA
• Give the structure of the procedure ?
• What is OEM (Oracle Enterprise Manager)? (for DBA
• Question What is PL/SQL ?
• What are the components of OEM? (for DBA
• What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
• Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
• How many types of database triggers can be specified on a table ? What are they ?
• What are the modes of parameters that can be passed to a procedure ?
• Where the Pre_defined_exceptions are stored ?
• Write the order of precedence for validation of a column in a table ?
• Give the structure of the function ?
• Explain how procedures and functions are called in a PL/SQL block ?
• What are advantages fo Stored Procedures?
• What is an Exception ? What are types of Exception ?
• What are the PL/SQL Statements used in cursor processing ?
• What are the components of a PL/SQL Block ?
• What is a database trigger ? Name some usages of database trigger ?
• What is a cursor ? Why Cursor is required ?
• What is a cursor for loop ?
• What will happen after commit statement ?
• How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS??
• What is a stored procedure ?
• What are the components of a PL/SQL block ?
• What is difference between a PROCEDURE & FUNCTION ?
• What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
• What are the cursor attributes used in PL/SQL ?
• What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
• What is difference between % ROWTYPE and TYPE RECORD ?
• What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
• What are the advantages of having a Package ?
• What are the uses of Database Trigger ?
• What is a Procedure ?
• What is a Package ?
• What is difference between Procedures and Functions ?
• What is Database Trigger ?
• Can the default values be assigned to actual parameters?
• Can a primary key contain more than one columns?
• What is an UTL_FILE.What are different procedures and functions associated with it?
• What are ORACLE PRECOMPILERS?
• Differentiate between TRUNCATE and DELETE?
• What is difference between a formal and an actual parameter?
• What should be the return type for a cursor variable.Can we use a scalar data type as return type?
• What are different Oracle database objects?
• What is difference between SUBSTR and INSTR?
• Display the number value in Words?
• What is difference between SQL and SQL*PLUS?
• What are various joins used while writing SUBQUERIES?
• What a SELECT FOR UPDATE cursor represent.?
• What are various privileges that a user can grant to another user?
• Display the records between two range?
• minvalue.sql Select the Nth lowest value from a table?
• What is difference between Rename and Alias?
• Difference between an implicit & an explicit cursor.?
• What is a OUTER JOIN?
• What is a cursor?
• What is the purpose of a cluster?
• What is OCI. What are its uses?
• How you open and close a cursor variable.Why it is required?
• Display Odd/ Even number of records?
• What are various constraints used in SQL?
• Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
• Difference between NO DATA FOUND and %NOTFOUND?
• Can you use a commit statement within a database trigger?
• What WHERE CURRENT OF clause does in a cursor?