Saturday, February 26, 2011

What is bank reconciliation?

What are Non-Performing Assets?

What are Fixed Assets?

What are the various methods of calculating depreciation?

Difference between debenture holders and creditors

Which procedure needs to be called to enable DFF in a FORM?

Tuesday, February 22, 2011

In how many ways can you enter a journal in GL?

What are AP setup steps?

suppliers....>invoices..>payments.....>reports......>periods.....>transfer to GL

What is the difference between discounts and adjustments?

Discount : attached to price.

Adjustments : At the time of transactions can give additional discount through adjustments.

Which module is not Multi Org?

How to find AP Duplicate Invoices using below Query

SELECT hou.name operating_unit
,pv.vendor_name
,ai.invoice_id
,ai.invoice_num invoice#
,ai.invoice_amount
,ai.amount_paid
,ai.invoice_date
,ai.payment_status_flag pay_status
,fu.description entered_by
,ai.creation_date
,ai.last_update_date
from ap_invoices_all ai
,hr_operating_units hou
,po_vendors pv
,fnd_user fu
where ai.org_id = hou.organization_id
and ai.created_by = fu.user_id
and pv.vendor_id = ai.vendor_id
and ai.creation_date >= '01-JAN-05'

Query to extract responsibility,list of functions and menus

Interview Question

7 people in a circle, the third one will be deleted in each round. Use loop or recursive. How many loop and which data structure you will use to store these data?

Friday, February 18, 2011

What are different types of column in Oracle reports?

There are three types of columns in the report 6i these are:

1) Placeholder Column – Placeholder column is used to store a value for a variable.
2) Formula Column
3) Summary Column

Concurrent Jobs executed by User

SELECT
fcr.REQUEST_ID,
FU.USER_NAME,
fcr.PHASE_CODE,
fcr.STATUS_CODE,
(fcr.ACTUAL_COMPLETION_DATE – fcr.ACTUAL_START_DATE) * 24 * 60 TIME_MINS,
fcpt.USER_CONCURRENT_PROGRAM_NAME,
fcp.CONCURRENT_PROGRAM_NAME,
fcr.ACTUAL_START_DATE,
fcr.ACTUAL_COMPLETION_DATE,
fcp.CONCURRENT_PROGRAM_NAME
FROM
apps.FND_CONCURRENT_REQUESTS FCR,
apps.FND_CONCURRENT_PROGRAMS FCP,
apps.FND_CONCURRENT_PROGRAMS_TL FCPT,
apps.FND_USER FU
WHERE 1=1
AND FCP.CONCURRENT_PROGRAM_ID=FCR.CONCURRENT_PROGRAM_ID
AND FCPT.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID
AND FCR.REQUESTED_BY = FU.USER_ID
AND FU.USER_NAME = ‘&user’
ORDER BY FCR.REQUEST_ID DESC;

Concurrent Programs that ran yesterday and Failed

SELECT
fu.user_name,
fcpt.USER_CONCURRENT_PROGRAM_NAME,
fcpt.description,
fcp.CONCURRENT_PROGRAM_NAME,
fcr.REQUEST_ID,
round((fcr.actual_completion_date – decode (trunc(fcr.request_date),fcr.requested_start_date,fcr.request_date,fcr.requested_start_date))*60*24) WaitTimeMIN,
DECODE(fcr.PHASE_CODE,‘C’,‘Completed’,‘R’,‘Running’,fcr.PHASE_CODE) PHASE_CODE,
DECODE(fcr.STATUS_CODE,‘C’,‘Completed’,‘R’,‘Running’,‘W’,‘Paused’,‘E’,‘Error’,‘G’, ‘Warning’, fcr.STATUS_CODE) STATUS_CODE,
to_char(fcr.request_date,‘DD-MON-YYYY HH24:MI:SS’) request_date,
to_char(fcr.requested_start_date,‘DD-MON-YYYY HH24:MI:SS’) start_time,
to_char(fcr.actual_completion_date,‘DD-MON-YYYY HH24:MI:SS’) complete_time
FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_user fu
WHERE 1=1
AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID
AND fcpt.CONCURRENT_PROGRAM_ID=fcp.CONCURRENT_PROGRAM_ID
AND fcr.requested_by = fu.user_id
AND trunc(fcr.request_date) BETWEEN sysdate – 1 AND sysdate
AND fcr.status_code IN (‘E’,‘G’)
ORDER BY fcr.status_code,fcp.CONCURRENT_PROGRAM_NAME,fcr.REQUEST_ID;

Merging k sorted lists


Suppose you have k sorted lists with a total of N elements. Give an O(N log k) algorithm to produce a sorted list of all N elements

