Description : What is the use of break group? What are the various sub events a mouse double click event involves?
Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
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 : 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 : By default, to run an application through mouse, which one of the following has to be done ? (1) Right click (2) Left click (3) Single click (4) Double dick
Last Answer : Double dick
Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.
Description : State any three mouse events system variables?
Last Answer : System.mouse_button_pressedSystem.mouse_button_shift
Description : Can u run the report with out a parameter form
Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null
Description : 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?
Last Answer : a. True.
Description : What are three panes that appear in the run time pl/sql interpreter?
Last Answer : 1. Source pane. 2. interpreter pane. 3. Navigator pane.
Description : What are the unrestricted procedures used to change the popup screen position during run time ?
Last Answer : Anchor-view Resize -View Move-View.
Description : What is the OPTIMAL parameter?
Last Answer : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA
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 : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )
Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.
Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?
Last Answer : COST and RULE.
Description : s it possible to disable the parameter from while running the report?
Last Answer : Yes
Description : Table Space,Data Files,Parameter File, Control Files
Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.
Description : What is difference between a formal and an actual parameter?
Last Answer : The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are ... procedure and receive results. Formal parameters are the placeholders for the values of actual parameters
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 : Which parameter in Storage clause will reduce no. of rows per block?
Last Answer : PCTFREE parameter Row size also reduces no of rows per block.
Description : How do you reference a Parameter?
Last Answer : 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
Description : What use of command line parameter cmd file?
Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
Description : Which parameter can be used to set read level consistency across multiple queries?
Last Answer : Read only
Description : What are the different Parameter types?
Last Answer : Text ParametersData Parameters
Description : What is the maximum no of chars the parameter can store?
Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
Description : How do you reference a parameter indirectly?
Last Answer : To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')
Description : When do you use data parameter type?
Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra
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 : Does a Before form trigger fire when the parameter form is suppressed?
Last Answer : Yes.
Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.
Description : What is PGA_AGGREGATE_TARGET parameter?
Last Answer : PGA_AGGREGATE_TARGET: specifies the target aggregate PGA memory available to all server processes attached to the instance.
Description : What parameter will you use to force the starting of your database with a corrupted resetlog?
Last Answer : ALLOW_RESETLOGS_CORRUPTION
Description : How can you difference a usual parameter and an undocumented parameter?
Last Answer : Undocumented parameters have the prefix ‘_’. For example, _allow_resetlogs_corruption
Description : The join defined by the default data link is an outer join yes or no?
Description : Can u set default font in forms?
Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.
Description : Can the default values be assigned to actual parameters?
Description : What are the default extensions of the files created by forms modules?
Last Answer : .fmb - form module binary .fmx - form module executable
Description : What are the default extensions of the files created by menu module?
Last Answer : .mmb, .mmx
Description : What are the different default triggers created when Master Deletes Property is set to Cascade?
Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete
Description : What are the different default triggers created when Master Deletes Property is set to isolated?
Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details
Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?
Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details
Description : What are the default extensions of the files created by library module?
Last Answer : The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary
Description : What is default tablespace ?
Last Answer : The Tablespace to contain schema objects created without specifying a tablespace name.
Description : Which default Database roles are created when you create a Database?
Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES
Description : Which are the default passwords of SYSTEM/SYS?
Last Answer : MANAGER / CHANGE_ON_INSTALL
Description : If I have a constructor with a parameter, do I need to explicitly create a default constructor?