NIIT Oracle Questions

I want NIIT Oracle question paper so is there any site from where can I get it?

You want NIIT Oracle question paper so it has available on our website. I am giving you its link. By click on this link you will redirect to that page from where you can free download zip file of question paper by do registration on our site which is quick and easy process.

http://studychacha.com/discuss/25085...le-papers.html

__________________
Answered By StudyChaCha Member

I am doing Oracle training from National Institute of Information Technology NIIT searching for interview questions. Will you provide NIIT SQL/PLSQL Oracle Interview Questions?

National Institute of Information Technology is an Indian Multinational company that offers learning management and training delivery solutions to corporations, institutions and individuals.

It has three main lines of business worldwide: Corporate Learning Group, Skills and Careers Group, and School Learning Group.

NIIT SQL/PLSQL Oracle Interview Questions

Explain about Oracle Architecture?

What happens when query is executed?Explain.

What is library cache,Data Dictionary?

What is Result Cache?What is deterministic?

What is collection. Have u declared constructor in collections? Which collection have u used?

What is Multiset operator?

How to find lock on table?

If application is working slow. what are the issues? (Data volume is not changed,No network issues).

What is explain plan. How do u read explain plan. What informtion does it show?

What is statistics.

If we create a new table say emp, no statistics is generated, no records are inserted than

whether explain plan will be generated?

What are anyalytical function? LAG,LEAD?

What is overloading? Can procedure be overloaded?

What is pragma Autonomous Transaction?

What is Trigger.Can we commit in trigger? Compound Trigger?

Can we commit in compound triggers?

Can function be called from Trigger?

Information about syntax check in library cache is obtained from?

Information about symantic check in library cache is obtained from?

What is Soft parse,Hard parse?

A table has record with value 20. updating the value as 30, what information would be in undo segment and what in redo logs.

What is the minimum no of redo logs required?

Whether Archiver process is necessary?

Contact:

India
corptraining@niit.com

__________________
Answered By StudyChaCha Member