2D maxima

Given a set of n points in the plane, point (xi, yi) dominates (xj, yj) if xi > xj and yi > yj. A maxima is a point that is not dominated by any other point in the set. Devise an O(n log n) algorithm to find all maxima. Application: on x-axis is space efficiency, on y-axis is time efficiency. Maxima are useful algorithms. Hint: sort in ascending order according to x-coordinate; scan from right to left, recording the highest y-value seen so far, and mark these as maxima.

Sum of four primes

The Goldbach conjecture says that all positive even integers greater than 2 can be expressed as the sum of two primes. Given an input parameter N (odd or even), express N as the sum of four primes (not necessarily distinct) or report that it is impossible to do so. To make your algorithm fast for large N, do the following steps:

1.Compute all primes less than N using the Sieve of Eratosthenes.
2.Tabulate a list of sums of two primes.
3.Sort the list.
4.Check if there are two numbers in the list that sum to N. If so, print out the corresponding four primes.

Thursday, February 17, 2011

Duplicate count. Give a sorted array of N elements, possibly with duplicates, find the index of the first and last occurrence of k in O(log N) time. Give a sorted array of N elements, possibly with duplicates, find the number of occurrences of element k in O(log N) time

How to set font in android

How to set background color in android?

How to store data in the database in android

How to create a AVD in android

Suppose you have a coffee can which contains an unknown number of black beans and an unknown number of white beans. Repeat the following process until exactly one bean remains: Select two beans from the can at random. If they are both the same color, throw them both out, but insert another black bean. If they are different colors, throw the black one away, but return the white one. Prove that this process terminates with exactly one bean left. What can you deduce about the color of the last bean as a function of the initial number of black and white beans? Hint: find a useful invariant maintained by the process.

Given N intervals on the real line, determine the length of their union in O(N log N) time. For example the union of the four intervals [1, 3], [2, 4.5], [6, 9], and [7, 8] is 6.5

How to find whether two linked lists intersect each other? If yes find the intersection point

Wednesday, February 16, 2011

What is Auto lockbox in Oracle Apps Receivables?

Multi-Org Access Control(MOAC) Preferences

How to change the order line status from booked to awaiting shipping in booked order

R12 EBTax and Vertex

Moving PO/PR commitment in Oracle Purchasing to next year

The accounting setup process in Oracle General Ledger consists of three main steps. (Choose three.) A. Update accounting options. B. Approve accounting options. C. Complete the accounting setup. D. Create an accounting setup structure.

Journal creation rules in Subledger Accounting are defined by event type and event class. Identify the event type associated with the event class of reverse.

Is it possible to invoke the camera through a WebView instance?

Someone please provide some information (some links)about how to handle session management in android.

Getting this exception However, when started I get "Unable to start activity ComponentInfo" and in the details: android.view.InflateException: Binary XML file line #24: Error inflating class

Friday, February 11, 2011

A person with some money spends1/3 for cloths, 1/5 of the remaining for food and 1/4 of the remaining for travel. He is left with Rs 100/- . How much did he have with him in the begining ?

Light glows for every 13 seconds . How many times did it glow between 1:57:58 and 3:20:47 am.

How can 1000000000 be written as a product of two factors neither of them containing zeros

Complete the series: 5, 20, 24, 6, 2, 8, ?

Two trains start from stations A and B spaced 50 kms apart at the same time and speed. As the trains start, a bird flies from one train towards the other and on reaching the second train, it fliesback to the first train.This is repeated till the trains collide. If the speed of the trains is 25 km/h and that of the bird is 100km/h. How much did the bird travel till the collision.

Seven members sat around a table for three days for a conference. The member's names were Abhishek, Amol, Ankur, Anurag,Bhuwan ,Vasu and Vikram. The meetings were chaired by Vikram. On the first evening members sat around the table alphabetically. On the following two nights, Vikram arranged the seatings so that he could have Abhishek as near to him as possible and abesent minded Vasu as far away as he could. On no evening did any person have sitting next to him a person who had previously been his neighbour. How did Vikram manage to seat everybody to the best advantage on the second and third evenings?

A hotel has 10 storeys.Which floor is above the floor below the floor, below the floor above the floor, below the floor above the fifth.

Fifty minutes ago if it was four times as many minutes past three 'clock,how many minutes is it to six o'clock?

Some statements are given below: L says all of my other four friends have money M says that P said that exactly one among them has money N says that L said that precisely two among them have money O says that M said that three of the others have money P, L and N said that they have money All the above statement are false.. Who has money & who doesn't have any money?

