|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 advantage of using packages for storing PL/SQL objects?|
Packages offer several advantages when you call a packaged subprogram for the first time, the whole package is loaded into memory. So, later calls to related subprograms in the package require no disk I/O.
|Define exception and How will you raise an exception in PL/SQL procedure?|
In PL/SQL, a error condition is called an exception. Exceptions can be system defined or user defined.
Examples of system defined exceptions include division by zero and out of memory. Some common system exceptions have predefined names, such as ZERO_DIVIDE and STORAGE_ERROR.
The following example illustrates the scope rules:
DECLARE due EXCEPTION; BEGIN RAISE due; EXCEPTION WHEN due THEN Null; END;
|What is the difference between Procedure and Function?|
A function is a subprogram written to perform certain computations ,
|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
|Ratio and Proportion|
175 men can dig a canal of 3150 meters long in 36 days. How many men are required to dig a canal of 3900 meters long in 24 days?
24 men working at 8 hours a day can do a piece of work in 15 days. In how many days can 20 men working at 9 hours a day do the same work?
10 men can lay a road of 75 Km long in 5 days. In how many days can 15 men lay a road of 45 Km long?
Rice costing Rs. 480/- is needed for 8 members for 20 days. What is the cost of rice required for 12 members for 15 days?
The mess charge for 35 students for 24 days is Rs. 6300/-. In how many days will the mess charges be Rs. 3375/- for 25 students?
|Time and Work|
18 men can dig a well in 10 days. After they have worked for 4 days, how many more men shall be employed to complete the work in 4 days from then?
If 80 men can do a piece of work in 10 days, how many men are required to do the same work in 4 days?
If 80 men can do a piece of work in 10 days, in how many days can 40 men do the same piece of work?
|General Computer Knowledge|
What kind of material does ‘IC’ in computers made of?
The force required to produce an acceleration of 4 m/s2 in an object of mass 9 kg is?
Some seeds have hooks and spines. It helps the seeds to__________?
Which of the following modes of heat transfer is faster?
Which of the following reproduces from underground stem?
Lichens are a symbiotic association of?
The unit of relative density is?
|Problems on Ages|
The ages of Gyanendra and Jitendra are in the ratio of 12:7 respectively. After 6 years, the ratio of their ages will be 3:2 respectively . find the difference in their ages?
|Time and Work|
X can do a piece of work in 20 days, while Y can do in 10 days. If Y worked at it for 8 days,then X can finish the remaining work in______.?
In a certain code, BELIEF is written as AFKKDI. How is SELDOM written in that code?
|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
Haryana State Cooperative Apex Bank Ltd - 978 Posts - 31/08/2019 Last date
Kanchipuram Central Cooperative Bank - 238 Posts - 05/09/2019 Last date
Bank of Maharashtra - 46 Posts - 19/08/2019 Last date
LIC Housing Finance Limited - 300 Posts - 26/08/2019 Last date
|Jobs in Gujarat|
Gujarat Subordinate Service Selection Board (GSSSB) - 408 Posts - 24/08/2019 Last date