Wednesday, March 30, 2011

Spring Interview Question

What do you mean by auto wiring?

Spring Interview Question

What do you mean by bean wiring?

Supplier Site Bank Account tables in R12

In which tables can we find supplier site related bank account information in R12?

Tuesday, March 29, 2011

Spring Interview Question

What are the different implementations of Application Context?

Spring Interview Question

What is Application Context?

Spring Interview Question

What is bean Factory?

Spring Interview Question

What are features of Spring

Spring Interview Question

What are the different types of dependency Injection?

Spring Interview Question

What is IOC or Dependency Injection

Spring Interview Question

What are the advantages of pring?

Saturday, March 26, 2011

Interview Question

Given two sorted liked lists merge the two lists into single sorted list

Interview Question

Given a linked list with numbers. Remove the duplicates from the linked list

Interview Question

Given a linked list(circular) and numbers in the list are sorted. Given a pointer to the node find the minimum number in the list.

Interview Question

 


Find the first non repeated character of a string

Interview Question

Write a program to remove duplicate characters.  "aaabbbbcccddd" → "abcd"

Friday, March 25, 2011

Path traversal attack vectors

Here is some test cases to test path traversal attack.


 


Path traversal attack vectors

Here is some test cases to test path traversal attack.


 


How to retrieve Nth row from database table?

How to retrieve Nth row from SQL server?
Microsoft SQL Server Selecting the first row:
SELECT TOP 1 * FROM tblUsers
Selecting the fifth row:
SELECT TOP 1 * FROM (SELECT TOP 5 * FROM
tblusers ORDER BY 1 ASC) RANDOMSTRING
ORDER BY 1 DESC;



MySQL: How to retrieve Nth row from MySql?
SELECT * FROM tblUsers LIMIT 1,1
Selecting the fifth row:
SELECT * FROM tblUsers LIMIT 5,1



Oracle:How to retrieve Nth row from Oracle?
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=1;
SELECT * FROM tblUsers WHERE rownum=1;
Selecting the username column from the fifth row:
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=5;

How to retrieve Nth row from database table?

How to retrieve Nth row from SQL server?
Microsoft SQL Server Selecting the first row:
SELECT TOP 1 * FROM tblUsers
Selecting the fifth row:
SELECT TOP 1 * FROM (SELECT TOP 5 * FROM
tblusers ORDER BY 1 ASC) RANDOMSTRING
ORDER BY 1 DESC;



MySQL: How to retrieve Nth row from MySql?
SELECT * FROM tblUsers LIMIT 1,1
Selecting the fifth row:
SELECT * FROM tblUsers LIMIT 5,1



Oracle:How to retrieve Nth row from Oracle?
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=1;
SELECT * FROM tblUsers WHERE rownum=1;
Selecting the username column from the fifth row:
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=5;

Interview Question

Write a program to print permutations

Saturday, March 19, 2011

Unix Question

What scheme does the Kernel in Unix System V follow while choosing a swap device among the multiple swap devices?

Unix Question

What scheme does the Kernel in Unix System V follow while choosing a swap device among the multiple swap devices?

Unix Question

What is the main goal of the Memory Management?

Unix Question

What is the main goal of the Memory Management?

Unix Question

What do you mean by u-area (user area) or u-block?

Unix Question

What do you mean by u-area (user area) or u-block?

Unix Question

What is IPC? What are the various schemes available?

Unix Question

What is IPC? What are the various schemes available?

Unix Question

How do you execute one program from within another?

Unix Question

How do you execute one program from within another?

Unix Interview Question

What is an advantage of executing a process in background?

Unix Interview Question

What is an advantage of executing a process in background?

Unix Interview Question

What is 'ps' command stands for?

Unix Interview Question

What is 'ps' command stands for?

Unix Interview Question

Discuss mount and unmount system calls

Unix Interview Question

Discuss mount and unmount system calls

Is XSS exists in the below case?

There exists input field, which allows all type of malicious(XSS) characters and it allows to send it to the server. But the server doesn't respond to any request.  Is this vulnerable condition? if so, how to proove it?

For ex:
A application has feed back functionality. In the process of testing this functionality, an attacker sent malicious character to the server..and it allows to send any type of characters. But the application responds with a message saying "Feeb back received, thanx". Is this case vulnerable?


 


 


 

Is XSS exists in the below case?

There exists input field, which allows all type of malicious(XSS) characters and it allows to send it to the server. But the server doesn't respond to any request.  Is this vulnerable condition? if so, how to proove it?

For ex:
A application has feed back functionality. In the process of testing this functionality, an attacker sent malicious character to the server..and it allows to send any type of characters. But the application responds with a message saying "Feeb back received, thanx". Is this case vulnerable?


 


 


 

PO_ACTION_HISTORY

How  to  find the  list  of  approvers  for  a  requisition?


 

PO_ACTION_HISTORY

How  to  find the  list  of  approvers  for  a  requisition?


 

Friday, March 18, 2011

Is XSS server side or client side vulnerability

Is Cross Site Scripting is server side vulnerability or client side vulnerability?

