| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a database trigger ? Name some usages of database
trigger ? | | 3 |
| how instead of triger is helpful for mutating tables errors
handlling ? | Oracle | 2 |
| What are the modes of parameters that can be passed to a
procedure ? | | 2 |
| If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE? | | 2 |
| what is difference between stored procedures and
application procedures,stored function and application
function?
| | 1 |
| difference between pl/sql table and normal pl/sql table | | 2 |
| When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
| | 2 |
| package specification-3 procedures
package body-2 procedures will is execute | | 2 |
| If records are inserted into table without committing.How
to refer to these values in a procedure?
| | 2 |
| Dear All,
Question for this Week
Find out possible error(s) (either at compile
time or at runtime) in the following PL/SQL block. State
the reason(s) and correct the errors.
Declare
Cursor C1 is select ename, sal, comm from emp;
Begin
For i in C1 Loop
If i.comm between 299 and 999 then
Dbms_output.put_line(i.Ename || ‘
** Good Commission’);
Elsif i.comm > 999 then
Dbms_output.put_line(i.Empno || ‘
** Very Good Commission’);
close C1;
Else
Dbms_output.put_line(i.Ename || ‘
** ’ ||nvl(i.comm,‘O’));
End if;
End Loop;
End;
| Accenture | 5 |
| what is called after appearing where clause | | 1 |
| What is the difference between RDBMS and DBMS? | Stag-Computers | 5 |
| a procedure one in two out parameters i am waiting it in a
sql query can i get the output | | 1 |
| how to find the second highest salary from emp table? | Wipro | 24 |
| select 1,col1,col2 from table1. output? | Ramco | 3 |
| What is an Exception ? What are types of Exception ? | | 2 |
| Why you are not able to create a table using select
command,if it is having a LONG column?
for eg:create table test as select * from test1
here test1 containg a column having LONG datatype... | | 1 |
| What are the PL/SQL Statements used in cursor processing ? | | 2 |
| what is a sub query?how will you calculate working days in
a month using sub query? | InteQ | 3 |
| How can you create Cursor with parametres ? | | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
