Amazon Interview Report
- 0of 0 votes
AnswersWrite a basic web application, following the Model-View-Controller/Modular design pattern. The following URLs should be functional:
- Silvimass May 27, 2009
• http://www.server.com/index.php?page=showTime - Displays the current system time.
• http://www.server.com/index.php?page=showDate - Displays the current system date.
• http://www.server.com/index.php?page=showVersion - Displays the current PHP / Java version.
Each page should be represented by an individual class. Any of the following languages can be used: PHP| Report Duplicate | Flag | PURGE
Amazon Web Developer PHP Object Oriented Design - 0of 0 votes
AnswersWrite a class to extract basic data from an Amazon Product Detail web page when passed a URL The following information must be extracted into an array: ISBN10, ISBN13, Weight, Dimensions, and Current Price. This code must be written in PHP. An example URL is:
- Silvimass May 27, 2009
http://www.amazon.com/Biology-MasteringBiology-8th-Neil-Campbell/dp/0321543254/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1233281929&sr=8-1
My Answer: it's really easy. Check for the values into actual page and then just truncate string accordingly| Report Duplicate | Flag | PURGE
Amazon Web Developer PHP - 0of 0 votes
AnswersGiven the following MySQL table schema, write a query to return the employee with the 7th highest salary.
CREATE TABLE `employee_salary` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`salary` decimal(10,2) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_salary` (`salary`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
My Answer:SELECT name, salary FROM ( SELECT name, salary FROM Employees ORDER BY salary, desc ) WHERE ROWNUM >=3 and ROWNUM <=7
something like that....
- Silvimass May 27, 2009
here is the discription
http://coldfusion.sys-con.com/node/43794| Report Duplicate | Flag | PURGE
Amazon Web Developer Database - 0of 0 votes
AnswersUtilizing two common Object-Oriented design patterns, write a set of classes, which can be used to log a given message. The message should be logged to either a MySQL database or a file, depending on a configuration setting. There should be only one connection opened to the database (or the log file should only be opened once) throughout the use of the application. ). Any of the following languages can be used: PHP
- Silvimass May 27, 2009
My Answer:
create a buffer to generate a log and then copy entire buffer to your designated file
but downsize of this method is .... you will loose all data if system fail to commite or fail to log...//power shutdown| Report Duplicate | Flag | PURGE
Amazon Web Developer PHP Object Oriented Design