By using the transaction identifier provided by () for a par

题目
单选题
By using the transaction identifier provided by () for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.
A

Flashback Table

B

Flashback Database

C

Flashback Versions Query

D

the RMAN REPORT command

E

the DBA_PENDING_TRANSACTIONS view

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which of the following is the correct format for /etc/inittab entries()

  • A、Runlevel:Action:Identifier:Command
  • B、Identifier:Runlevel:Action:Command
  • C、Command:Action:Identifier:Process
  • D、Process:Runlevel:Command:Identifier

正确答案:B

第2题:

Which of the following is not information provided from an IP phone to a Catalyst switch using  CDP?()

  • A、 device PoE requirements
  • B、 device IP address
  • C、 device voice VLAN ID
  • D、 device platform

正确答案:C

第3题:

(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)


正确答案:
(b) Essentially, Universal is a one product or service company selling its services into two main customer segments in the housing
market. From the performance information provided in Table 1, the company has achieved impressive rates of growth over
the 2001–4 period and this growth has come almost exclusively from private house owners. Universal is in the replacement
market. Its customers are looking to replace existing roofing systems with low maintenance/high attractiveness Universal
systems. To date growth has been exclusively within one region and been achieved by growing the area served through
investment in showrooms and depots.
Universal has chosen to grow its business through a differentiation focus strategy. It has identified a niche not served by the
major PVC doors and windows installers and poorly served by small independent installers. The value chain analysis
discussed above has shown the ways in which Universal has successfully distinguished itself from its competitors. Growth
has been through increasing its market penetration of one particular region. Such is the size of the private house owner market
and the lack of effective competition that the company has achieved a significant share of the market in its particular region.
However, in national terms, with 1% of the available market, Universal is a small operator. What is clear from the sales figures
is that as the firm grows bigger the relative rate of growth inevitably slows down, so that by 2004 it has an annual growth of
27% – still impressive by most companies standards. The move into supplying the commercial housing market has been
successful, but the share of total sales seems to have stabilised at around 5%. Universal clearly is finding it difficult to commit
sufficient new resources to this sector while coping with the growth from the domestic housing sector. Direct labour and other
direct costs seem to be a reasonable proportion of sales and predictably grow with the number of installation teams. Overall,
the gross margin, which sustains sales, marketing and overhead expenses, is moving in the right direction with a gross margin
of 52·6% achieved in 2004.
Labour, not surprisingly in a service business, consumes a considerable amount of costs. If one combines the direct labour
with the commission costs of sales canvassers and representatives together with salaries to staff in head office, one is in a
business where well over 50% of costs are attributable to people. Equally important is the fact that over 80% of the staff
employed by Universal is paid by results. This has significant consequences for the structure of reward systems and the
training and development of staff looking to maximise their incomes through either their individual or team performance.
Clearly, Universal sees no incompatibility between a reward system dominated by payments by results and the delivery of a
quality service differentiating it from its competitors.
Marketing has grown considerably over the period and reflects the recruitment of Mick Hendry as Sales and Marketing Director
in 2002. The marketing and sales model is very much one influenced by the one used by large PVC installers of doors and
windows. Here there is a heavy emphasis on direct selling techniques supported by increasing levels of advertising. Universal
sells to its customers directly and therefore avoids the costs and channel complications of using third parties to provide its
services. In many ways the direct selling techniques used are a very well established way of reaching the customer. Elements
of the marketing mix may be influenced by changes in communication technology, but the nature of the service requires
effective face-to-face contact with the customer. Sales to private house owners using credit generates significant finance
commission and is an important source of extra margin to Universal. Often in businesses depending on significant amounts
of credit sales the sales representative receives significant reward for selling a finance arrangement to the customer.
In terms of net profit achieved, 2001 and 2002 represents a significant change and, as argued in the scenario, this reflects
the recruitment of the Sales and Marketing Director. The achievement of this ‘step change’ in sales required commensurate
increases in most costs, but it is the significant increase in sales costs that explains the losses experienced in 2002. Sales
costs as a proportion of total sales rose from 14% in 2001 to almost 34% in 2002.
Particularly significant is the increase in sales commissions paid. The detailed changes in the way commission is paid is not
given in the case scenario, but it seems likely to reflect the previous experience of the Sales and Marketing Director in a closely
related industry. Similar levels of sales costs are incurred in 2003 and 2004 but the increase in sales, improvement in gross
margin and slower rate of growth in commissions paid explain the improved return on sales from –6·7% in 2002 to 4·2%
in 2003 and 5·8% in 2004.
Equally significant is the growth in showrooms and depots to support the growth in sales. Each additional facility costs in the
order of £30K with significant additions to costs in terms of staff and stock. Overall the performance of Universal over the
2001–2004 period is of a company achieving high rates of growth, incurring significant costs in so doing and moving into
modest levels of profit over the period. Its cost structure reflects the service it provides and the staff and reward systemsenabling the service to be provided.

