Oracle Interview Questions - Frequently Asked Online Test

What is Exception propagation in Oracle?


What is RAISE_APPLICATION_ERROR?


In Oracle, which index is created by default?


What is Connect by Prior used for?


How is ROWID stored in the Database?


What is the output of each statement?

a. Select * from emp where rownum=5;

b. Select * from emp where rownum=1;

c. Select * from emp where rownum=0;


Can you call a Trigger inside a Procedure?


Can you do a commit in a Trigger?


What is a “Snapshot too old error”?


How to create index-by table in oracle?

















Description:

Samples taken from the Interview Preparation kit by DTecH IT Education. Buy from http://products.oraclepassport.com

Discussion

Rahul Sharma

Hi There,

Your blog is such a complete read. I like your approach with Oracle Interview Questions - Frequently Asked Online Test. Clearly, you wrote it to make learning a cake walk for me.

A stored procedure is a <a href="https://asha24.com/blog/plsql-interview-questions-and-answers/">See more

1519 days 16 hours 32 minutes ago

Krishna Kumar

Hi There,


Smokin hot stuff! You’ve trimmed my dim. I feel as bright and fresh as your prolific website and blogs!


I have a source server (Lets say ServerA) from where I'm pulling data from. It has less memory. But my ssis packages are deployed in SSIS server (ServerB) which has lot of memory.
In script component, I'm pulling the data into data table and querying it in the transformation (Range lookup). In this scenario, when the datatable is build in Script component, where is it stored? Is it stored in memory of ServerA or ServerB?
I look forward to see your <a href="https://asha24.com/blog/sql-interview-questions-and-answers/">nextSee more

1530 days 13 hours 44 minutes ago

Krishna Kumar

Hi There,


Smokin hot stuff! You’ve trimmed my dim. I feel as bright and fresh as your prolific website and blogs!


I have a source server (Lets say ServerA) from where I'm pulling data from. It has less memory. But my ssis packages are deployed in SSIS server (ServerB) which has lot of memory.
In script component, I'm pulling the data into data table and querying it in the transformation (Range lookup). In this scenario, when the datatable is build in Script component, where is it stored? Is it stored in memory of ServerA or ServerB?
I look forward to see your <a href="https://asha24.com/blog/sql-interview-questions-and-answers/">nextSee more

1530 days 13 hours 44 minutes ago

Rajesh

it officer tests

2376 days 11 hours 26 minutes ago

Sridher

i want more online tests

3025 days 3 hours 45 minutes ago

DTecH IT Education
DTecH IT Education-Your mentor for a better Career
User
42 Followers

Your Facebook Friends on WizIQ

More Tests By Author

SQL Course completion Exam
10 Questions | 875 Attempts

1Z0-051: Oracle 11g SQL Exam
25 Questions | 17485 Attempts

Oracle SQL, PL/SQL Quiz
10 Questions | 52124 Attempts