CMS专题

单选题What view might you use to try to determine how long a particular backup will take?()A V$SESSION_EVENT B V$SESSION C V$W0041ITSD V$WAITSTAT E V$SESSION_LONGOPS 

题目
单选题
What view might you use to try to determine how long a particular backup will take?()
A

V$SESSION_EVENT 

B

V$SESSION 

C

V$W0041ITS

D

V$WAITSTAT 

E

V$SESSION_LONGOPS 

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

第1题:

Could you tell me ()?

A、how long you live here

B、how long have you lived here

C、how long you have lived here

D、how long did you live here


参考答案:C

第2题:

Could you please tell me ____________________ ?

A、how long have you lived here

B、how long you lived here

C、how long you have lived here

D、you have lived here how long


参考答案:C

第3题:

(b) Illustrate how you might use analytical procedures to provide audit evidence and reduce the level of detailed

substantive procedures. (7 marks)


正确答案:
(b) Illustration of use of analytical procedures as audit evidence
Tutorial note: Note that ‘as audit evidence’ requires consideration of substantive analytical procedures rather that the
identification of risks (relevant to part (a)).
Revenue
Analytical procedures may be used in testing revenue for completeness of recording (‘understatement’). The average selling
price of a vehicle in 2005 was $68,830 ($526·0 million ÷ 7,642 vehicles). Applying this to the number of vehicles sold
in 2006, might be projected to generate $698·8 million ($68,830 × 10,153) revenue from the sale of vehicles. The draft
financial statements therefore show a potential shortfall of $110·8 million ($(698·8 – 588·0) million) that is, 15·6%.
This should be investigated and substantiated through more detailed analytical procedures. For example, the number of
vehicles sold should be analysed into models and multiplied by the list price of each for a more accurate estimate of potential
revenue. The impact of discounts and other incentives (e.g. 0% finance) on the list prices should then be allowed for. If
recorded revenue for 2006 (as per draft income statement adjusted for cutoff and consignment inventories) is materially lower
than that calculated, detailed substantive procedures may be required in order to show that there is no material error.
‘Proof in total’/reasonableness tests
The material correctness, or otherwise, of income statement items (in particular) may be assessed through appropriate ‘proof
in total’ calculations (or ‘reasonableness’ tests). For example:
■ Employee benefits costs: the average number of employees by category (waged/salaried/apprenticed) × the average pay
rate for each might prove that in total $91·0 million (as adjusted to actual at 31 December 2006) is not materially
misstated. The average number of employees needs to be checked substantively (e.g. recalculated based on the number
of employees on each payroll) and the average pay rates (e.g. to rates agreed with employee representatives).
Tutorial note: An alternative reasonableness might be to take last year’s actual adjusted for 2006 numbers of
employees grossed-up for any pay increases during the year (pro-rated as necessary).
■ Depreciation: the cost (or net book value) of each category of asset × by the relevant straight-line (or reducing balance)
depreciation rate. If a ‘ballpark’ calculation for the year is materially different to the annual charge a more detailed
calculation can be made using monthly depreciation calculations. The cost (or net book value) on which depreciation
is calculated should be substantively tested, for example by agreeing brought forward balances to prior year working
papers and additions to purchase invoices (costings in respect of assets under construction).
Tutorial note: Alternatively, last year’s depreciation charge may be reconciled to this year’s by considering depreciation
rates applied to brought forward balances with adjustments for additions/disposals.
■ Interest income: an average interest rate for the year can be applied to the monthly balance invested (e.g. in deposit
accounts) and compared with the amount recognised for the year to 31 December 2006 (as adjusted for any accrued
interest per the bank letter for audit purposes). The monthly balances (or averages) on which the calculation is
performed should be substantiated to bank deposit statements.
■ Interest expense: if the cash balances do not go into overdraft then this may be similar expenses (e.g. prompt payment
discounts to customers). If this is to particular dealers then a proof in total might be to apply the discount rate to the
amounts invoiced to the dealer during the period.
Immaterial items
For immaterial items analytical procedures alone may provide sufficient audit evidence that amounts in the financial
statements are not materially misstated so that detailed substantive procedures are not required. For example, a comparison
of administration and distribution, maintenance and insurance costs for 2006 compared with 2005 may be sufficient to show
that material error is highly unlikely. If necessary, further reasonableness tests could be performed. For example, considering
insurance costs to value of assets insured or maintenance costs to costs of assets maintained.
Ratio analysis
Ratio analysis can provide substantive evidence that income statement and balance sheet items are not materially misstated
by considering their inter-relationships. For example:
■ Asset turnover: Based on the draft financial statements property, plant and equipment has turned over 5·2 times
($645·5/124·5) compared with 5·9 times in 2005. This again highlights that income may be overstated, or assets
overstated (e.g. if depreciation is understated).
■ Inventory turnover: Using cost of materials adjusted for changes in inventories this has remained stable at 10·9 times.
Tutorial note: This is to be expected as in (a) the cost in the income statement has increased by 9% and the value of
inventories by 8·5%.
Inventories represent the smallest asset value on the balance sheet at 31 December 2006 (7·8% of total assets).
Therefore substantive procedures may be limited to agreeing physical count of material items (vehicles) and agreeing
cutoff.
■ Average collection period: This has increased to 41 days (73·1/645·5 × 365) from 30 days. Further substantive analysis
is required, for example, separating out non-current amounts (for sales on 0% finance terms). Substantive procedures
may be limited to confirmation of amounts due from dealers (and/or receipt of after-date cash) and agreeing cutoff of
goods on consignment.
■ Payment periods: This has remained constant at 37 days (2005 – 38 days). Detailed substantive procedures may be
restricted to reconciling only major suppliers’ statements and agreeing the cutoff on parts purchased from them.

