| Other SQL PLSQL Interview Questions |
|| Asked @
|What are the Restrictions on Cursor Variables?
|hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
|What does “select count(*) from tab” result?
|IF i write before / after insert / update trigger and i do
rollback what will happen?
|Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
|1 SELECT a.field1, b.field2, c.field3, d.field4
2 FROM atable a, atable b, ctable c, dtable d
4 ORDER BY 1
What is the minimum number of joins that must be specified
on line 3 in the sample code above to properly link the
tables? Notice that the table "atable" is aliased twice:
once as "a" and once as "b."
1. One join
2. Two joins
3. Three joins
4. Four joins
5. Five joins
|what is the correct way of selection statement
|What are different types of refreshment techniques of
|What is the differnce between view and materialized view
|Can a view be updated/inserted/deleted?If Yes under what
|There is a table, In one column it has implemented a index,
but the index is disturbed by the regular dml statements..
but still we need to keep the index. how it is possible?
|what is meant by forward declaration in functions?
|For more SQL PLSQL Interview Questions Click Here |