Is XSS server side or client side vulnerability

Is Cross Site Scripting is server side vulnerability or client side vulnerability?

Interview Question

Given a sorted array of size m+n which has only n elements in it. Given one more array with m elements where the elements are sorted. Without using extra space merge both the arrays to form a single sorted array. Give efficient solution.

Interview Question

Consider a two-dimensional grid of cells, each of which may be empty or filled. The filled cells  that are connected form a sector. Two cells are said to be connected if they are adjacent to each other horizontally, vertically or diagonally. There may be several sectors on the grid. Your job is to find the largest sector (in terms of number of cells) on the grid. 

Java Interview Question

What is difference between sleep and wait methods in java

Java Interview Question

 


What is comparable interface? When do you use it?

Thursday, March 17, 2011

Java Interview Question

Given an example of tag interface? what is the use of tag interface and write a class which is a tag interface

Java Interview Question

What is the difference between shallow copy and deep copy in java?

Wednesday, March 16, 2011

PO Approval Workflow stucket at "Deferred" status

Hi,


I have a PO which is waiting for approval from user. But, the notification has not gone to approver's worklist. How to rectify this in workflow?


 


Thanks..

PO Approval Workflow stucket at "Deferred" status

Hi,


I have a PO which is waiting for approval from user. But, the notification has not gone to approver's worklist. How to rectify this in workflow?


 


Thanks..

query to find vendor’s responses to negotiations for which the vendor has been invited.

Hi to all,


             Please help me to resolve this issue.i am stuck.





·        query to list out all the details of the negotiations the vendor has been invited.


·         The vendor responses, awards.


·         Purchase orders created against the quotes.


Thanks to all


 


 




 

Monday, March 14, 2011

What do you meant by "triple X" in Networks?


The function of PAD (Packet Assembler Disassembler) is described in a document known as X.3. The standard protocol has been defined between the terminal and the PAD, called X.28; another standard protocol exists between hte PAD and the network, called X.29. Together, these three recommendations are often called "triple X"

What are the different ways of data exchange?

Simplex,Duplex and full-duplex

Difference between the communication and transmission


Transmission is a physical movement of information and concern issues like bit polarity, synchronisation, clock etc.


            Communication means the meaning full exchange of information between two communication media.

what is subnet?


A generic term for section of a large networks usually separated by a bridge or router.

What are the two types of transmission technology available?

Broadcast and point-point protocol

Query to find receipt details against PO in R12

SQL Query to check receipt details for a PO in R12

Sunday, March 13, 2011

Saturday, March 12, 2011

Unix Interview Question


Predict the output of the following program code


main()


{


fork(); fork(); fork();


printf("Hello World!");


}


Unix Interview Question


Predict the output of the following program code


main()


{


            fork();


printf("Hello World!");


}


Unix Interview Question

Explain fork() system call.

Unix Interview Question

What is a Shell?

Unix Interview Question

What is FIFO?

Unix Interview Question

What is inode?

Unix Interview Question

How are devices represented in UNIX?

Friday, March 11, 2011

FA Depreciation Query


select  fb.BOOK_TYPE_CODE


       ,fa.ASSET_NUMBER


       ,fa.asset_id


       ,fdp.period_name


       ,fat.DESCRIPTION ASSET_DESCRIPTION


       ,fa.OWNED_LEASED


       ,fc.SEGMENT1 MAJOR_CATEGORY


       ,fc.SEGMENT2 MINOR_CATEGORY


       ,fb.DEPRN_METHOD_CODE


       ,fc.SEGMENT3 TOWER


       ,gcc.segment3 PROJECT_CODE


       ,ppa.name     PROJECT_NAME


       ,fak.segment1 OWNER_OF_ASSET


       ,pap.FULL_NAME EMPLOYEE_NAME


       ,pap.EMPLOYEE_NUMBER 


   --    ,fl.CONCATENATED_SEGMENTS LOCATION


       ,gcc.segment3 Project


       ,gcc.segment4 Facility


       ,gcc.segment5 STP


       ,gcc.CONCATENATED_SEGMENTS DEPRECIATION_FLEX


       ,fb.DATE_PLACED_IN_SERVICE


       ,(fb.LIFE_IN_MONTHS/12) LIFE_IN_YEARS    


       ,fb.LIFE_IN_MONTHS


       ,gl.CURRENCY_CODE 


       ,ROUND(fb.COST,2) COST   


     ,fds.DEPRN_AMOUNT 


  ,fds.DEPRN_RESERVE ACC_DEPRN     ,ROUND(DECODE(fdp.FISCAL_YEAR,fbc.CURRENT_FISCAL_YEAR,fds.YTD_DEPRN,0),2) YTD_DEPRN