Five people A ,B ,C ,D ,E are related to each other. Four of them make one true statement each as follows. (i) B is my father's brother. (ii) E is my mother-in-law. (iii)C is my son-in-law's brother (iv)A is my brother's wife.

The Bulls, Pacers, Lakers and Jazz ran for a contest. Anup, Sujit, John made the following statements regarding results. Anup said either Bulls or Jazz will definitely win Sujit said he is confident that Bulls will not win John said he is confident that neither Jazz nor Lakers will win When the result cameit was found that only one of the above three had made a correct statement. Who has made the correct statement and who has won the contest.

There are 3 societies A, B, C. A lent cars to B and C as many as they had already. After some time B gave as many tractors to A and C as many as they have. After sometime c did the same thing. At the end of this transaction each one of them had 24.Find the cars each orginally had.

Three friends divided some bullets equally. After all of them shot 4 bullets the total number of bullets remaining is equal to the bullets each had after division.Find the original number divided.

Shadow went to an Isle where the natives lie and the visitors speak truth. Shadow saw a salesman and wanted to know whether he was a native or a visitor. He did not pose a question directly but asked him indirect instead. Shadow saw a woman and asked the salesman,"Is that a NATIVE or VISITOR?" .For which the salesman replied," She is a visitor".Is the salesman a Native or a Visitor?

The time taken to travel in train from Town A to Town B is 5 hours. There are trains starting from both towns at an interval of 1 hour. How many trains meet in 1 trip?

There's an electric wire running 1 km from the side of a building. The number of poles in between them is placed in an interval of distance between each other. If one pole is removed then the distance between each pole becomes 1 2/3 meters. Find out how many poles were kept.

There is a cube, which has to be inscribed with the following pair of numbers on opposite sides.1 and 6, 2 and 4,3 and 5. How many different ways can it be done?

Geoffrey, Hallmann and Molly attend and interview and give three different statements each. To make it a little complex. Out of the three statements made by each one, one is false. Geoffrey says: I am 22 - false Hallmann is elder than me by one year. Molly is 25

Some people went for vaction. Unfortunately it rained for 13 days when they were there. But whenever it rained in the morning, they had clean afternood and vice versa. In all they enjoyed 11 morning and 12 afternoons. How many days did they stay there totally?

Ram singh goes to his office in the city every day from his suburban house. His driver Mangaram drops him at the railway station in the morning and picks him up in the evening. Every evening Ram singh reaches the station at 5 o'clock. Mangaram also reaches at the same time. One day Ram singh started early from his office and came to the station at 4 o'clock. Not wanting to wait for the car he starts walking home. Mangaram starts at normal time, picks him up on the way and takes him back house, half an hour early. How much time did Ram singh walked?

Sam and Mala have a conversation. Sam says I am certainly not over 40. Mala says I am 38 and you are atleast 5 years older than me. Now Sam says you are atleast 39. All the statements by the two are false. How old are they realy?

There is a 4 inch cube painted on all sides. This is cut into number of 1 inch cubes. What is the number of cubes which have no painted sides?

Three are three boxes. In first box, two white balls. In second box, 2 black balls. In third box, 1 white & 1 black ball. The lables on the boxes are not correct. Then you have to open one box and to find the colour of the balls in all boxes.

What is the maximum number of slices can you obtain by cutting a cake with only 4 cuts?

how to change category listing page in wordpress?

Given two arrays where the two arrays are sorted. Find the median of when two arrays are combined

I'm creating a widget application and i got this error?Got IOException from Virtual Machine occurred while retrieving value What could be the reason?

How do you merge two linked lists which are sorted?

What is a split list?

What is a splay tree?

Given a set of numbers find two numbers such that the difference between those is minimum?

Thursday, February 10, 2011

Given a set of numbers with positive and negative numbers. How to get elements printed with all positive elements on one side and negative numbers to other end of array.

Given an array of integers divide the array into two sets such that the difference between the two sets is minimum?

Given an array of unsorted integers and an integer x. Check whether any two elements add upto x.

Given a binary tree where all the nodes in the tree have 1's and 0's? Find the length to the deepest path with all 1's ?

How to check whether two trees are equal?

Given a file how would you print all the unique lines in the file.

What is a b tree? what are advatages and disadvantages of b-tree?

Given there are 100 lights all are off. In the first round toggle all the lights. In the second round toggle all 2nd light's.In the third round toggle all 3rd light's.In the 100th round what all lights are on and lights are off?

There are 7 coins and one of the coin is heavier than others. Given a weighing machine then what is minimum number of weigh's u do find heavier coin

Monday, February 7, 2011

[Algorithm]



A man covered 28 steps in 30 seconds but he decided to move fast and covered 34 steps in 18 seconds. How many steps are there on the escalator when stationary?

