| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ? | IBM | 9 |
| What is difference between % ROWTYPE and TYPE RECORD ? | | 2 |
| What is Data Concarency and Consistency? | | 1 |
| why should required for Indexed by table in pl/sql | | 2 |
| wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
| Apollo | 3 |
| Can we relate two different tables from two different users
in ORACLE,PL/SQL? | | 4 |
| 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:
pankit.lodaya@accenture.com | Wipro | 2 |
| in a package one procedure is wrong package shows valid or not | | 3 |
| what is purge command
explain about oracle performance tuning | Accenture | 2 |
| If a View on a single base table is manipulated will the
changes be reflected on the base table? | | 4 |
| Can we use SQL%ISOPEN in implicit cursors? Does this
attribute works properly in Implicit Curosors? | | 2 |
| What is pragma exception and how, when, where us | | 4 |
| Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ? | PreVator | 4 |
| What does “select count(*) from tab” result?
| IBM | 5 |
| Please let me know if UNION ALL and Natural Join does the
same operation and are same... | iGate | 3 |
| How toimport .dmp file in lower version of oracle from
higher version ? | TCS | 2 |
| difference between oracle 8i and oracle 9i | | 8 |
| Difference between SUBSTR and INSTR? | | 2 |
| wht is the difference between sqlaserver2000 and 2005 | ABC | 1 |
| What is difference between triggers and stored procedures.
And advantages of SP over triggers ? | TCS | 2 |
| |
| For more SQL PLSQL Interview Questions Click Here |