| Other SQL PLSQL Interview Questions |
|| Asked @
|i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks
i need 1st dd for evry wk
|What are the pre requisites?
|why should required for Indexed by table in pl/sql
lowerl number:= 1;
upperl number:= 3;
for i into lowerl..upperl
if i=3 then upperl:=5;
What will be the output ?
|If a View on a single base table is manipulated will the
changes be reflected on the base table?
|write a query that returns first characters of each word in
Oracel/Sql pl sql
|what is the main difference between join and subqurey?
|why sql is used as interpreter frequently rather than a
|can we create index on index?
|What is bulk collections?
|IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
|What are the differences between Database Trigger and
Integrity constraints ?
|For more SQL PLSQL Interview Questions Click Here |