第4题:

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups?()  

  • A、 V$SYSSTAT
  • B、 V$SESSSTAT
  • C、 V$RSRC_PLAN
  • D、 V$RSRC_CONSUMER_GROUP

正确答案:D

第5题:

You are the administrator of ExamSheet.net's network.  Your Windows 2000 Professional computer has a Pentium II 400-HHz processor, 128 MB of RAM, and IDE hard disk. After installing a new digital imaging application you notice that your computer is responding very slowly and you are experiencing delays in processing graphics files. You want to determine if the performance problems are being caused by a memory bottleneck. What should you do?()

  • A、Use Task Manager to view the running applications. 
  • B、Use Task Manager to view the running processes.
  • C、Use System Monitor to view the System-Processor Queue Length and Processor-Interrups/Sec counters.
  • D、Use System Monitor to view the Logical Disk-Avg. Disk sec/Transfer and Memory-Pages/Sec counters.

正确答案:D

第6题:

______ it is from Bristol to Glasgow!

A、What long a way

B、What distance

C、How long way

D、How far


参考答案:D

第7题:

You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend?()

  • A、 Use SQL Server Profiler to identify missing indexes.
  • B、 Use the Database Engine Tuning Advisor to identify missing indexes.
  • C、 Use a Dynamic Management View to analyze query plans.
  • D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

正确答案:C

第8题:

(作文)1.What is your biggest dream?

2.Why do you have it? For how long have you got it?

3.What are your plans to achieve your dream?


参考答案:
The Biggest Dream of My Life
I know many people whose biggest dreams are things such as what career they want to get into, how much money they can earn.My dream is nothing like that.My biggest dream has always been and will always be to travel around the world.I have one life here on Earth, so I don’t want to die regretting that I didn’t see it all.
Actually I have had this dream ever since I was in primary school.In one geography class, when the teacher presented us the globe and national fl ags of various nations, I thought I found the dream in the depth of my heart.And the moment I came to college, I had always envisioned myself of becoming a nomad.I would roam around the world.No permanent address.Any place can be my home and I am home within myself.
Meanwhile, I am aware that it’s really a costly dream.The first step I need to take is to begin to save money to support it.And I think it’s a good idea to start exploration from my hometown and the city where my university is located.Just as a saying goes: a big dream begins with the first step.

第9题:

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? ()

  • A、Use the DESCRIBE command in the EMP_DEPT VU view.
  • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
  • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
  • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
  • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
  • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

正确答案:D

第10题:

What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?()  

  • A、 TS_CHECK
  • B、 TPITR_CHECK
  • C、 TS_PITR_CHECK
  • D、 CHECK_TSPITR
  • E、 PITR_TS_CHECK

正确答案:C

更多相关问题