Evaluate these two SQL statements:What is true about them？（）

A. Export policies can evaluate only active routes

B. Export policies can evaluate all routes

C. Export policies can be applied to the forwarding table

D. Export policies can be applied directly to interfaces

A. Export polices can evaluate only active routes

B. Export polices can evaluate all routes

C. Export polices can be applied to the forwarding table

D. Export polices can be applied to interfaces

(ii) Following on from your answer to (i), evaluate the two purchase proposals, and advise Bill and Ben

which course of action will result in the highest amount of after tax cash being received by the

shareholders if the disposal takes place on 31 March 2006. (4 marks)

A. If Evaluate is checked then the client must pass policy to get the sign-in page.

B. If Evaluate is checked then the client can fail policy and still get the sign-in page.

C. If Require and Enforce is checked then the client must pass policy to get the sign-in page.

D. If Require and Enforce is checked then the client can fail policy and still get the sign-in page.

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

Section B – TWO questions ONLY to be attempted

Perkin manufactures electronic components for export worldwide, from factories in Ceeland, for use in smartphones and hand held gaming devices. These two markets are supplied with similar components by two divisions, Phones Division (P) and Gaming Division (G). Each division has its own selling, purchasing, IT and research and development functions, but separate IT systems. Some manufacturing facilities, however, are shared between the two divisions.

Perkin’s corporate objective is to maximise shareholder wealth through innovation and continuous technological improvement in its products. The manufacturers of smartphones and gaming devices, who use Perkin’s components, update their products frequently and constantly compete with each other to launch models which are technically superior.

Perkin has a well-established incremental budgeting process. Divisional managers forecast sales volumes and costs months in advance of the budget year. These divisional budgets are then scrutinised by the main board, and revised significantly by them in line with targets they have set for the business. The finalised budgets are often approved after the start of the accounting year. Under pressure to deliver consistent returns to institutional shareholders, the board does not tolerate failure by either division to achieve the planned net profit for the year once the budget is approved. Last year’s results were poor compared to the annual budget. Divisional managers, who are appraised on the financial performance of their own division, have complained about the length of time that the budgeting process takes and that the performance of their divisions could have been better but was constrained by the budgets which were set for them.

In P Division, managers had failed to anticipate the high popularity of a new smartphone model incorporating a large screen designed for playing games, and had not made the necessary technical modifications to the division’s own components. This was due to the high costs of doing so, which had not been budgeted for. Based on the original sales forecast, P Division had already committed to manufacturing large quantities of the existing version of the component and so had to heavily discount these in order to achieve the planned sales volumes.

A critical material in the manufacture of Perkin’s products is silver, which is a commodity which changes materially in price according to worldwide supply and demand. During the year supplies of silver were reduced significantly for a short period of time and G Division paid high prices to ensure continued supply. Managers of G Division were unaware that P Division held large inventories of silver which they had purchased when the price was much lower.

Initially, G Division accurately forecasted demand for its components based on the previous years’ sales volumes plus the historic annual growth rate of 5%. However, overall sales volumes were much lower than budgeted. This was due to a fire at the factory of their main customer, which was then closed for part of the year. Reacting to this news, managers at G Division took action to reduce costs, including closing one of the three R&D facilities in the division.

However, when the customer’s factory reopened, G Division was unwilling to recruit extra staff to cope with increased demand; nor would P Division re-allocate shared manufacturing facilities to them, in case demand increased for its own products later in the year. As a result, Perkin lost the prestigious preferred supplier status from their main customer who was unhappy with G Division’s failure to effectively respond to the additional demand. The customer had been forced to purchase a more expensive, though technically superior, component from an alternative manufacturer.

The institutional shareholders’ representative, recently appointed to the board, has asked you as a performance management expert for your advice. ‘We need to know whether Perkin’s budgeting process is appropriate for the business, and how this contributed to last year’s poor performance’, she said, ‘and more importantly, how do we need to change the process to prevent this happening in the future, such as a move to beyond budgeting.’

Required:

(a) Evaluate the weaknesses in Perkin’s current budgeting system and whether it is suitable for the environment in which Perkin operates. (13 marks)

(b) Evaluate the impact on Perkin of moving to beyond budgeting. (12 marks)

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

A. The LOB matically compressed.

B. The LOB values are cached bvalues are autoy default in the buffer cache.

C. The LOB values are automatically stored in encrypted mode.

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.