| Other SQL PLSQL Interview Questions |
|| Asked @
find the max salary using aggregate function?
|What is normalization and types of normalization?
|I have a small PL/SQL Block
assume in this way
select * from emp where empno=100;
when others then
when no_data_found then
when too_many_rows then
The question which he asked was whether this block will get
executed normally or it will throw error ?
If errored out then what is the reason for the error ?
Could anybody please help me ?
|write a query to delete similar records in particular
fields(columns) in different tables
|Suppose There is a string
A.B....C.......D.........E........F In this string dots (.)
are not having fixed count in between of string. I want the
output to have string with one dot between. I.e.
|Let us suppose we have a table with structure in order
and now i want to re-organize the columns of this table to
how can i do this with queries ?
assume that table contains the data.
|Write a query to find second highest salary of an employee.
|define primary key & secondary key?
|Which one of the following join types will always create a
1. CROSS JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. FULL OUTER JOIN
5. INNER JOIN
|If you have to declare procedure1,procedure2 in package
specification and if you have to declare
procedure1,procedure2 and procedure3 in package body? is it
compilation or not and execute or not? what type of error
is given please
|function can return multiple value?how give give sample coding
|How can multiply values of a column? OR How can multiply value
of a row of a column using a single query in SQL?
|For more SQL PLSQL Interview Questions Click Here |