(b) Illustrate EACH of the six problems chosen in (a) using the data from the Bettamould division/TRG scenario;
and (6 marks)
第1题:
(b) Using the information provided in the case scenario, strategically evaluate the performance of the company
up to 2004, indicating any areas of particular concern. (20 marks)
第2题:
(c) Using information from the case, assess THREE risks to the Giant Dam Project. (9 marks)
第3题:
(b) Using the unit cost information available and your calculations in (a), prepare a financial analysis of the
decision strategy which TOC may implement with regard to the manufacture of each product. (6 marks)

第4题:
(c) Suggest ways in which each of the six problems chosen in (a) above may be overcome. (6 marks)
第5题:
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()

A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
第6题:
Which of the following is TRUE about the ping -f command?()
第7题:
Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?()
第8题:
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; } Which statement is true about the duplicate database in this scenario?()
第9题:
How can you configure High Availability for interacting with a non-Oracle database using WebLogic?()
第10题:
A
B
C
D
第11题:
Configure multiple physical data sources and reuse the same JNDI name for each.
Use the compatibility option of Active GridLink to enable compatibility with non-Oracle databases.
Configure a single physical data source for each node in a database cluster and wrap it using Multi Data Source.
Configure a Data Source Group that contains a physical connection pool to each node in the database cluster.
第12题:
Load data from a disk, tape, or named pipes.
Load data into an Oracle database using DML statements.
Extract, reorganize, and insert data within an Oracle database.
Load data from external files into tables in an Oracle database.
Load data into an Oracle database using operating system commands.
Load data directly from a non-Oracle database to an Oracle database.
第13题:
(b) Using the TARA framework, construct four possible strategies for managing the risk presented by Product 2.
Your answer should describe each strategy and explain how each might be applied in the case.
(10 marks)
第14题:
2 The Information Technology division (IT) of the RJ Business Consulting Group provides consulting services to its
clients as well as to other divisions within the group. Consultants always work in teams of two on every consulting
day. Each consulting day is charged to external clients at £750 which represents cost plus 150% profit mark up. The
total cost per consulting day has been estimated as being 80% variable and 20% fixed.
The director of the Human Resources (HR) division of RJ Business Consulting Group has requested the services of
two teams of consultants from the IT division on five days per week for a period of 48 weeks, and has suggested that
she meets with the director of the IT division in order to negotiate a transfer price. The director of the IT division has
responded by stating that he is aware of the limitations of using negotiated transfer prices and intends to charge the
HR division £750 per consulting day.
The IT division always uses ‘state of the art’ video-conferencing equipment on all internal consultations which would
reduce the variable costs by £50 per consulting day. Note: this equipment can only be used when providing internal
consultations.
Required:
(a) Calculate and discuss the transfer prices per consulting day at which the IT division should provide
consulting services to the HR division in order to ensure that the profit of the RJ Business Consulting Group
is maximised in each of the following situations:
(i) Every pair of consultants in the IT division is 100% utilised during the required 48-week period in
providing consulting services to external clients, i.e. there is no spare capacity.
(ii) There is one team of consultants who, being free from other commitments, would be available to
undertake the provision of services to the HR division during the required 48-week period. All other
teams of consultants would be 100% utilised in providing consulting services to external clients.
(iii) A major client has offered to pay the IT division £264,000 for the services of two teams of consultants
during the required 48-week period.
(12 marks)
第15题:
2 The Rubber Group (TRG) manufactures and sells a number of rubber-based products. Its strategic focus is channelled
through profit centres which sell products transferred from production divisions that are operated as cost centres. The
profit centres are the primary value-adding part of the business, where commercial profit centre managers are
responsible for the generation of a contribution margin sufficient to earn the target return of TRG. The target return is
calculated after allowing for the sum of the agreed budgeted cost of production at production divisions, plus the cost
of marketing, selling and distribution costs and central services costs.
The Bettamould Division is part of TRG and manufactures moulded products that it transfers to profit centres at an
agreed cost per tonne. The agreed cost per tonne is set following discussion between management of the Bettamould
Division and senior management of TRG.
The following information relates to the agreed budget for the Bettamould Division for the year ending 30 June 2009:
(1) The budgeted output of moulded products to be transferred to profit centres is 100,000 tonnes. The budgeted
transfer cost has been agreed on a two-part basis as follows:
(i) A standard variable cost of $200 per tonne of moulded products;
(ii) A lump sum annual charge of $50,000,000 in respect of fixed costs, which is charged to profit centres, at
$500 per tonne of moulded products.
(2) Budgeted standard variable costs (as quoted in 1 above) have been set after incorporating each of the following:
(i) A provision in respect of processing losses amounting to 15% of material inputs. Materials are sourced on
a JIT basis from chosen suppliers who have been used for some years. It is felt that the 15% level of losses
is necessary because the ageing of the machinery will lead to a reduction in the efficiency of output levels.
(ii) A provision in respect of machine idle time amounting to 5%. This is incorporated into variable machine
costs. The idle time allowance is held at the 5% level partly through elements of ‘real-time’ maintenance
undertaken by the machine operating teams as part of their job specification.
(3) Quality checks are carried out on a daily basis on 25% of throughput tonnes of moulded products.
(4) All employees and management have contracts based on fixed annual salary agreements. In addition, a bonus
of 5% of salary is payable as long as the budgeted output of 100,000 tonnes has been achieved;
(5) Additional information relating to the points in (2) above (but NOT included in the budget for the year ending
30 June 2009) is as follows:
(i) There is evidence that materials of an equivalent specification could be sourced for 40% of the annual
requirement at the Bettamould Division, from another division within TRG which has spare capacity.
(ii) There is evidence that a move to machine maintenance being outsourced from a specialist company could
help reduce machine idle time and hence allow the possibility of annual output in excess of 100,000 tonnes
of moulded products.
(iii) It is thought that the current level of quality checks (25% of throughput on a daily basis) is vital, although
current evidence shows that some competitor companies are able to achieve consistent acceptable quality
with a quality check level of only 10% of throughput on a daily basis.
The directors of TRG have decided to investigate claims relating to the use of budgeting within organisations which
have featured in recent literature. A summary of relevant points from the literature is contained in the following
statement:
‘The use of budgets as part of a ‘performance contract’ between an organisation and its managers may be seen as a
practice that causes management action which might lead to the following problems:
(a) Meeting only the lowest targets
(b) Using more resources than necessary
(c) Making the bonus – whatever it takes
(d) Competing against other divisions, business units and departments
(e) Ensuring that what is in the budget is spent
(f) Providing inaccurate forecasts
(g) Meeting the target, but not beating it
(h) Avoiding risks.’
Required:
(a) Explain the nature of any SIX of the eight problems listed above relating to the use of budgeting;
(12 marks)
第16题:
(c) Illustrate how:
(i) inquiry; and (4 marks)
第17题:
A manufacturing company, Man Co, has two divisions: Division L and Division M. Both divisions make a single standardised product. Division L makes component L, which is supplied to both Division M and external customers.
Division M makes product M using one unit of component L and other materials. It then sells the completed
product M to external customers. To date, Division M has always bought component L from Division L.
The following information is available:

