Description : Can a repeating frame be created without a data group as a base?
Last Answer : No
Description : Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
Last Answer : Yes
Description : What is the frame & repeating frame?
Last Answer : A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.
Description : What are the two repeating frame always associated with matrix object?
Last Answer : One down repeating frame below one across repeating frame.
Description : There is a % sign in one field of a column. What will be the query to find it?
Last Answer : '' Should be used before '%'.
Description : Can a field be used in a report without it appearing in any data group?
Description : Use the add_group_column function to add a column to record group that was created at a design time?
Last Answer : False
Description : Can a formula column referred to columns in higher group?
Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE
Last Answer : II) FALSE
Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
Last Answer : By dragging the column outside the group.
Description : What is the Maximum allowed length of Record group Column?
Last Answer : Record group column names cannot exceed 30 characters.
Description : How image_items can be populate to field in forms 4.0?
Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.
Description : Can you pass data parameters to forms?
Description : Atleast how many set of data must a data model have before a data model can be base on it?
Last Answer : Four
Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology
Last Answer : (c) Field name is the name of the column heading for each category in a data source.
Description : What are the minimum parameters should exist in the parameter file (init.ora) ?
Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.
Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?
Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.
Description : How many alert logs exist in a RAC environment?
Last Answer : One for each instance.
Description : What column differentiates the V$ views to the GV$ views and how?
Last Answer : The INST_ID column which indicates the instance in a RAC environment the information came from.
Description : Can a formula column be obtained through a select statement?
Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?
Last Answer : It won't, Because SYSDATE format contains time attached with it.
Description : Write the order of precedence for validation of a column in a table ?
Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?
Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?
Last Answer : A hidden column is used to when a column has to embed into boilerplate text.
Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?
Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
Description : To execute row from being displayed that still use column in the row which property can be used?
Last Answer : Format trigger.
Description : If a break order is set on a column would it affect columns which are under the column?
Description : What is the purpose of the product order option in the column property sheet?
Last Answer : To specify the order of individual group evaluation in a cross products.
Description : A Column is having many repeated values which type of index you should create on this column, if you have to?
Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.
Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?
Last Answer : The table has a BLOB column.
Description : (i) Write command to compute sum of every column of the data frame. -Technology
Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )
Description : What is Legislative Data Group in Fusion HCM?
Last Answer : Legislative data groups are a means of partitioning payroll and related data. At least one legislative data group is required for each country where the enterprise operates. Each legislative data group ... and is associated with a legislative code, currency and its own cost key flexfield structure.
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
Description : How can you execute the user defined triggers in forms 3.0 ?
Last Answer : Execute Trigger (trigger-name)
Description : How do you call other Oracle Products from Oracle Forms?
Last Answer : Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.
Description : When a form is invoked with call_form, Does oracle forms issues a save point?
Description : Can u have VBX and OCX controls in forms ?
Last Answer : Yes.
Description : Can u have OLE objects in forms?
Description : Can u set default font in forms?
Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.
Description : Can you issue DDL in forms?
Last Answer : yes, but you have to use FORMS_DDL. Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an ... values of bind variables can be concatenated into the string before passing the result to FORMS_DDL.
Description : Is forms 4.5 object oriented tool ? why?
Last Answer : yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.
Description : What is a library in Forms 4.0?
Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
Description : What are the design facilities available in forms 4.0?
Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.
Description : What are the built_in used to trapping errors in forms 4?
Last Answer : Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char
Description : List the editors availables in forms 4.0?
Last Answer : Default editor User_defined editors system editors.
Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?
Last Answer : Page - Canvas-View Page 0 - Canvas-view null.
Description : What are the menu items that oracle forms 4.0 supports?
Last Answer : Plain, Check,Radio, Separator, Magic
Description : What is a predefined exception available in forms 4.0?
Last Answer : Raise form_trigger_failure
Description : List system variables available in forms 4.0, and not available in forms 3.0?
Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working
Description : List the windows event triggers available in Forms 4.0?
Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized