Java程序设计

判断题Prepared Statement是Statement的子接口,使用Prepared Statement要比使用Statement性能更高。A 对B 错

题目
判断题
Prepared Statement是Statement的子接口,使用Prepared Statement要比使用Statement性能更高。
A

B

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

第1题:

executeUpdate()不是Statement接口的方法。()

此题为判断题(对,错)。


参考答案:错误

第2题:

Statement是PreparedStatement的父接口。Statement对象用于执行不带参数的简单SQL语句;PreparedStatement对象用于执行预编译SQL语句。()

此题为判断题(对,错)。


参考答案:正确

第3题:

(ii) Comment on the figures in the statement prepared in (a)(i) above. (4 marks)


正确答案:
(ii) The statement of product profitability shows that CTC is forecast to achieve a profit of $2·185 million in 2008 giving a
profit:sales ratio of 11·9%. However, the forecast profit in 2009 is only $22,000 which would give a profit:sales ratio
of just 0·19%! Total sales volume in 2008 is 390,000 units which represent 97·5% utilisation of total annual capacity.
In stark contrast, the total sales volume in 2009 is forecast to be 240,000 units which represents 60% utilisation of
total annual capacity and shows the expected rapid decline in sales volumes of Bruno and Kong products. The rapid
decline in the sales of these two products is only offset to a relatively small extent by increased sales volume from the
Leo product. It is vital that a new product or products with healthy contribution to sales ratios are introduced.
Management should also undertake cost/benefit analyses in order to assess the potential of extending the life of Bruno
and Kong products.

第4题:

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

A.

B.

C.

D.


参考答案:C

第5题:

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product


参考答案:A

第6题:

The income statement is prepared from ().

A.the income statement columns of the work sheet

B.the adjusted trial balance

C.either the adjusted trial balance or the income statement columns of the work sheet

D.both the adjusted trial balance and the income statement columns of the work sheet


正确答案:C

第7题:

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.


参考答案:C

第8题:

(b) Explain the matters that should be considered when planning the nature and scope of the examination of

Cusiter Co’s forecast balance sheet and income statement as prepared for the bank. (7 marks)


正确答案:
(b) Matters to be considered
Tutorial note: Candidates at this level must appreciate that the matters to be considered when planning the nature and
scope of the examination are not the same matters to be considered when deciding whether or not to accept an
engagement. The scenario clearly indicates that the assignment is being undertaken by the current auditor rendering any
‘pre-engagement’/‘professional etiquette’ considerations irrelevant to answering this question.
This PFI has been prepared to show an external user, the bank, the financial consequences of Cusiter’s plans to help the bank
in making an investment decision. If Cusiter is successful in its loan application the PFI provides a management tool against
which the results of investing in the plant and equipment can be measured.
The PFI is unpublished rather than published. That is, it is prepared at the specific request of a third party, the bank. It will
not be published to users of financial information in general.
The auditor’s report on the PFI will provide only negative assurance as to whether the assumptions provide a reasonable basis
for the PFI and an opinion whether the PFI is:
■ properly prepared on the basis of the assumptions; and
■ presented in accordance with the relevant financial reporting framework.
The nature of the engagement is an examination to obtain evidence concerning:
■ the reasonableness and consistency of assumptions made;
■ proper preparation (on the basis of stated assumptions); and
■ consistent presentation (with historical financial statements, using appropriate accounting principles).
Such an examination is likely to take the form. of inquiry, analytical procedures and corroboration.
The period of time covered by the prospective financial information is two years. The assumptions for 2008 are likely to be
more speculative than for 2007, particularly in relation to the impact on earnings, etc of the investment in new plant and
equipment.
The forecast for the year to 31 December 2007 includes an element of historical financial information (because only part of
this period is in the future) hence actual evidence should be available to verify the first three months of the forecast (possibly
more since another three-month period will expire at the end of the month).
Cusiter management’s previous experience in preparing PFI will be relevant. For example, in making accounting estimates
(e.g. for provisions, impairment losses, etc) or preparing cash flow forecasts (e.g. in support of the going concern assertion).
The basis of preparation of the forecast. For example, the extent to which it comprises:
■ proforma financial information (i.e. historical financial information adjusted for the effects of the planned loan and capital
expenditure transaction);
■ new information and assumptions about future performance (e.g. the operating capacity of the new equipment, sales
generated, etc).
The nature and scope of any standards/guidelines under which the PFI has been prepared is likely to assist the auditor in
discharging their responsibilities to report on it. Also, ISAE 3400 The Examination of Prospective Financial Information,
establishes standards and provides guidance on engagements to examine and report on PFI including examination
procedures.
The planned nature and scope of the examination is likely to take into account the time and fee budgets for the assignments
as adjusted for any ‘overlap’ with audit work. For example, the examination of the PFI is likely to draw on the auditor’s
knowledge of the business obtained in auditing the financial statements to 31 December 2006. Analytical procedures carried
out in respect of the PFI may provide evidence relevant to the 31 December 2007 audit.

第9题:

Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?()

A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

B. The statement returns an error at the SELECT clause.

C. The statement returns an error at the WHERE clause.

D. The statement returns an error at the ORDER BY clause.


参考答案:C

第10题:

Evaluate the set of SQL statements:What is true about the set?()

A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

B. The ROLLBACK statement frees the storage space occupies by the DEPT table.

C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.


参考答案:A

更多相关问题