היום קיבלתי טלפון מחברה אחרי הדברים הרגילים מה עשית ומה אתה מחפש אומרים לי מבחן שרק אחרי שתעשה בכלל נדבר איתך ונסביר לך מה אנחנו עושים וכמה בכלל מוכנים לשלם ואיזה תפקידים פנויים אז אני מפרסם פה את המבחן בקרוב אעלה פתרון על מנת לשבור את השוק שחברות לא יעשו כאלו דברים! Hi, Please choose two out of the following three assignments: 1. We have an exchange rate table that hold historical exchange rates for common currencies. Symbol USD_Rate Updated NIS 3.7 01/09/09 EUR 0.87 01/09/09 NIS 3.76 10/09/09 NIS 4.2 30/08/08 EUR 0.67 01/08/08 NIS 4.1 01/08/08 GBP 1.9 01/08/08 Etc. Assume N currencies are available. Provide SQL statement that can be used in MS-SQL 2005 to show us a list of the daily currency rates. Select updated, symbol , Date NIS EUR GBP 01/08/08 4.1 0.67 1.9 30/08/08 4.2 NULL NULL 01/09/09 3.7 0.87 NULL 10/09/09 3.76 NULL NULL Etc. 2. Provide a small tool (C++ source code and exe) to display the URL and window title of the current web site presented in IE. assume: a. antivirus is disabled and you have administrative rights b. you can choose one OS and browser version to simplify the solution. 3. Our client would like to create a secret algorithm which will be deployed on a server. describe a solution that will protect the logic as much as possible. Please assume: • We need to provide UI for creating the algorithm • We need to provide a system that uses this logic at runtime. • Anyone can try and still the logic (hackers, developers, operation teams etc.) The description should be short and summarize all aspects of the solution including the process of generating the logic and deploying it in the production environment. All solutions should be in English and include proper coding and documentation standards.