Give two methods you could use to determine what DDL
changes have been made.
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Explain materialized views and how they are used.
1. What is PO rate variance gain and loss?
When a user process fails, what background process cleans up after it?
i have marks in table,how to find total?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What background process refreshes materialized views?
Explain the difference between a data block, an extent and a segment.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the sql query to find the employee who has Nth maximum salary?
How client makes connection with server in client/server architecture?