| Other SQL PLSQL Interview Questions |
|| Asked @
|What is Primary Key?
|What is normalization and types of normalization?
|diff b/w sub query and co-relater query?
|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?
|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.
|how can i create a user defined datatype
|counting the no.of characters occurs in a string by using
|i need department wise top 2 employees salary.which logic
i will use
|using subquery how can i calculate working days in a month?
|Q1.all the depts which has more then 10 empls? Q2.all the
dept which does not have any emply? Q3 all the emp which
does not have any dept? Q4 get all the emply detais with
the dept details it dept is exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
|Write a query to get last 10 records from the table.
|Does it possible to pass object (or) table as an argument
to a remote procedure?
|For more SQL PLSQL Interview Questions Click Here |