Division L charges the same price for component L to both Division M and external customers. However, it does not incur the selling and distribution costs when transferring internally.
Division M has just been approached by a new supplier who has offered to supply it with component L for $37 per unit. Prior to this offer, the cheapest price which Division M could have bought component L for from outside the group was $42 per unit.
It is head office policy to let the divisions operate autonomously without interference at all.
Required:
(a) Calculate the incremental profit/(loss) per component for the group if Division M accepts the new supplier’s
offer and recommend how many components Division L should sell to Division M if group profits are to be
maximised. (3 marks)
(b) Using the quantities calculated in (a) and the current transfer price, calculate the total annual profits of each division and the group as a whole. (6 marks)
(c) Discuss the problems which will arise if the transfer price remains unchanged and advise the divisions on a suitable alternative transfer price for component L. (6 marks)
第18题:
SQ L*Loader is a utility that can perform which two tasks?()
第19题:
For which two tasks would it be best NOT to use the utility SQL*Loader?()
第20题:
You issue the following statement: SQL> SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()
第21题:
TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?()
第22题:
When loading selected rows into each table.
When loading data from an export dump file.
When loading data from disk, tape, or named pipes.
When your data is NOT being inserted from a flat file.
When using a record management system to access data files.
第23题:
ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
DROP TRIGGER trg_InsertOrders
DISABLE TRIGGER trg_InsertOrders ON Orders
ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'