from    apps.fa_additions_b      fa 


       ,apps.fa_categories       fc 


       ,apps.fa_locations_kfv    fl 


       ,apps.fa_books            fb 


       ,apps.pa_projects_all     ppa    


       ,apps.per_all_people_f    pap


       ,apps.fa_distribution_history fdh


       ,apps.gl_code_combinations_kfv gcc


       ,apps.fa_deprn_periods    fdp


       ,apps.fa_deprn_summary    fds


       ,apps.fa_book_controls    fbc


       ,apps.gl_ledgers          gl


       ,apps.FA_CATEGORY_BOOKS   fcb


       ,apps.gl_code_combinations_kfv gcc1


       ,apps.FA_ASSET_KEYWORDS   fak


       ,apps.hr_operating_units  hou


       ,apps.fa_additions_tl     fat


where  fa.ASSET_CATEGORY_ID      = fc.CATEGORY_ID


and    fa.ASSET_ID               = fat.ASSET_ID(+)


and    fdh.LOCATION_ID           = fl.LOCATION_ID(+)


and    fa.ASSET_ID               = fb.ASSET_ID


and    gcc.segment3              = ppa.segment1(+)


and    fa.ASSET_ID               = fdh.ASSET_ID(+)


and    fdh.assigned_to           = pap.PERSON_ID(+)


and    fdh.CODE_COMBINATION_ID   = gcc.CODE_COMBINATION_ID(+)


and    fb.BOOK_TYPE_CODE         = fdp.BOOK_TYPE_CODE


and    fds.ASSET_ID              = fb.ASSET_ID


and    fb.BOOK_TYPE_CODE         = fbc.BOOK_TYPE_CODE


and    fbc.SET_OF_BOOKS_ID       = gl.LEDGER_ID


and    gl.LEDGER_CATEGORY_CODE   = 'PRIMARY'


and    fcb.CATEGORY_ID(+)        = fc.CATEGORY_ID


and    fcb.BOOK_TYPE_CODE        = fb.BOOK_TYPE_CODE(+)


and    fcb.ASSET_COST_ACCOUNT_CCID = gcc1.CODE_COMBINATION_ID


and    fa.ASSET_KEY_CCID         = fak.CODE_COMBINATION_ID(+)


and    hou.SET_OF_BOOKS_ID       = gl.ledger_id


and    fdp.PERIOD_COUNTER        = DECODE(fbc.INITIAL_PERIOD_COUNTER,fds.PERIOD_COUNTER,fds.PERIOD_COUNTER + 1 ,fds.PERIOD_COUNTER)                            


and    sysdate between nvl(pap.EFFECTIVE_START_DATE(+),sysdate) and nvl(pap.EFFECTIVE_END_DATE(+),sysdate)


and    fb.DATE_INEFFECTIVE  IS NULL


and    fdh.DATE_INEFFECTIVE IS NULL


 


Thursday, March 10, 2011

Query to find orders on hold in Oracle Apps 11i

SELECT rc.CUSTOMER_NAME, ooha.ORDER_NUMBER, ohsa.HOLD_COMMENT, ohd.NAME, ohd.TYPE_CODE, oola.ORDERED_ITEM,
(oola.ORDERED_QUANTITY * oola.UNIT_SELLING_PRICE) AMOUNT
FROM
OE_ORDER_HEADERS_ALL ooha
,OE_ORDER_HOLDS_ALL oha
,OE_HOLD_SOURCES_ALL ohsa
,OE_HOLD_DEFINITIONS ohd
,OE_ORDER_LINES_ALL oola
,RA_CUSTOMERS rc
WHERE
ooha.HEADER_ID = oola.HEADER_ID
AND ooha.HEADER_ID = oha.HEADER_ID
AND oola.LINE_ID = oha.LINE_ID
AND oha.RELEASED_FLAG='N'
AND oha.HOLD_SOURCE_ID = ohsa.HOLD_SOURCE_ID
AND ohsa.HOLD_ID = ohd.HOLD_ID
AND rc.CUSTOMER_ID = ooha.SOLD_TO_ORG_ID
AND ooha.ORDER_NUMBER= <ORDER_NUMBER>


By: Rads

Wednesday, March 9, 2011

Query for JE Source Cost Management

How to get vendor details for je source cost management in Oracle R12?

Microsoft Interview Question


write a program to print all elements of a binary tree using a breadth First traversal through it.

Tuesday, March 8, 2011

ORACLE APPS AP

ORACLE APPS AP INTERVIEW QUETIONS

Delivered Quantity is greater than PO Quantity

The delivered quantity is 20 and PO Quantity is 2.

What might be the reason for the user to receive the quantity greater than PO Quantity?

Here,it is mentioned the over receipt tolerance is 10% in Receiving Parameters

RTF file Location in Oracle Apps R12

The rtf files loaded through XML Publisher Administrator can be found in $XDO_TOP/patch/115/publisher/templates/US.

PO Requisitions

Query to find requisitions pending for approval from a User

Sunday, March 6, 2011

Thursday, March 3, 2011

Interview Question

A boy, a girl and a dog are standing together on a long, straight road. Simultaneously, they all start walking in the same direction: The boy at 4 mph, the girl at 3 mph, and the dog trots back and forth between them at 10 mph. Assume all reversals of direction instantaneous. In one hour, where is the dog and in which direction is he facing?