TCS QUESTIONS


1. what is the order of pre-defined exceptions?
2. what is mean by forward declaration and where we'll use it ?
3. what is bulk bind ?
4. can we call procedure in package ?
5. How toimport .dmp file in lower version of oracle from higher version ?
6. How do u call in & out parameters for stored procedures?
7. What are nested triggers ?
8. Types of joins ?
9. How to create object in plsql ?
10.Write the Sql query for creating database backup ?
11. What is TABLE SPACE?

12. Begin
For j in 4403201000 .. 4403202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
what will be the output of this question ?

13.Write a query to delete similar records in same table ?