实施工程师面试题及答案（Implementation of Engineer InterviewQuestions and answers）1 and two computers are in the same network environment, andA computers can't access the shared files ofB computers. What are the possible causes of this phenomenon? How to deal with it?Answer: you must first determine whether in a working group, only in a working group to share files, and then look at a look there is no firewall and the like, and then determine the file is not already shared2, when the computer starts the fan to turn, but the screen does not have any display, this phenomenon possibly is what aspect causes? How to deal with it?Answer:1. check to see if there is an alarm If not, then look at the second. If it could be memory or graphics problems, it's recommended to take it down and clean up and see if it's ok! Wipe the fingers with an eraser2. motherboard problems, it is recommended to go down the motherboard that battery, discharge motherboard! The premise is to turn all the power off!3. power problems, it is recommended to try another power!3, in doing SQL automatic backup, what services should be opened first?Answer:SQLServer Agent this service4, in the same network environment, A computer,IP:192.168.1.100, computer, IP:B, 192.168.0.100, router IP:192.168.1.1. Are there any ways you can make the B computer available?Access to the A computer on the public network?Answer: if your public network needs dial-up, then it needs two routers to convert. First of all, you need to make a route to the public network. Then use another router for two network segments for routing conversionA static routing switch is set up in the router, one for 192.168.1.* and one for 192.168.0*, so that the two computers can exchange visits. Connect this router and a computer to the original public network respectivelyRouting enables two computers with different network segments to access the internet. If your public network does not need to dial, you can change the router of the original public network to the switch, OK, and the other connections are the same as above5, what are your familiar remote methods? How should the various methods be configured?The simplest answer:1 on QQ has the open dialog box with an application icon and click "remote assistance""2, remote host installed a client (a small software), install their own host (software), you can remote control (download on the network)3, there are some large units of professional communications systems, instant access to OA and some other remote assistance function (this kind of money to buy)6, if there is a computer less understanding of customers, you should take what method to teach him to use the company's software products?Answer: I think it's an interview question. The person who asks the question wants to see what you are capable of. This can be answered flexibly, and if the software products are difficult to understand, you can teach some simple ones first.Tell him what more he needs to know to master the software. If the software product is relatively simple, you can directly teach him step by step how to operate, has been skilled operation on the line7, what do you think when you feel that your job is not directly proportional to your income?Answer: if the pay is not proportional to the income, to a certain extent, to the point where you can't stand it, then try to get a raise or job hopping,8, you are in process of implementation, the company produced a software system of a lack of a function, but also made it clear that the company will not make any changes or add any function for the system, but also insist on customerThis function is required! For the implementation of personnel, how should be reasonable and proper handling of this problem?Answer: says it's clear that you're implementing a project, not custom software. For example, shoes sold in supermarkets and shoes made by shoemaker are all shoes, but the former is a commodity, and many of the same items can be bought by youFew comfortable shoes to wear; the latter is custom made, not only a commodity, but also a kind of labor that has been completely tailored to customer needs, and every detail is perfect. Software also has no customer requirementsSince the company that function can not be achieved, that is cost function development time, resources and conflicts of interest, you can increase the customer to pay him more fees, even more expensive than buying software. It mainly depends on your eloquence. I wish you a good performance9, SQL database table called guest, database table called accounts Accounts, S0001, S0001, S0002, S0003, S0004, S0005, S0005, consumption, Details, room charge, drinks, room charge, drinks, room charge, S0001房费酒水房费时间 Date 01 / 01 / 2010 - 2010 - 2010 - 01 02 01 08 2010 - 01 - 29 - 31, 2010 - 2010 - 01 02 01 01 02 - 2010 - 2010-02-02 金额 Money 280 300 50 120180 230 100 128 班次 Class 001 001 001 001 002 0031) 查询出房费都大于 200 的帐号.) 查询出房费房费都大于帐号Guest form. Select accounts where Money > '200'2) 查询出 1 月份每个帐号酒水和房费的总金额. 月份每个帐号酒水和房费的总金额. 每个帐号酒水和房费的总金额) SELECT SUM (detail), details formGuest where details 房费 = = '' Or 'Group by' details 酒水Detail3) 删除 1 月份班次为空的记录. 月份班次为空的记录.) delete form Guest where date = > '01 / 01 / 2010' and '2010 date = < - 01 - 31' and class isNull4) 将不是房费的记帐代码的班次都更改为 '001') 将不是房费的记帐代码的班次都更改为 Update Guest set. '' class = '001' details'.房费 '5) 查询出消费都大于 100 的帐号. 的帐号.) 查询出消费都SELECT DISTINCT accounts form Guest accounts not in (SELECT DISTINCT accounts formGuest Money < 100)。
