|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
What is the difference between Procedure and Function?
Differences between Functions and Procedures
-Functions are normally used for computations where as procedures are normally used for executing business logic.
-Functions must return a value (using the RETURN keyword), but for stored procedures this is not compulsory. Procedures can use RETURN keyword but without any value being passed.
-Functions could be used in SELECT statements, but they should don't do any data manipulation. However, procedures cannot be included in SELECT statements.
-Functions could be used in creating "Function Based Indexes" to improve the performance ,but procedure not.
Thanks for your comment.!
Write a comment(Click here) ...
|What is PL/SQL ?|
|SQL is a declarative language that allows database programmers to write a SQL declaration and hand it to the database for execution. As such, SQL cannot be used to execute procedural code with conditional, iterative and sequential statements. To overcome this limitation, PL/SQL was created. PL/SQL is Oracle's Procedural Language extension to SQL.using plsql we perform Conditional Control ,Iterative Sequential Control Statements.it is commonly used to write data-centric programs to manipulate data in an Oracle database.|
|What is the difference between SQL and PL/SQL?|
|Both SQL and PL/SQL are languages used to access data within Oracle databases. SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. PL/SQL is a programming language that includes all the features of most other programming languages. its easily integrate with SQL. SQL is executed one statement at a time. PL/SQL is executed as a block of code. SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).|
|What is the Difference between PL/SQL Table & Nested Table?|
|PL/SQL Table: Index by Tables are not Stored in Database. Nested Table: Nested Tables are Stored in Database as Database Columns.|
|What is the Sequence of Firing Database Triggers?|
a) Before Statement Level Trigger
|What is Instead Of Trigger?|
|This trigger is used to perform DML operation directly on the underlying tables, because a view cannot be modified by normal DML Statements if it contains joins or Group Functions. These triggers are Only Row Level Triggers. The CHECK option for views is not enforced when DML to the view are performed by Instead of Trigger.|
|Give some important Oracle supplied packages?|
DBMS_SQL: It is used to write Procedures & Anonymous blocks that use Dynamic SQL.
|Give some most often used system defined exceptions?|
a) NO_DATA_FOUND (Select Statement returns no rows)
|What is a mutating and constraining table?|
“Mutating” means “changing”. A mutating table is a table that is currently being modified by an update, delete, or insert statement. When a trigger tries to reference a table that is in state of being changed, it is considered “mutating” and raises an error since Oracle should not return data that has not yet reached its final state. Another way this error can occur is if the trigger has statements to change the primary, foreign or unique key columns of the table off which it fires.
|Can one call DDL statements from PL/SQL?|
|One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the “EXECUTE IMMEDATE” statement.|
|What is Commit, Rollback and Save point?|
Commit – Makes changes to the current transaction permanent. It erases the savepoints and releases the transaction locks.
Savepoint –Savepoints allow to arbitrarily hold work at any point of time with option of later committing. They are used to divide transactions into smaller portions.
Rollback – This statement is used to undo work.
|How do you make a Function and Procedure as a Private?|
|Functions and Procedures can be made private to a package by not mentioning their declaration in the package specification and by just mentioning them in the package body.|
|What is the difference between Package, Procedure and Functions?|
A package is a database objects that logically groups related PL/SQL types, objects, and Subprograms.
Procedure is a sub program written to perform a set of actions and can return multiple values.
Function is a subprogram written to perform certain computations and always return a value.
|What are the modes for passing parameters to Oracle?|
There are three modes for passing parameters to subprograms
|What is Raise_application_error?|
|Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue a user_defined error messages from stored sub-program or database trigger.|
|What is Pragma EXECPTION_INIT? Explain the usage?|
he PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error.
|What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?|
SQLCODE returns the value of the error number for the last error encountered.
By what number should we multiply -1/5 so that the product may be 9/25?
|Profit and Loss|
A person sells an article for Rs 550, gaining 1/10 of its cost price. Its gain percentage is.
If 3x + 2y = 12 and xy = 6, then 9x2 + 4y2 = ______.
|Volume and Surface Area|
In a temple there are 25 cylindrical pillars. The radius of each pillar is 28cm and height 4m. The total cost of painting the curved surface area of pillars at the rate of Rs. 8 per m2 is:
|Problems on Ages|
After 12 years, I shall be 3 times as old as I was 4 years ago. My present age is:
|Square and Cube Root|
The smallest number by which 1100 must be multiplied so that the product becomes a perfect square is____.
What is the probability that a number selected from the numbers 1, 2, 3,…….,25 is a prime number, when each of the given numbers is equally likely to be selected?
|Square and Cube Root|
What is the smallest number by which 3087 must be divided so that the quotient is a perfect cube?
The most comfortable distance at which one can read with a normal eye is:
Cholera is caused by:
Write the name of reptile with four chambered heart?
Raj borrowed Rs. 5000 at 10% per annum on simple interest and lent the same amount at 15% per annum on compound interest. At the end of 2 years, he would ?
If the area of a square is 16 cm2, then the area of the square joining the mid-points of the sides is?
|General Knowledge of MP|
Vidisha is situated on the banks of river?
|General Knowledge of World|
When is the Human Rights Day celebrated?
|Profit and Loss|
By selling coconuts at the rate of Rs. 6/- each, a trader gained 20%. Find the cost of 100 coconuts?
|General Knowledge of India|
How many coastal state are in India?
A person is to count 4500 currency notes. Let an denote the number of notes he counts in the nth minute. If a1 = a2 = .... = a10 = 150 and a10 , a11 ,... are in an AP with common difference – 2, then the time taken by him to count all notes is ?
Reserve Bank of India (RBI) - 841 Posts - 15/03/2021 Last date
Institute of Banking Personnel Selection (IBPS) - CRP SPL-IX - 1163 Posts - 26/11/2019 Last date
Reserve Bank of India (RBI) - 199 Posts - 11/10/2019 Last date
Life Insurance Corporation of India (LIC) - 7942 Posts - 01/10/2019 Last date
State Bank of India (SBI) - CRPD/APPR - 700 Posts - 06/10/2019 Last date
|Jobs in Jharkhand|
Jharkhand Staff Selection Commission (JSSC) -JANMCE - 1985 Posts - 04/10/2019 Last date
|Jobs in Madhya Pradesh|
National Health Mission (NHM) - 1392 Posts - 05/10/2019 Last date
|Jobs in Bihar|
Bihar Vidhan Parishad - 136 Posts - 11/10/2019 Last date
NABARD - 91 Posts - 02/10/2019 Last date
Institute of Banking Personnel Selection (IBPS) - CRP Clerks-IX - 12075 Posts - 09/10/2019 Last date