一亩三分地论坛

 找回密码
 获取更多干货,去instant注册!

扫码关注一亩三分地公众号
查看: 352|回复: 0
收起左侧

CircleUp OA

[复制链接] |试试Instant~ |关注本帖
ycsung 发表于 2015-1-26 07:59:16 | 显示全部楼层 |阅读模式

2015(1-3月) 码农类 硕士 全职@CircleUp - 网上海投 - 在线笔试 |Fail

注册一亩三分地论坛,查看更多干货!

您需要 登录 才可以下载或查看,没有帐号?获取更多干货,去instant注册!

x
CircleUp 小公司 可以練練手
https://angel.co/circleup
不熟悉front-end的Q3, 所以Fail

1. Palindromic Numbers

How many palindromic numbers [http://en.wikipedia.org/wiki/Palindromic_number] are there in the set of numbers representable by a 16 bit unsigned integer [0..65535] ?
. 鍥磋鎴戜滑@1point 3 acres
Send back both the number and the code you used to calculate it. You can use any programming language.


2. Cellular Automata

We will write a command-line console application that prints output that resembles a simple cellular automata.
鏉ユ簮涓浜.涓夊垎鍦拌鍧.
Each line of the program’s output represents a row of 64 boolean values. True should be printed as an asterisk ( * ) and False should be printed as a hyphen ( - ). So each line of output should be 64 characters of asterisks or hyphens, followed by a newline.  Use the following rules to determine the values in the rows:
- The initial row of booleans should be all False, except for one True roughly in the middle (in the 32nd position; so it should be 31 Falses, followed by one True, followed by 32 Falses).
Each subsequent row of booleans will depend on the one immediately before it. Each new row should be calculated using this rule:
- The value for a given position in the new row should be True if in the previous row, either the position immediately to the left or immediately to the right was True, but not both. Otherwise it is False.


Print out 32 lines worth of output total using these rules. Include the output as well as the code.


. visit 1point3acres.com for more.
3. Frontend / DOM Programming:

a. Create the following layout in HTML/CSS: (it’s a “C” for CircleUp with a green “glint” in the corner)
White boxes are 100px by 100px, green box is 24px by 24px. Don’t worry too much about exact margins / sizing, but it should resemble the image.

b. Write jQuery / javascript so that clicking the large white boxes turns them blue (ignore the little green box). After the last one has been clicked, the green box should turn red and the blue boxes should start “undoing” their blue coloring, in the reverse order that they were clicked, separated by 1 second.  Nothing should respond to clicks during this period. After they are all undone, the little red box should become green again and everything should be back to its initial state.

It should behave like in this video:
http://vimeo.com/103005825

Preference is for you to do this on jsfiddle.net and send a link (on jsfiddle, be careful that the URL you copy/paste has updated to reflect final updates)


4. SQL

Given two tables defined as follows, and these insert statements:

create table author (
id int,
first_name varchar(255),
last_name varchar(255),
primary key (id),
unique key name_uniq (first_name, last_name)
);
create table books (
id int,
author_id int,
title varchar(255),
primary key (id),
constraint author_id_fk foreign key (author_id) references author (id)
);

insert into author (id, first_name, last_name) values (1, 'Adam', 'Smith');
insert into author (id, first_name, last_name) values (2, 'Brian', 'Smith');
insert into author (id, first_name, last_name) values (3, 'Charles', 'Smith');
insert into author (id, first_name, last_name) values (4, 'Darcy', 'Smith');
insert into author (id, first_name, last_name) values (5, 'Adam', 'Jones');
insert into author (id, first_name, last_name) values (6, 'Jason', 'Jones');
insert into author (id, first_name, last_name) values (7, 'John', 'Jones');
insert into author (id, first_name, last_name) values (8, 'Brian', 'Doe');
insert into author (id, first_name, last_name) values (9, 'John', 'Doe');
insert into author (id, first_name, last_name) values (10, 'Jack', 'Dorsey');

insert into books (id, author_id, title) values (1, 1, 'ABCD');
insert into books (id, author_id, title) values (2, 1, 'ABCDE');
insert into books (id, author_id, title) values (3, 1, 'ABCDEF');
insert into books (id, author_id, title) values (4, 4, 'ABCD');
insert into books (id, author_id, title) values (5, 4, 'ABCDE');
insert into books (id, author_id, title) values (6, 5, 'ABCD');
insert into books (id, author_id, title) values (7, 6, 'ABCD');
insert into books (id, author_id, title) values (8, 7, 'ABCD');
insert into books (id, author_id, title) values (9, 8, 'ABCD');
insert into books (id, author_id, title) values (10, 9, 'ABCD');
insert into books (id, author_id, title) values (11, 10, 'ABCD');
insert into books (id, author_id, title) values (12, 5, 'ABCDE');
insert into books (id, author_id, title) values (13, 6, 'ABCDE');
insert into books (id, author_id, title) values (14, 5, 'ABCDEF');
insert into books (id, author_id, title) values (15, 6, 'ABCDEF');
insert into books (id, author_id, title) values (16, 7, 'ABCDE');
insert into books (id, author_id, title) values (17, 8, 'ABCDE');
insert into books (id, author_id, title) values (18, 9, 'ABCDE');
insert into books (id, author_id, title) values (19, 10, 'ABCDE');
insert into books (id, author_id, title) values (20, 10, 'ABCDEF');
insert into books (id, author_id, title) values (21, 9, 'ABCDEF');
insert into books (id, author_id, title) values (22, 8, 'ABCDEF');
insert into books (id, author_id, title) values (23, 7, 'ABCDEF');
insert into books (id, author_id, title) values (24, 3, 'ABCD');

Copy/paste the above into http://sqlfiddle.com/ , and then write a SQL query that will return:
  • author ID
  • author first name
  • author last name
  • count of written books
. 1point3acres.com/bbs
For all authors with last name ‘Smith’. The results should include authors that have not written any books (with count “0”).


Send back the SQL or a link to sqlfiddle.


提供1, 3, 4解答

CircleUp.zip

1.46 KB, 阅读权限: 1, 下载次数: 5, 下载积分: 大米 -1 升

评分

4

查看全部评分

本版积分规则

请点这里访问我们的新网站:一亩三分地Instant.

Instant搜索更强大,不扣积分,内容组织的更好更整洁!目前仍在beta版本,努力完善中!反馈请点这里

关闭

一亩三分地推荐上一条 /5 下一条

手机版|小黑屋|一亩三分地论坛声明 ( 沪ICP备11015994号 )

custom counter

GMT+8, 2016-12-3 18:23

Powered by Discuz! X3

© 2001-2013 Comsenz Inc. Design By HUXTeam

快速回复 返回顶部 返回列表