[Algorithm]



1/3 rd of the contents of a container evaporated on the 1st day. 3/4 th of the remaining contents of the container evaporated the second day. What part of the contents of the container are left at the end of the second day?

[Algorithm]



There are two women, Kavitha and Shamili and two males Shyam and Aravind, who are musicians.
Out of these four one is a Pianist, one Flutist, Violinist and Drummer.
i) Across Aravind beats Pianist.
ii) Across Shyam is not a Flutist.
iii) Kavitha's left is a Pianist.
iv) Shamili's left is not a Drummer.
v> Flutist and Drummer are married.

[Algorithm]



There are 5 persons A, B, C, D, E and each is wearing a block or white cap on his head. A person can see the caps of the remaining 4 but can't see his own cap. A person wearing white says true and who wears black says false.
i) A says I see 3 whites and 1 black.
ii) B says I see 4 blacks.
iii) E says I see 4 whites.
iv) C says I see 3 blacks and 1 white.
Now Find the caps weared by A, B, C, D and E.

[Algorithm]



There are 3 nurses and they work altogether only once in a week. No nurse is called to work for 3 consecutive days.
Nurse 1 is off on tueseday, thursday and sunday. Nurse 2 is off on saturday. Nurse 3 is off on thursday, sunday.
No two nurses are off more than once a week. Find the day on which all the 3 nurses were on work.

[Algorithm]



A person went to a shop and asked for change for 1.15 paise, but he said that he could not only give change for one rupee but also for 50p, 25p, 10p and 5p. What were the coins he had?


Ans: 1-->50p 4--->10p 1--->25p.

[Algorithm]



There are six cards, in which, it has two king cards. All cards are turned down and two cards are opened.
a) What is the possibility to get at least one king?
b) What is the possibility to get two kings?

[Algorithm]



A, B, C, D, E are having numerical values. There are some conditions given:-
a) A=C <===> B!=E
b) Difference between A and C as same as difference between C and B as same as difference between A and D.
c) C < A and C > D,
Then Find A, B, C, D, E.

[Algorithm]



BE * BE = ACB.
A, B, C, E are non zero numbers. Find B, E.
Ans: B=1 E=9.

[Algorithm]



There are 3 societies A, B amp; C having some tractors each. A Gives B and C as many tractors as they already have. After some days B gives A and C as many tractors as they have. After some days C gives A and B as many tractors as they have. Finally each has 24 tractors. What is the original No.of tractors each had in the beginning?


Ans: A - 39. B - 21. C - 12.

[Algorithm]



Only boys aged > 16 wear coats. Boys aged > 15 go to watch football. Some more statements are given. What can be said about those who are watching football?

[Algorithm]



A clock showing 6 o'clock takes 30 secs to strike 6 times. How
long will it take to strike 12 at midnight?

Ans: 66 seconds.

[Algorithm]



A ship is away from the shore by 180 miles. A plane is travelling at 10 times speed of the ship. How long from the shore will they meet?

[Algorithm]



A, B, C, D, E related. Four of them made these statements each:-
i) C is my son-in-law's brother.
ii) B is my father's brother.
iii) E is my mother-in-law.
iv) A is my brother's wife.
Who made these statements?

[Algorithm]



Following services are operated by Asian airlines between the two are located in different countries with different time zones. As it is normally done, the time shown is the local time - viz IST & TST.
Regular Flight Supersonic Flight
Arrive Alexandria 17:10 TST 15:40 TST
Depart Alexandria 20:50 TST 22:50 TST
Arrived Rampur 23:40 IST
Is the arrival time of supersonic flight into Rampur from Alexandria same as the Arrival time of the
Regular flight, assuming each Service - Regular and Supersonic maintains its own constant speed of flight.

[Algorithm]



