| Other SQL PLSQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| Give the structure of the function ? |
| 1 |
| i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query. |
tcs | 3 |
| what are %TYPE and %ROWTYPE? what is the difference?
|
Saama-Tech | 7 |
| What is Data Concarency and Consistency? |
| 1 |
| how can stop the sequence with mention the max value and
with out mention the max value |
Zensar | 1 |
| How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table? |
Wipro | 26 |
| Delete the emps whose salaries are lowest sals of their own
dept. |
| 5 |
| how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o); |
Satyam | 9 |
| What is Difference Between delete and Truncate? |
| 9 |
| What is Materialized View? In What Scenario we Use
Materialized View? |
Marlabs | 2 |
| query to retrive the employees whose sal is greater than avg
sal |
TCS | 9 |
| Is it possible to access the current value in a session
before accessing next value? |
| 1 |
| |
| For more SQL PLSQL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
