JQzkzFVN

1# Web
2
3## What is the difference between POST, PUT, DELETE, PATCH and GET? What would you use each for? Can you give examples?
4
5
6
7
8# SQL
9
10CREATE TABLE IF NOT EXISTS people ( <br/>
11  person_id INT PRIMARY KEY, <br/>
12  first_name TEXT, <br/>
13  last_name TEXT <br/>
14) <br/>
15
16CREATE TABLE IF NOT EXISTS schedule_items ( <br/>
17  schedule_item_id INT PRIMARY KEY, <br/>
18  title TEXT <br/>
19) <br/>
20
21CREATE TABLE IF NOT EXISTS personal_schedules ( <br/>
22  person_id INT,  <br/>
23  schedule_item_id INT, <br/>
24  FOREIGN KEY(person_id) REFERENCES people(person_id), <br/>
25  FOREIGN KEY(schedule_item_id) REFERENCES schedule_items(schedule_item_id), <br/>
26  PRIMARY KEY (person_id, schedule_item_id) <br/>
27) <br/>
28
29## Can you write an SQL query to retrieve all the records from the table above ordered by first name and then last name?
30
31
32
33
34
35## Can you write an SQL query to retrieve the first 10 people where the first name starts with 'Al'?
36
37
38
39
40
41## Can you write an SQL query to retrieve all the people that have the schedule item titled 'An intro to modular design' in their personal schedule?
42
43
44
45
46
47## What's the purpose of foreign keys?
48
49
50
51
52
53## What's the purpose of primary keys?
54
55
56
57
58
59# Android
60
61## Can you name a few elements you might find in the AndroidManifest.xml file?
62
63
64
65
66
67## What is the difference between an Activity and a Fragment?
68
69
70
71
72
73## What is the purpose of an Intent?
74
75
76
77
78
79## What is difference between Serializable and Parcelable?
80
81
82
83
84
85# Algorithms
86
87In the language of your choice.
88
89
90
91
92
93## Can you write an algorithm, as efficiently as possible, to find if a word is a palindrome (same backward and forward (for example, 'bob', 'laval', 'civic')) ?
94
95
96
97
98
99## Write a program that prints the numbers from 1 to 100, but for multiples of three print “Fizz” instead of the number and for multiples of five print “Buzz”. For numbers which are multiples of both three and five, print “FizzBuzz”.
100
101
102
103
104
105# Modeling
106
107## We want to add a shopping cart to our website. How would you proceed? Can you model a first draft of this feature? Use the UML diagrams you think are relevant.
108
109
110
111
112
113# Git
114
115## What does 'git push origin dev' do?
116
117
118
119
120
121## What does 'git add .' do?
122
123
124
125
126
127## Can you explain how Git is decentralized?
128
129
130
131
132
133# Object-oriented
134
135## What is the purpose of inheritance?
136
137
138
139
140
141## Can you give an example of polymorphism?
142
143
144
145
146
147## What is function overloading?
148
149
150
151
152
153## What is the difference between an abstract class and an interface?
154
155
156
157
158
159## What does the program below output?
160
161
162
163
164
165```java
166public class A {
167
168  public void talk() {
169    System.out.println("I am A");
170  }
171
172}
173
174public class B extends A {
175
176  @Override
177  public void talk() {
178    System.out.println("I am B");
179  }
180
181}
182
183public class C extends A {
184
185}
186
187public static void main(String[] args) {
188  C c = new C();
189  c.talk(); // What is printed?
190
191  A a = new B();
192  a.talk(); // What is printed?
193}
194```
195
196# General
197
198## What is 'clean code' to you? Can you give examples?
199
200
201
202
203
204## What are your favorite design patterns and why? Have they helped you in the past? If so, in which situations?
205
206
207
208
209
210## There are eight balls. Seven of them weigh the same but one of them has a different weight (heavier). How do you find the odd ball with two weighs?