A long Division Problem:-
xx)xxxxxxxxx(xxxxxxx
xx
------
xxx
xx
------
xxx
xx
-------
xx
xx
-------
xxx
xxx
-------
-------
In the complete solution, there are four 5's. Find the missing digits.

[Algorithm]


Both the Guptas and Sinhas have two young sons, whose ages are under Eleven. The names of the boys, whose ages rounded off to the nearest year are all different, are Rajesh, Praveen, Lalith and Prathap.
Taking the ages of the boys only to the nearest year, the following statements are true:-
Rajesh is three years younger than his brother is.
Praveen is the oldest.
Prathap is 5 years older than the younger Sinha's boy.
Lalith is half as old as one of the Guptha's boys.The total ages of the boys in each family differ by the same amount today as they did five years ago.

[Algorithm]



In certain community, there are thousand married couples. Two thirds of the husbands who are taller than their wives are also heavier and three quarters of the husbands who are heavier than their wives are also taller. If there are 120 wives who are taller and heavier than their husbands, how many husbands are taller and heavier than their wives?

[Algorithm]


East zone scored four goals in round two match.
Table - A (Matches Played)
Round 1
North zone vs South zone
West zone vs east zone.
Round 2
South zone vs West zone
East zone vs North zone
Round 3
South zone vs East zone
West zone vs North zone.
Table - B (Results)
Played Won Draw Lost Golas For Goals Against Points
East Zone 3 - - - ? 3 4
North Zone 3 - - - ? ? 4
West Zone 3 - - - 4 3 3
South Zone 3 - - - 2 5 1

[Algorithm]


In a four team foot-ball tournament, all the teams played each Other in three rounds of matches as shown in the Table - A. Some of The results of the tournament are shown in the Table - B. Using the Clues given below, please fill in the blank columns in the result Table - B (Goals for & Goals Against?).
Note : Two points for win, one point for draw & zero points for defeat are awarded.
Clues :
1. East zone won the tournament despite scoring one less goal than the runners-up.
2. North zone scored an odd number of goals in their first round Game.
3. South zone, who failed to score in their final match, were beaten by a two-goal margin in the first round.
4. East zone lost their match aginst west zone.
5. All four teams scored goals in the second round matches.
6. West zone scored the same number of goals against east zone as North zone scored aginst them.

[Algorithm]



In a certain department store the position of Buyer, Cashier, Clerk, Floorwalkar & Manager are held, though not necessarily respectively, by Evans, Ames, Conroy, Davis amp; Buyer. The cashier & the
manager were roommates in college. The Buyer is bachelor, Evans & Miss Ames have only business contacts with each other. Mrs. Conroy was greatly dosappointed when her husband told her that the manager had refuged to give him a raise. Davis is going to be the best man when the clerk & the cashier are married. What position does each person held?

[Algorithm]



There are 3 piles each contains 10, 15, & 20 stones. There are A, B, C, D, F, G and H persons. Oneman can catch upto four stones from any pile. The last man who takes will win. If first A starts next B and
so on, who will win?


Ans: May be F.

[Algorithm]



There are 2 diamonds, 1 spade and 1 club and 1 ace and also 1 king, 1 jack and 1 ace are arranged in a
straight line.
1. The king is at third place.
2. The left of jack is a heart and its right is king.
3. No two red colours are in consecutive.
4. The queens are separated by two cards.
Write the order of which suits (hearts ,clubs)and names (jacks queens etc.) are aranged?

[Algorithm]



There are 4 boys - Anand, Anandya, Madan and Murali with nic-names perich, zomie, drummy and
madeena not in the same order. Some conditions.
Ans: Anand : Perich
Anandya : Drummy
Madan : Zombie
Murali : Madeena

[Algorithm]



The no. of children, adults. The no. of adults the no. of boys. The no. of boys no. of girls. The no. of girls no. of family. Conditions:-
1. No family is without a child.
2. Every girl has at least one brother and sister.

Ans: c > a > b > g > f; 9 6 5 4 3.

[Algorithm]



The no. of children, adults. The no. of adults the no. of boys. The no. of boys no. of girls. The no. of
girls no. of family. Conditions:-
1. No family is without a child.
2. Every girl has at least one brother and sister.

Ans: c > a > b > g > f; 9 6 5 4 3.

[Algorithm]



Two men are going along a track of rail in the opposite direction. One goods train crossed the first person in 20 sec. After 10 min the train crossed the other person who is comming in opposite direction in 18 sec. After the train has passed, when the two persons will meet?
Ans: Approx. 72 min, check it once.

[Algorithm]



In the 4 digits 1,2,3,4, how many 4 digited numbers are possible which are divisible by 4? Repeatations are allowed.

Ans: 64.

[Algorithm]



There are 4 married couples, out of which, 3 poeple in a group is needed. But there should not be his or her spouse in the group. How many groups are possible?
Ans: 32.

[Algorithm]



There are 2 scales of temp A & B. It was given A varies from 14 to 133 and B varies from 36 to 87.
Find the temperature, when temperature of A is equal to temp of B.


Ans: 52.5.
Let t=mx+c, c=-70 => m=51/119
a=a.51/119 -70 => a=52.5.

[Algorithm]



Answer the questions from facts:-
The members of certain tribe are divided into 3 casts abhor, dravid amp; magar.1. An abhor woman can't marry dravid man.
2. A magar woman can't marry a dravid man.
3. A son takes the caste of his father and a daughter takes caste of her mother.
5. All marriages except those mentioned, are not permitted.
6. There are no children born out of a wedlock.

[Algorithm]



A software engineer just returned from US, has eaten too much fat & put a lot of weight. Every sunday he starts walking 4 km/hr on level ground, then up at 3 km\hr, then back down hill at 6km\hr, then again on level ground at 4km\hr till he reaches his destination. If he returned home at 9 p.m., what
distance did he covered?


Ans: 24 km.

[Algorithm]



When the actual time pass 1 hr, wall clock is 10 min behind it. When 1 hr is shown by wall clock, table clock shows 10 min ahead of 1 hr. When table clock shows 1 hr, the alarm clock goes 5 min behind it. When alarm clock goes 1 hr, wrist watch is 5 min ahead of it. Assuming that all clocks are correct with actual time at 12 noon, what will be time shown by wrist watch after 6 hr?


Ans: 5:47:32.5 (n X 60 )50/60 X 70/60 X 55/60 X 65/60.

[Algorithm]



A frog jumps 3 ft comes back 2ft in a day. In how many day it will come out of 30ft deep well?
Ans: 28 day.
195. A-B=C
D/E=F
G+H=I
C.F=I
Ans: A=9, B=5, C=4, F=2.

[Algorithm]


a + b + c +d = d + e + f + g = g + h + i =17.
If a = 4, what are the values of d and g. Each letter taken only one of the digit from 1 to 9.


Ans: a = 4 ,b = 2, c =6, d = 5, e = 3, f = 8, g = 1, h = 7, i = 9.

[Algorithm]



A bag contains certain number of files. Each file is numbered with one digit of 0 to 9. Suppose the person want to get the number between 1 to 2000 (or 7000 check ). How many minimum number of files should be present in the bag.

[Algorithm]


There is a 18 strong building and 4 people live in it. They are dentist, lawyer, accountant, architect. Dentist floor is 5 times the lawyer's floor. Account is below dentist. If archetect moves two floors up he
will be midway between dentist and account. If architect moves to midway of the building (9th floor) then he will be middle of dentist & lawyer. Ground floor can be ignored i.e. floor 0.


Ans: Dentist 15. Accountant 13. Archetect 12. Lawyer 3.

[Algorithm]



A software engineer starts from home at 3 pm for evening walk. He walks at a speed of 4 kmph on level ground and then at a speed of 3 kmph on the uphill and then down the hill at a speed of 6 kmph to the level ground and then at a speed of 4 kmph to the home at 9 pm. What is the distance on one way?

[Algorithm]



4 ladis, Mrs Margarat, Mrs Price, Mrs Winter & Mrs Ellen went for marketing. Each went for 2 shops only. Their surnames are lorret, torrey, doris and marshall. One went to a hardwares shop. Two went to bank. Two went to buchers. All but dorris went to grocery etc. Who went where?

[Algorithm]



In a train there is one brakeman, conductor, engineer & fireman. Their names are Art, John, Tom &
Pete given in this order or in reverse order. You have to tell the occupation of the four, w.r.t. these
conditions:-
1. Brakeman has no relatives.2. John is older than art.
3. Engineer & fireman are brothers.
4. John is pete's nephew.
5. Fireman is not conductor's uncle.
6. Conductor is not engineer's uncle.
Ans: Pete & Tom are brothers. Tom--Father and John is his son.
Art--Brakeman.
John--Conductor.
Tom--Engineer.
Pete--Fireman.

[Algorithm]


A tourist wants to go from A to B. There are four ways to do this:-
1. To take a wagon. The wagon stops for half an hour at a station in between a & b and then goes to b.
2. To walk to B. If he leavs A at the same time the wagon leaves, he will be between by the wagon by 1
mile to reach B.
3. To walk from A at the same time the wagon leaves from A. He will arrive at the mid station at the time
when the wagon is prepared to leave. He can take the wagon from there. This will take shortest time.
4. To go on upto the mid station & to walk from there. He will reach at B 15 minutes before the wagon.
What is the distance between A & B?.

[Algorithm]



I have been hearing a girl singing a song for last two score. Song: If seven times five and three times seven is added to my age it would be as far above six nines and four as the difference between twice of my age and a score. Given-A score is 20 yrs.

[Algorithm]


A & B two places. C & D are two people. C started from A and D started from B. When they meet each other in the way C traveled 18 m more than D. Then C takes 13 and half a minute and D takes 24 minutes to reach the other end. What was the distance between A & B.
Ans: 126.

[Algorithm]


There were 50 players playing a game among themselves. Each player is out of the game when lose 3 matches. What is the number of matches should be played in order to get the winner.

[Algorithm]


The profit made by a company in one year is enough to give 6% return on all shares. But as the preffered shares get on return of 7.5%, so the ordinary shares got on return of 5%. If the value of preferd shares is Rs 4,000000, then what is the value of ordinary shares?
Ans: Rs. 6,000000.

There are 6561 number of balls in a bag. Out of which one is heavy ball. In how many minimum number of weighing you can find the heavy ball.


ans:8

[Algorithm]


Olympic race : 4 contestants : Alan,charlie, Darren ,Brain. There are two races and average is taken to decide the winner. One person comes at the same position in both the race. Charlie always come before Darren. Brian comes first once. Alan comes third atleast once. Find the positions. Alan never comes last. Charlie & Darren comes 2nd atleast once.

[Algorithm]


An army 50 miles long marches at a constant rate. A courier standing at the rear moves forward and delivers the message to the first person and then turns back and reaches the rear of the army as the army completes 50 miles. Find the distance travelled by the courier.

[Algorithm]


A train blows a siren one hour after starting from the station. After that it travels at 3/5th of its speed it reaches the next station 2 hours behind schedule. If it had a problem 50 miles farther from the previous case,it would have reached 40 minutes sooner. Find the distance between the two stations.

[Algorithm]


In a 10 digit number, if the 1st digit number is the number of ones,2nd digit
number is the number of twos, and ... so on. 10th digit is the number of zeroes, then find the number.

[Algorithm]


If 1/4 of the time from midnight plus 1/2 of the time from now to midnight is the present time, then What is the present time?

[Algorithm]



Each alphabet stands for one digit in the following multiplication.
T H I S
x I S
---------
X F X X
X X U X
------------
X X N X X
------------
What is the maximum value T can take?

[Algorithm]


Albert and Fernandes have two leg swimming race. Both start from opposite ends of the pool. On the first leg, the boys pass each other at 18 m from the deep end of the pool. During the second leg they pass
at 10 m from the shallow end of the pool. Both go at constant speed but one of them is faster. Each boy rests for 4 seconds at the end of the first leg. What is the length of the pool?

[Algorithm]

A family X went for a vacation. Unfortunately it rained for 13 days when they were there. But whenever it rained in the mornings, they had clear afternoons and vice versa. In all they enjoyed 11 mornings and 12 afternoons. How many days did they stay there totally?
Ans: 18.

[Algorithm]


In a railway station, there are two trains going. One in the harbour line and one in the main line, each having a frequency of 10 minutes. The main line service starts at 5 o'clock and the harbour line starts at 5.02A.M. A man goes to the station every day to catch the first train that comes. What is the probability of the man catching the first train?
Ans: 0.8.

[Algorithm]

Ram Singh goes to his office in the city, every day from his suburban house. His driver Gangaram drops him at the railway station in the morning and picks him up in the evening. Every evening Ram Singh reaches the station at 5 O' Clock. Gangaram also reaches at the same time. One day Ram Singh started early from his office and came to the station at 4 O' Clock. Not wanting to wait for the car he starts walking home. Mangaram starts at normal time, picks him up on the way and takes him back house, half
an hour early. How much time did Ram Singh walk?

FA Register Report SQL Query

select fb.BOOK_TYPE_CODE

,fa.ASSET_NUMBER

,fat.DESCRIPTION ASSET_DESCRIPTION

,fa.SERIAL_NUMBER

,fa.ATTRIBUTE1 MAJOR_DESC_FLEX

,fa.ATTRIBUTE2 MINOR_DESC_FLEX

,fa.OWNED_LEASED

--,pv.VENDOR_NAME

--,aia.INVOICE_NUM AP_INVOICE_NUMBER

--,aia.INVOICE_DATE AP_INVOICE_DATE

--,aia.DOC_SEQUENCE_VALUE AP_VOUCHER_NUMBER

,fc.SEGMENT1 MAJOR_CATEGORY

,fc.SEGMENT2 MINOR_CATEGORY

,fc.SEGMENT3 TOWER

,NULL TYPE_OF_PURCHASE

,gcc.segment3 PROJECT_CODE

,ppa.name PROJECT_NAME

,fak.segment1 OWNER_OF_ASSET

,pap.FULL_NAME EMPLOYEE_NAME

,pap.EMPLOYEE_NUMBER

,gcc1.CONCATENATED_SEGMENTS ACCOUNT_CODE

,fl.CONCATENATED_SEGMENTS LOCATION

,gcc.CONCATENATED_SEGMENTS DEPRECIATION_FLEX

,fdh.UNITS_ASSIGNED

,fb.DATE_PLACED_IN_SERVICE

,(fb.LIFE_IN_MONTHS/12) LIFE_IN_YEARS

,fb.LIFE_IN_MONTHS

,gl.CURRENCY_CODE

,MPL_GL_RATE(gl.CURRENCY_CODE,'INR',fb.DATE_PLACED_IN_SERVICE) RATE

,fb.COST

,fds.DEPRN_AMOUNT DEPRN_AMOUNT

,fds.DEPRN_RESERVE ACC_DEPRN

,DECODE(fdp.FISCAL_YEAR,fbc.CURRENT_FISCAL_YEAR,fds.YTD_DEPRN,0) YTD_DEPRN

,(fb.COST - fds.DEPRN_RESERVE) NET_BOOK_VALUE

from apps.fa_additions_b fa

,apps.fa_categories fc

,apps.fa_locations_kfv fl

,apps.fa_books fb

--,apps.fa_mass_additions fma

--,apps.fa_asset_invoices fai

--,apps.po_vendors pv

,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.ap_invoices_all aia

,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

,mpl_old_to_new_entity mot

where fa.ASSET_CATEGORY_ID = fc.CATEGORY_ID

and fa.ASSET_ID = fat.ASSET_ID(+)

--and fa.ASSET_NUMBER = fma.ASSET_NUMBER(+)

and fdh.LOCATION_ID = fl.LOCATION_ID(+)

and fa.ASSET_ID = fb.ASSET_ID

--and fa.ASSET_ID = fai.ASSET_ID(+)

--and fai.PO_VENDOR_ID = pv.VENDOR_ID(+)

--and fai.INVOICE_ID = aia.INVOICE_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 hou.name = mot.DESCRIPTION

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

and fds.PERIOD_COUNTER = (select max(fds1.period_counter)

from apps.fa_deprn_summary fds1

where fds1.asset_id = fds.asset_id

and fds1.BOOK_TYPE_CODE = fds.BOOK_TYPE_CODE

)

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

copy and paste not working


1. Goto start->run->services.msc
2. start network dde dsdm service
3. start network dde service
4. start clipbook service
5. Reboot machine

Thursday, February 3, 2011

online linux shell

This below website provides Unix-like virtual online bash shell command line interface where you can try out bash commands easily online in a web browser without the fear of installing Linux.

http://cb.vu/

Can you define detailed or summary actions in alert?

Yes, Detail or Summary Actions you can choose to have Oracle Alert perform actions based on a single exception or a combination of exceptions found in your database.

How alert is different from database triggers?

a) Code can be modified and viewed in a screen
b) Periodic alert is not possible through Database trigger
c) Oracle Alert will also transfer your entire alert definition across databases. You can instantly leverage the work done in one area to all your systems.
d) Customizable Alert Frequency with Oracle Alert, you can choose the frequency of each periodic alert. You may want to check some alerts every day, some only once a month, still others only when you explicitly request them.

