对
错
第1题:
此题为判断题(对,错)。
第2题:
此题为判断题(对,错)。
第3题:
(ii) Comment on the figures in the statement prepared in (a)(i) above. (4 marks)
第4题:
A.
B.
C.
D.
第5题:
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
第6题:
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
第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.
第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)
第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.
第10题:
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.