| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are Lexical Parameters.How They are used in Reports 6i | eicc | 2 |
| Explain the two type of Cursors ? | Hi-Caliber-IT | 8 |
| difference between pl/sql table and normal pl/sql table | | 2 |
| What are the components of a PL/SQL block ? | | 1 |
| which will fire first ? Trigger or Constraint | IBM | 12 |
| What is TABLE SPACE? | ABB | 3 |
| 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 |
| How toimport .dmp file in lower version of oracle from
higher version ? | TCS | 2 |
| how can we find the select statement is indexed or not? | CTS | 2 |
| What is integrity constraints? | Ramco | 4 |
| how to insert values like 10:10:00,30:25:00 etc.into table
after insert how can i sum the above insert values to get
the result as 40:35:00 | | 2 |
| write a query to delete similar records in particular
fields(columns) in different tables | TCS | 6 |
| What is a bitmap index? | Choice-Solutions | 3 |
| What is a Procedure ? | | 2 |
| How do you handle exceptions. Give the syntax for it? | Microsoft | 1 |
| How can you create Cursor with parametres ? | | 3 |
| Regarding joins what are the differences you observed in
oracle 9i and sql server? | Choice-Solutions | 3 |
| can i use dbms_output.put_line in a function u are telling
as return statement | | 6 |
| What is the difference between DELETE and TRUNCATE? | Tech-Mahindra | 14 |
| Difference between SUBSTR and INSTR? | | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