What do you specify when creating a Periodic Alert?

a. A SQL Select statement that retrieves specific database information
b. The frequency that you want the periodic alert to run the SQL statement
c. Actions that you want Oracle Alert to perform once it runs the SQL statement.

What actions can you perform in an alert?

An action can entail sending someone an electronic mail message, running a concurrent program, running an operating script, or running a SQL statement script. You include all the actions you want Oracle Alert to perform, in an action set.

What database events can cause what actions?

An insert and/or an update to a specific database table

What are the different types of alerts, Define it?

Event alert: An event alert immediately notifies you of activity in your database as it occurs.
Periodic alert: A periodic alert, on the other hand, checks the database for information according to a schedule you define.

How to enable scroll for textview android

<ScrollView android:id=\"@+id/ScrollView01\"
android:layout_height=\"250px\" android:layout_width=\"fill_parent\">
<TextView
android:id=\"@+id/txtID\"
android:layout_width=\"fill_parent\"
android:layout_height=\"fill_parent\"
android:text=\" \" />

Wednesday, February 2, 2011

how to add files in android application

Open eclipse in DDMS perspective then there is a symbol in the right side top PUSH FILE. then put ur files in data->data->ur package ->files

Getting exception while running android application android.os.networkonMainThreadException

Tuesday, February 1, 2011

What is a singleton pattern? How do you code it in Java?

A singleton is a class that can be instantiated only one time in a JVM per class loader. Repeated calls always
return the same instance. Ensures that a class has only one instance, and provide a global point of access. It
can be an issue if singleton class gets loaded by multiple class loaders or JVMs.

public class OnlyOne {

private static OnlyOne one = new OnlyOne();

// private constructor. This class cannot be instantiated from outside and
// prevents subclassing.
private OnlyOne(){}

public static OnlyOne getInstance() {
return one;
}
}