Classify the restricted and unrestricted procedure from the following.

Classify the restricted and unrestricted procedure from the following.
by

1 Answer

Answer :

a. Call
b. User-Exit
c. Call-Query
d. Up
e. Execute-Query
f. Message
g. Exit-From
h. Post
i. Break?
a. Call - unrestricted
b. User Exit - Unrestricted
c. Call_query - Unrestricted
d. Up - Restricted
e. Execute Query - Restricted
f. Message - Restricted
g. Exit_form - Restricted
h. Post - Restricted
i. Break - Unrestricted.
by

Related questions

What is the difference between restricted and unrestricted package procedure ?

Description : What is the difference between restricted and unrestricted package procedure ?

Last Answer : Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

EXIT_FORM is a restricted package procedure ?a. True b. False

Description : EXIT_FORM is a restricted package procedure ?a. True b. False

Last Answer : True

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.

What is Restricted Mode of Instance Startup ?

Description : What is Restricted Mode of Instance Startup ?

Last Answer : An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

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 ?

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

What package procedure is used for calling another form ?

Description : What package procedure is used for calling another form ?

Last Answer : Call (E.g. Call(formname)

What ERASE package procedure does ?

Description : What ERASE package procedure does ?

Last Answer : Erase removes an indicated global variable.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

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

Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

What is syntax for dropping a procedure and a function .Are these operations possible?

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

Difference between procedure and function.?

Description : Difference between procedure and function.?

Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

What is a Procedure ?

Description : What is a Procedure ?

Last Answer : A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

What is difference between a PROCEDURE & FUNCTION ?

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

What is a stored procedure ?

Description : What is a stored procedure ?

Last Answer : A stored procedure is a sequence of statements that perform specific function.

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.

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

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 different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What is a Package Procedure ?

Description : What is a Package Procedure ?

Last Answer : A Package procedure is built in PL/SQL procedure.

What Enter package procedure does ?

Description : What Enter package procedure does ?

Last Answer : Enter Validate-data in the current validation unit.

What package procedure used for invoke sql *plus from sql *forms ?

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

What the PAUSE package procedure does ?

Description : What the PAUSE package procedure does ?

Last Answer : Pause suspends processing until the operator presses a function key

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Last Answer : False

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

Is the "unrestricted right" to believe in anything justifiable or dangerous?

Description : Is the "unrestricted right" to believe in anything justifiable or dangerous?

Last Answer : How on earth would you control what someone else thinks?

Are there good arguments against unrestricted free trade?

Description : Are there good arguments against unrestricted free trade?

Last Answer : answer:For me there are a number of things, one thing at least, I don't know if an 18th century economic model is capable of setting a standard for 21 century financial instruments, for example, the ... everything? Can the market really sort it all out for the best? Personally, I don't think so.

What is the meaning of unrestricted name ?

Description : What is the meaning of unrestricted name ?

Last Answer : Unrestricted name means fluent , unrestricted.

The unrestricted reproductive capacity of a population is called is :

Description : The unrestricted reproductive capacity of a population is called is :

Last Answer : The unrestricted reproductive capacity of a population is called is : A. Birth rate B. Biotic potential C. Carrying capacity D. Fertility

Free Trade refers to - (1) free movement of goods from one country to another (2) movement of goods free of cost (3) unrestricted exchange of goods and service (4) trade free of duty

Description : Free Trade refers to - (1) free movement of goods from one country to another (2) movement of goods free of cost (3) unrestricted exchange of goods and service (4) trade free of duty

Last Answer : (1) free movement of goods from one country to another Explanation: Free trade is a policy by which a government does not discriminate against imports or interfere with exports by ... countries are determined by price strategies that may differ-from those that would emerge under deregulation.

. In a population, unrestricted reproductive capacity is called as (a) biotic potential (b) fertility rate (c) carrying capacity (d) birth rate.

Description : . In a population, unrestricted reproductive capacity is called as (a) biotic potential (b) fertility rate (c) carrying capacity (d) birth rate.

Last Answer : (a) biotic potential

The degree of static indeterminacy up to which column analogy method can be used is (A) 2 (B) 3 (C) 4 (D) Unrestricted

Description : The degree of static indeterminacy up to which column analogy method can be used is (A) 2 (B) 3 (C) 4 (D) Unrestricted

Last Answer : (B) 3

Socialism is opposed to a. social security scheme b. equal distribution of wealth c. unrestricted competition d. collective ownership and management

Description : Socialism is opposed to a. social security scheme b. equal distribution of wealth c. unrestricted competition d. collective ownership and management

Last Answer : c. unrestricted competition

If all the production rules have single non - terminal symbol on the left side, the grammar defined is : (A) context free grammar (B) context sensitive grammar (C) unrestricted grammar (D) phrase grammar

Description : If all the production rules have single non - terminal symbol on the left side, the grammar defined is : (A) context free grammar (B) context sensitive grammar (C) unrestricted grammar (D) phrase grammar

Last Answer : (A) context free grammar

Which one of the following is correct, when a class grants friend status to another class? (A) The member functions of the class generating friendship can access the members of the friend class. (B) All member functions of the class granted friendship have unrestricted access to the members of the class granting the friendship. (C) Class friendship is reciprocal to each other (D) There is no such concept.

Description : Which one of the following is correct, when a class grants friend status to another class? (A) The member functions of the class generating friendship can access the members of the friend class. (B) ... the friendship. (C) Class friendship is reciprocal to each other (D) There is no such concept.

Last Answer : All member functions of the class granted friendship have unrestricted access to the members of the class granting the friendship. 

Free Trade refers to (1) free movement of goods from one country to another (2) movement of goods free of cost (3) unrestricted exchange of goods and service (4) trade free of duty

Description : Free Trade refers to (1) free movement of goods from one country to another (2) movement of goods free of cost (3) unrestricted exchange of goods and service (4) trade free of duty

Last Answer : free movement of goods from one country to another

Of the 118 chemical elements which are legal to own, and which are restricted?

Description : Of the 118 chemical elements which are legal to own, and which are restricted?

Last Answer : Here is a simple but useful book that talks about the elements: Lift the flap Periodic table It is for kids but has the answers to your questions. Maybe you can get it at the library. It will also tell you the ones that will make you sick.

If the unredacted Mueller report can be viewed by members of congress in some restricted-access room, and the fully released version has only minimal redactions, why is congress so vehemently demanding an unredacted distribution?

Description : If the unredacted Mueller report can be viewed by members of congress in some restricted-access room, and the fully released version has only minimal redactions, why is congress so vehemently demanding an unredacted distribution?

Last Answer : Because from a constitutional point of view, the Executive branch cannot and should not control what the legislative branch does. We have three co-equal branches of government. Not a dictatorship.

Should there be separate, restricted to adults, showings of films that have a high risk of having tons of children in the audience?

Description : Should there be separate, restricted to adults, showings of films that have a high risk of having tons of children in the audience?

Last Answer : It’s called the 9:00 p.m. showing, loli.

Can someone please explain the “restricted zone” rule in basketball?

Description : Can someone please explain the “restricted zone” rule in basketball?

Last Answer : This is from the NBA website: Restricted Area: The restricted area (RA) is the area within the arched line on the court located below the rim. Its purpose is to stop secondary defenders from taking a ... drives the baseline and is not attempting to go directly to the rim, the RA does not apply.

Why are we restricted to quarters when using a coin operated washing machine and dryer?

Description : Why are we restricted to quarters when using a coin operated washing machine and dryer?

Last Answer : I assume it’s for the sake of simplicity in design. In older, analog designs, quarters act like the ridges of a key in a pin lock. The newer digital versions likely accept only quarters out of (likely correct) assumption that laundromat owners don’t wish to deal with three different kinds of change.

I have a restricted Facebook profile. Is there a way I can e-mail a link to my facebook profile without having to adjust my security settings?

Description : I have a restricted Facebook profile. Is there a way I can e-mail a link to my facebook profile without having to adjust my security settings?

Last Answer : If you go to Facebook, and click on your name in the upper right hand corner, next to Find Friends and Home, it’ll send you to the link you need to send your friends.

Can I have Facebook friends on both the Restricted list, and another specific list?

Description : Can I have Facebook friends on both the Restricted list, and another specific list?

Last Answer : From what I gather, the information you post can be restricted within the message posting itself, so if your friends are on the restricted list they will only see what is on your public wall. If you keep them restricted, they will not be able to see anything else. So yes, Restricted cancels out.

Is there a way to look up a phone number that shows up as "restricted" on your cell phone?

Description : Is there a way to look up a phone number that shows up as "restricted" on your cell phone?

Last Answer : answer:As of right now, there's no way for you to return calls to restricted phone numbers. Most phone companies won't be of help to you either, as they do not have records of restricted numbers. At ... you can do to make your number show up as unavailable or restricted but I don't really use that.

Do you have any meal suggestions for this very restricted diet?

Description : Do you have any meal suggestions for this very restricted diet?

Last Answer : Whole grain cereals that don't include wheat with fruits is an option. As a vegan, we're not into dairy, preservatives or food coloring either but that above diet is even more restrictive than ours, whew, ... family to cut one of these things at a time to see what food the allergy is to, actually.

Is there a difference between Unknown, Private and Restricted phone calls?

Description : Is there a difference between Unknown, Private and Restricted phone calls?

Last Answer : answer:Restricted is normally a person blocking their phone number. That's what shows up whenever I get prank calls from friends. Unknown calls are mostly from bill collectors and such, while private calls are ... number, they don't want you to know who it is before you pick up the phone.