What are different modes of parameters used in functions and procedures?

What are different modes of parameters used in functions
and procedures?
by

1 Answer

Answer :

IN -OUT -INOUT
by

Related questions

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

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

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

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What is difference between Procedures and Functions ?

Description : What is difference between Procedures and Functions ?

Last Answer : A Function returns a value to the caller where as a Procedure does not.

How packaged procedures and functions are called from the following?

Description : How packaged procedures and functions are called from the following?

Last Answer : a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS?? a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME ( ... .PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the minimum parameters should exist in the parameter file (init.ora) ?

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.

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

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

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!

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

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.

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

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.

Can you pass data parameters to forms?

Description : Can you pass data parameters to forms?

Last Answer : No

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

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

Last Answer : No

What are parameters?

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.

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

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.

What is Overloading of procedures ?

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

What are advantages fo Stored Procedures?

Description : What are advantages fo Stored Procedures?

Last Answer : Extensibility,Modularity, Reusability, Maintainability and one time compilation.

What are the unrestricted procedures used to change the popup screen position during run time ?

Description : What are the unrestricted procedures used to change the popup screen position during run time ?

Last Answer : Anchor-view Resize -View Move-View.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What are stand-alone procedures?

Description : What are stand-alone procedures?

Last Answer : Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These ... limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

Parameters can be stacked by just as with procedures: a. Asterisk(*) b. Arrow c. Line d. ‘Pipeline

Description : Parameters can be stacked by just as with procedures: a. Asterisk(*) b. Arrow c. Line d. ‘Pipeline

Last Answer : a. Asterisk(*)

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

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.

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

What are Procedure,functions and Packages

Description : What are Procedure,functions and Packages

Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What are the built-ins used for finding object ID functions?

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

Neural Networks are complex ______________ with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Description : Neural Networks are complex ______________ with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Last Answer : a) Linear Functions

Neural Networks are complex ______________with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Description : Neural Networks are complex ______________with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Last Answer : b) Nonlinear Functions

Can 2 functions have same name & input parameters but differ only by return datatype

Description : Can 2 functions have same name & input parameters but differ only by return datatype

Last Answer : No.

What test equipment is designed to generate, modify, or measure a range of parameters of electronic functions of a specific nature required to test a single system or equipment?

Description : What test equipment is designed to generate, modify, or measure a range of parameters of electronic functions of a specific nature required to test a single system or equipment?

Last Answer : Special-purpose electronic test equipment.

Neural Networks are complex ———————–with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions e) Power Functions

Description : Neural Networks are complex ———————–with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions e) Power Functions

Last Answer : b) Nonlinear Functions

Neural Networks are complex ______________ with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Description : Neural Networks are complex ______________ with many parameters. a) Linear Functions b) Nonlinear Functions c) Discrete Functions d) Exponential Functions

Last Answer : a) Linear Functions

Design Phase consists of ……………………. 1. Identity the functions to be performed 2. Design the input/output and file design 3. Defining basic parameters for system design A) 1 & 2 B) 2 & 3 C) 1 & 3 D) 1, 2 & 3

Description : Design Phase consists of ……………………. 1. Identity the functions to be performed 2. Design the input/output and file design 3. Defining basic parameters for system design A) 1 & 2 B) 2 & 3 C) 1 & 3 D) 1, 2 & 3

Last Answer : D) 1, 2 & 3

All the parameters in the linear programming model are assumed to be ..................... a. Variables b. Constraints c. Functions d. None of these

Description : All the parameters in the linear programming model are assumed to be ..................... a. Variables b. Constraints c. Functions d. None of these

Last Answer : b. Constraints

Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the internal auditor. b. The external audit function's objectives vary according to management's requirements. c. Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures. d. The external auditor is responsible for the audit opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Description : Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the ... opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Last Answer : Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures.

The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Description : The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Last Answer : All of the above

Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b) iii ,is correct I,ii,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Description : Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b ... ,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Last Answer : a) i , ii,iii,iv is correct

Different modes of CO2 transport in blood. -Biology

Description : Different modes of CO2 transport in blood. -Biology

Last Answer : answer:

What Instead of banning certain modes altogether Aristotle recognized that modes could be used for different reasons. How did Aristotle think the modes should be used?

Description : What Instead of banning certain modes altogether Aristotle recognized that modes could be used for different reasons. How did Aristotle think the modes should be used?

Last Answer : Each mode expressed a certain feeling and each mode had its place. -apex

What are the different modes of paying stamp duty in e-Stamping system? A. RTGS B. NEFT C. Pay order D. All of the Above E. None of the Above

Description : What are the different modes of paying stamp duty in e-Stamping system? A. RTGS B. NEFT C. Pay order D. All of the Above E. None of the Above

Last Answer : D. All of the Above Explanation: Client can pay stamp duty amount through the following modes Cash Cheque Demand Draft Pay Order RTGS NEFT Account to Account transfer.

Is the different angle of entry of light into an optical fiber when the diameter of the core is many times the wavelength of the light transmitted. a. Acceptance angle b. Modes c. Sensors d. Aperture

Description : Is the different angle of entry of light into an optical fiber when the diameter of the core is many times the wavelength of the light transmitted. a. Acceptance angle b. Modes c. Sensors d. Aperture

Last Answer : b. Modes

What is the use of addressing modes, mention the different types

Description : What is the use of addressing modes, mention the different types

Last Answer : The various formats of specifying the operands are called addressing modes, it is used to access the operands or data. The different types are as follows • Immediate addressing • Register addressing • Direct addressing • Indirect addressing • Implicit addressing

What are the different modes of mounting a Database with the Parallel Server?

Description : What are the different modes of mounting a Database with the Parallel Server?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is ... parallel mode, other instances that are started in parallel mode can also mount the database.

Modes of a light pulse that enter the fiber at one time exit the fiber at different times. This condition causes the light pulse to spread. What is this condition called?

Description : Modes of a light pulse that enter the fiber at one time exit the fiber at different times. This condition causes the light pulse to spread. What is this condition called?

Last Answer : Modal dispersion.

What are the different modes through which you can connect to Datapower?

Description : What are the different modes through which you can connect to Datapower?

Last Answer :  GUI  CLI  XML-Management Interface

Is the different angle of entry of light into an optical fiber when the diameter of the core is many times the wavelength of the light transmitted. ∙ a. Acceptance angle ∙ b. Modes ∙ c. Sensors ∙ d. Aperture

Description : Is the different angle of entry of light into an optical fiber when the diameter of the core is many times the wavelength of the light transmitted. ∙ a. Acceptance angle ∙ b. Modes ∙ c. Sensors ∙ d. Aperture

Last Answer : b. Modes