Oracle Interview Questions - Frequently Asked Online Test

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 sequence of statements that perform </a> specific function.

there are TWO tables as below
USER_DATA_B
1>USER_ID
2>CUST_ID
3>CREATE_DT
4>LOG_ID

USER_LOGON_ID_CHANGE_B
1> ID
2>USER_ID
3>NEW_LOGON_ID
4>OLD_LOGON_ID
5>OLD_CREATE_DT
6>ROW_CREATE_DT

the existing query to show the details in UI is as below

SELECT USER_ID,OLD_CREATE_DT,ROW_CREATE_DT FROM USER_LOGON_ID_CHANGE_B WHERE OLD_LOGON_ID=?
AND NEW_LOGON_ID IS NULL
UNION
SELECT USER_ID,CREATE_DT,NULL FROM USER_DATA_B WHERE LOG_ID=?
ORDER BY OLD_CREATE_DT


Now, my requirement is to join the above query with the following table
CUSTOMER_ATTRIBUTE_B
1>CUST_ID
2> ATTRIBUTE_TYPE_CD
3>ATTRIBUTE_DATA

The new query output should be below
1>USER_ID
2>OLD_CREATE_DT,
3>ROW_CREATE_DT
4> ATTRIBUTE_TYPE_CD
5>ATTRIBUTE_DATA

Great effort, I wish I saw it earlier. Would have saved my day :)

Thank you,
Jim

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/">next… See more updates</a>.


Many Thanks,
Krishna kumar

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/">next… See more updates. </a>


Many Thanks,
Krishna kumar

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