| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Do view contain data? | Ramco | 2 |
| What is the difference between sql/pl-sql/embeded sql? | | 2 |
| difference between pl/sql table and normal pl/sql table | | 2 |
| What is the basic structure of PL/SQL ? | | 4 |
| What SQL keyword must immediately follow the UNION ALL
statement?
1. SELECT
2. INTO
3. ORDER
4. WHERE
5. JOIN
| | 2 |
| package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body | Reliance | 2 |
| diff b/w sub query and co-relater query? | iFlex | 3 |
| What is the result, when NULL is compared with NULL? | TCS | 10 |
| What are nested triggers ? | TCS | 4 |
| How you will create Toad Function? | | 1 |
| how do u call in & out parameters for stored procedures? | A1-Technology | 7 |
| If a View on a single base table is manipulated will the
changes be reflected on the base table? | | 3 |
| How can we overcome recursive triggers in SQL? | iFlex | 1 |
| in materialized view the structure will create immediately
or not? | iFlex | 2 |
| How to call DDL statements from pl/sql? | | 3 |
| Can we write create command in the plsql block?if possible
how? | | 2 |
| how to retrieve only duplicate values in a table | | 1 |
| what is the purpose of update command in oracle? | MBT | 6 |
| 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 |
| How will we see framework of a table? | Accenture | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