第4题:

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the primary key.As part of the archival process, the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products, the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer()

  • A、Using the MERGE command
  • B、Using the SQL*Loader utility
  • C、Using the correlated UPDATE command
  • D、Using the INSERT command to perform bulk operation

正确答案:A

第5题:

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()

  • A、It implements High Availability by using the .NET Connector's' load balancing capabilities
  • B、It is shared-nothing architecture
  • C、It is provided by means of IP- level disk replication
  • D、It relies on the shared disk architecture being visible to both servers

正确答案:D

第6题:

What does a BGP route reflector do when reflecting a route?()

  • A、It prepends its cluster identifier to the route's cluster list.
  • B、It prepends its own originator identifier to the route's cluster list.
  • C、It replaces the route's cluster identifier with its own cluster identifier.
  • D、It replaces the route's originator identifier with its originator identifier.

正确答案:A

第7题:

You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process?()

  • A、 Database Identifier (DBID)
  • B、 names and location of datafiles
  • C、 names and location of control files
  • D、 names and location of online redo log files

正确答案:A

第8题:

(b) Using the information provided, state the financial statement risks arising and justify an appropriate audit

approach for Indigo Co for the year ending 31 December 2005. (14 marks)


正确答案:
(b) Financial statement risks
Assets
■ There is a very high risk that inventory could be materially overstated in the balance sheet (thereby overstating profit)
because:
? there is a high volume of metals (hence material);
? valuable metals are made more portable;
? subsidy gives an incentive to overstate purchases (and hence inventory);
? inventory may not exist due to lack of physical controls (e.g. aluminium can blow away);
? scrap metal in the stockyard may have zero net realisable value (e.g. iron is rusty and slow-moving);
? quantities per counts not attended by an auditor have increased by a third.
■ Inventory could be otherwise misstated (over or under) due to:
? the weighbridge being inaccurate;
? metal qualities being estimated;
? different metals being mixed up; and
? the lack of an independent expert to identify/measure/value metals.
■ Tangible non-current assets are understated as the parts of the furnaces that require replacement (the linings) are not
capitalised (and depreciated) as separate items but treated as repairs/maintenance/renewals and expensed.
■ Cash may be understated due to incomplete recording of sales.
■ Recorded cash will be overstated if it does not exist (e.g. if it has been stolen).
■ Trade receivables may be understated if cash receipts from credit customers have been misappropriated.
Liabilities
■ The provision for the replacement of the furnace linings is overstated by the amount provided in the current and previous
year (i.e. in its entirety).
Tutorial note: Last replacement was two years ago.
Income statement
■ Revenue will be understated in respect of unrecorded cash sales of salvaged metals and ‘clinker’.
■ Scrap metal purchases (for cash) are at risk of overstatement:
? to inflate the 15% subsidy;
? to conceal misappropriated cash.
■ The income subsidy will be overstated if quantities purchased are overstated and/or overvalued (on the quarterly returns)
to obtain the amount of the subsidy.
■ Cash receipts/payments that were recorded only in the cash book in November are at risk of being unrecorded (in the
absence of cash book postings for November), especially if they are of a ‘one-off’ nature.
Tutorial note: Cash purchases of scrap and sales of salvaged metal should be recorded elsewhere (i.e. in the manual
inventory records). However, a one-off expense (of a capital or revenue nature) could be omitted in the absence of
another record.
■ Expenditure is overstated in respect of the 25% provision for replacing the furnace linings. However, as depreciation
will be similarly understated (as the furnace linings have not been capitalised) there is no risk of material misstatement
to the income statement overall.
Disclosure risk
■ A going concern (‘failure’) risk may arise through the loss of:
? sales revenue (e.g. through misappropriation of salvaged metals and/or cash);
? the subsidy (e.g. if returns are prepared fraudulently);
? cash (e.g. if material amounts stolen).
Any significant doubts about going concern must be suitably disclosed in the notes to the financial statements.
Disclosure risk arises if the requirements of IAS 1 ‘Presentation of Financial Statements’ are not met.
■ Disclosure risk arises if contingent liabilities in connection with the dumping of ‘clinker’ (e.g. for fines and penalties) are
not adequately disclosed in accordance with IAS 37 ‘Provisions, Contingent Liabilities and Contingent Assets’.
Appropriate audit approach
Tutorial note: In explaining why AN audit approach is appropriate for Indigo it can be relevant to comment on the
unsuitability of other approaches.
■ A risk-based approach is suitable because:
? inherent risk is high at the entity and financial assertion levels;
? material errors are likely to arise in inventory where a high degree of subjectivity will be involved (regarding quality
of metals, quantities, net realisable value, etc);
? it directs the audit effort to inventory, purchases, income (sales and subsidy) and other risk areas (e.g. contingent
liabilities).
■ A systems-based/compliance approach is not suited to the risk areas identified because controls are lacking/ineffective
(e.g. over inventory and cash). Also, as the audit appointment was not more than three months ago and no interim
audit has been conducted (and the balance sheet date is only three weeks away) testing controls is likely to be less
efficient than a substantive approach.
■ A detailed substantive/balance sheet approach would be suitable to direct audit effort to the appropriate valuation of
assets (and liabilities) existing at balance sheet date. Principal audit work would include:
? attendance at a full physical inventory count at 31 December 2005;
? verifying cash at bank (through bank confirmation and reconciliation) and in hand (through physical count);
? confirming the accuracy of the quarterly returns to the local authority.
■ A cyclical approach/directional testing is unlikely to be suitable as cycles are incomplete. For example the purchases
cycle for metals is ‘purchase/cash’ rather than ‘purchase/payable/cash’ and there is no independent third party evidence
to compensate for that which would be available if there were trade payables (i.e. suppliers’ statements). Also the cycles
are inextricably inter-related to cash and inventory – amounts of which are subject to high inherent risk.
■ Analytical procedures may be of limited use for substantive purposes. Factors restricting the use of substantive analytical
procedures include:
? fluctuating margins (e.g. as many factors will influence the price at which scrap is purchased and subsequently
sold, when salvaged, sometime later);
? a lack of reliable/historic information on which to make comparisons.

第9题:

By using the transaction identifier provided by()for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction. 

  • A、 Flashback Table
  • B、 Flashback Database
  • C、 Flashback Version Query
  • D、 The RMAN REPORT command
  • E、 The DBA_PENDING_TRANSACTIONS view

正确答案:C

第10题:

You perform a backup using the following BACKUP command:   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  

  • A、 A different procedure is required to restore a database from compressed backups
  • B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
  • C、 Using this command to create backups minimizes the bandwidth consumed
  • D、 Using this command to create backups improves the performance of the backup process

正确答案:C

更多相关问题