Can the default values be assigned to actual parameters?

1 Answer

Answer :

Yes

Related questions

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

Description : What are the default or implicitly assigned values for data types in java ?

Last Answer : Ans. boolean ---> false byte ----> 0 short ----> 0 int -----> 0 long ------> 0l char -----> /u0000 float ------> 0.0f double ----> 0.0d any object reference ----> null

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 different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

Description : What are the modes of parameters that can be passed to a procedure ?

Last Answer : IN,OUT,IN-OUT parameters.

Description : Where can one get a list of all hidden Oracle parameters? (for DBA

Last Answer : Oracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters. One can get a list of all hidden parameters by executing this query: select * from SYS.X$KSPPI ... 1,1)='_' order by a.ksppinm; Remember: Thou shall not play with undocumented parameters!

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : Can you pass data parameters to forms?

Last Answer : No

Description : Do user parameters appear in the data modal editor in 2.5?

Last Answer : No

Description : What are parameters?

Last Answer : Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

Description : What are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

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 : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

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 default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

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 : When Primary default letter assigned hard drive?

Last Answer : Need answer

Description : A constructor that accepts no parameters is called the ………………. A) Paramless constructor B) No parameter constructor C) Default constructor D) Argumentless constructor

Last Answer : C) Default constructor

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 : In python are actual and formal parameters matched up by position or name?

Last Answer : When we invoke a function, we pass the actual arguments in thesame order specified by the function's formal arguments, thus it isthe relative position that determines how they are matched. ... passed by reference (in which casethe formal argument becomes an alternative name for the actualargument).

Description : subroutines are invoked by using their___ _ ina subroutine call statement and replacing formal parameters with__ __ parameters: a. Identifier and formal b. Identifier and actual c. Expression and arguments d. None of these

Last Answer : b. Identifier and actual

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

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 : Can you pass values to-and-fro from foreign function ? how ?

Last Answer : Yes . You obtain a return value from a foreign function by assigning the return value to an Oracle Forms variable or item. Make sure that the Oracle Forms variable or item is the same data type as ... SQL data type; it must also be the appropriate parameter type as defined in the PL/SQL interface.

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

Description : What are the built-ins used for Getting cell values?

Last Answer : GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

Description : What are the built-in used for getting cell values?

Last Answer : Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

Description : CROSS VALIDATING VALUES

Last Answer : - For key flexfields with multiple segments, we can define rules to cross check value combinations entered with in the key flexfield segments. This option is referred as Cross Validation rules.

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 : If the scaling factors values Sx and Sy are assigned to unequal values then a.Uniform rotation is produced b.Uniform scaling is produced c.Differential scaling is produced d.Scaling cannot be done

Last Answer : c.Differential scaling is produced

Description : If the scaling factors values sx and sy are assigned to the same value then……… a.Uniform rotation is produced b.Uniform scaling is produced c.Scaling cannot be done d.Scaling can be done or cannot be done

Last Answer : b.Uniform scaling is produced

Description : Ramesh is a student of standard X. He organized many activities in his school to convey the students about the various advantages and disadvantages of using renewable and non-renewable sources of energy. Many ... of energy. (in) Which two values are reflected in Ramesh's thought and action? -Science

Last Answer : (i) Activities that Ramesh have had assigned for the students are: (a) Hands on projects related to renewable and non-renewable sources of energy. (b) Photograph exhibitions on the topic ... of renewable source of energy. Ramesh’s action: Concern for community advantage and good management.

Description : Name the values that can be assigned to align attribute of tag. -Technology

Last Answer : The values that can be assigned to align attribute of tag are as follows:1. top2. bottom3. left4. right5. middle

Description : One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as A) Data Security B) Domain access C) Data Control

Last Answer : C) Data Control

Description : After actual locations for main storage are known, a __ adjusts relative addresses to these actual locations: a. Relocating loader b. Locating loader c. Default loader d. None of these

Last Answer : a. Relocating loader

Description : Which plant parameters shown in the illustration would produce an alarm if they exceeded preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. TO RDCN. GR. B. L.O. PRESS. TO MN. ENG. and PME #3 MN. BRG. C. L.O. PRESS. TO MN. ENG. and L.O. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Last Answer : Answer: D

Description : Which plant parameters shown in the illustration would produce an alarm if they fell below preset values? EL-0094 A. SME #7 CYL. EXH. and L.O. PRESS. TO RDCN. GR. B. L.O. PRESS TO MN. ENG. and PME #3 MN. BRG. C. ... . TO MN. ENG and L.O. PRESS. TO RDCN. GR. D. PME #3 MN. BRG. and SME #7 CYL. EXH.

Last Answer : Answer: C

Description : If internal subroutine is called global data is used to pass values defining parameters between __ program and defined | a. Main and subroutine b. Local and subroutine c. Global and subroutine d. Global and main

Last Answer : a. Main and subroutine

Description : Define given parameters and state their values for bridge rectifier (i) Ripple factor (ii) PIV of diode.

Last Answer : Ripple Factor: Ripple Factor is defined as the ratio of RMS value of the AC component of output to the DC or average value of the output. Mathematically it is expressed as, ( ... which appears across non-conducting reverse biased diode. (ii) PIV of diode for bridge rectifier-Vm

Description : When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, ... . (D) Results in a run time error when the function tries to access the elements in the array.

Last Answer : (A) The function can change values in the original array.