Всем привет.
На собеседование дали тест, который я конечно же завалил, но к сожалению подробно ничего не объяснили, поэтому все же интересно узнать правильные решения. Выкладываю задачки - может кому интересно будет порешать :)
Question # 1
Julia states: “When I went fishing the other day, every fish that I caught was a tuna, and every tuna I saw I caught.” Of the following statements listed below, which one can be concluded from the observations of Julia?
A. Tuna was the only fish that Julia saw while she was fishing.
B. While Julia was fishing, no other fish were caught by her.
C. In the area that Julia fished, there were no other fish.
D. All of the fish that Julia saw she caught.
E. Julia did not see any other fish while she was fishing
Question # 2
Suppose you and I have the same amount of money. How much must I give you so that you have ten dollars more than I?
Question # 3
A dealer bought an article for $7, sold it for $8, bought it back for $9, and sold it for $10. How much profit did he make?
Question # 4
Imagine that you have a client that has a UI for reviewing his many thousands of orders, 50 per page. The UI also allows the client to limit the orders based on the current status of the order. The orders are in a database table called [ORDERS] with a numeric, incrementing primary key named [ORDER_ID]. The table also has a column [ORDER_STATUS] with three possible values:
“PROCESSING”
“COMPLETED”
“CANCELLED”
Please write out a SQL statement that will output the third page of “CANCELLED” orders (the 101-150th cancelled orders). Bear in mind that while the [ORDER_ID] values are probably sequential in the database, the [ORDER_ID] values for the “CANCELLED” orders are not.
Please use ONLY SQL and avoid vendor specific SQL commands (such as MS SQL’s RowID() or MySQL’s limit).
Question # 5
500 men are arranged in an array of 10 rows and 50 columns according to their heights. The tallest man in each row is asked to come out and the shortest among them is A. After resuming their original positions, the shortest among each column is asked to come out and the tallest among them is B. Who is taller, A or B ?
Question # 6
You have 26 constants, labeled A through Z. Let A equal 1. The other constants have values equal to the letter's position in the alphabet, raised to the power of the previous constant. That means that
B (the second letter) = 2^A = 2^1 = 2
C (the third letter) = 3^B = 3^2 = 9
The value for this expression: (X-A) * (X-B) * (X-C) * ... * (X-Y) * (X-Z) will
A. Fit into an Int32
B. Fit into an Int64
C. Not fit into either
Question # 7
On the popular children's television show, the "Faboo Foursome" are four cartoon animals. Since they are cartoons, when they are on tour, each is represented by a puppet that is operated by a chief and an assistant puppeteer.
The types of animals are: Camel, Koala, Kangaroo, and Cobra
The animal's names are: Audrey, Alan, Andrew, Anthony
The Chief Puppeteers are: Ben, Brenda, Brian and Britney
The Assistant Puppeteers are: Dave, Diane, Debby and Drew
1. Andrew isn’t the puppet who is operated by Britney and her assistant Debby.
2. Alan’s chief puppeteer (who is not Brenda) is assisted by Drew.
3. Ben is in charge of the camel, but Brenda doesn’t have anything to do with the kangaroo.
4. Dave is the assistant puppeteer for the cobra.
5. Anthony, whose chief is Brian, isn’t the koala (whose name is not Andrew).
What is the name of the camel? How do you know?
A. Audrey
B. Alan
C. Andrew
D. Anthony
E. Arthur
Question # 8
You have just been assigned to a new team and your project manager sends you an email: “We need you to design a database schema and build a UI that will handle the task management day to day of our development team. We currently manage our tasks in excel and by email and it’s no longer working. Please send me the schema for review when it’s ready.” What are some of your first steps?
1. If you are going to look at things you know, please list them by name.
2. If you are going to come back with questions, please list them.
мои ответы
1. B
2. 5$
3. 2$
4. -
5. A or same
6. C
7. B
8. -
