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

题目

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.


相似考题
更多“Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by ”相关问题
  • 第1题:

    (iii) A statement on the importance of confidentiality in the financing of the early stage working capital needs

    and an explanation of how this conflicts with the duty of transparency in matters of corporate

    governance. (6 marks)

    Professional marks for layout, logical flow and persuasiveness of the statement. (4 marks)


    正确答案:
    (iii) Importance of confidentiality in the financing of the project and the normal duty of transparency.
    I have been asked to include a statement in my remarks on the balance between our duty to be transparent whenever
    possible and the need for discretion and confidentiality in some situations. In the case of our initial working capital needs
    for the Giant Dam Project, the importance of confidentiality in financing is due to the potential for adverse publicity that
    may arise for the lender. It is important that R&M have the project adequately financed, especially in the early stages
    before the interim payments from the client become fully effective.
    In general, of course, we at R&M attempt to observe the highest standards of corporate governance and this involves
    adopting a default position of transparency rather than concealment wherever possible. We recognise that transparency
    is important to underpin investor confidence and to provide investors with the information they need to make fund
    allocation decisions.
    Whilst it is normal to disclose the amount of debt we carry at any given point (on the balance sheet), it is rarely normal
    practice to disclose the exact sources of those loans. In the case of the financing of initial working capital for the Giant
    Dam Project, I’m sure you will realise that in this unique situation, disclosure of the lender’s identity could threaten the
    progress of the project. For this reason we must resist any attempts to release this into the public domain. We are aware
    of one pressure group that is actively seeking to discover this information in order to disrupt the project’s progress and
    we shall be taking all internal measures necessary to ensure they do not obtain the information.
    Thank you for listening.

  • 第2题:

    In relation to company law, explain:

    (a) the limitations on the use of company names; (4 marks)

    (b) the tort of ‘passing off’; (4 marks)

    (c) the role of the company names adjudicators under the Companies Act 2006. (2 marks)


    正确答案:

    (a) Except in relation to specifically exempted companies, such as those involved in charitable work, companies are required to indicate that they are operating on the basis of limited liability. Thus private companies are required to end their names, either with the word ‘limited’ or the abbreviation ‘ltd’, and public companies must end their names with the words ‘public limited company’ or the abbreviation ‘plc’. Welsh companies may use the Welsh language equivalents (Companies Act (CA)2006 ss.58, 59 & 60).
    Companies Registry maintains a register of business names, and will refuse to register any company with a name that is the same as one already on that index (CA 2006 s.66).
    Certain categories of names are, subject to the decision of the Secretary of State, unacceptable per se, as follows:
    (i) names which in the opinion of the Secretary of State constitute a criminal offence or are offensive (CA 2006 s.53)
    (ii) names which are likely to give the impression that the company is connected with either government or local government authorities (s.54).
    (iii) names which include a word or expression specified under the Company and Business Names Regulations 1981 (s.26(2)(b)). This category requires the express approval of the Secretary of State for the use of any of the names or expressions contained on the list, and relates to areas which raise a matter of public concern in relation to their use.
    Under s.67 of the Companies Act 2006 the Secretary of State has power to require a company to alter its name under the following circumstances:
    (i) where it is the same as a name already on the Registrar’s index of company names.
    (ii) where it is ‘too like’ a name that is on that index.
    The name of a company can always be changed by a special resolution of the company so long as it continues to comply with the above requirements (s.77).

    (b) The tort of passing off was developed to prevent one person from using any name which is likely to divert business their way by suggesting that the business is actually that of some other person or is connected in any way with that other business. It thus enables people to protect the goodwill they have built up in relation to their business activity. In Ewing v Buttercup
    Margarine Co Ltd (1917) the plaintiff successfully prevented the defendants from using a name that suggested a link with
    his existing dairy company. It cannot be used, however, if there is no likelihood of the public being confused, where for example the companies are conducting different businesses (Dunlop Pneumatic Tyre Co Ltd v Dunlop Motor Co Ltd (1907)
    and Stringfellow v McCain Foods GB Ltd (1984). Nor can it be used where the name consists of a word in general use (Aerators Ltd v Tollitt (1902)).
    Part 41 of the Companies Act (CA) 2006, which repeals and replaces the Business Names Act 1985, still does not prevent one business from using the same, or a very similar, name as another business so the tort of passing off will still have an application in the wider business sector. However the Act introduced a new procedure to deal specifically with company names. As previously under the CA 1985, a company cannot register with a name that was the same as any already registered (s.665 Companies Act (CA) 2006) and under CA s.67 the Secretary of State may direct a company to change its name if it has been registered in a name that is the same as, or too like a name appearing on the registrar’s index of company names. In addition, however, a completely new system of complaint has been introduced.

    (c) Under ss.69–74 of CA 2006 a new procedure has been introduced to cover situations where a company has been registered with a name
    (i) that it is the same as a name associated with the applicant in which he has goodwill, or
    (ii) that it is sufficiently similar to such a name that its use in the United Kingdom would be likely to mislead by suggesting a connection between the company and the applicant (s.69).
    Section 69 can be used not just by other companies but by any person to object to a company names adjudicator if a company’s name is similar to a name in which the applicant has goodwill. There is list of circumstances raising a presumption that a name was adopted legitimately, however even then, if the objector can show that the name was registered either, to obtain money from them, or to prevent them from using the name, then they will be entitled to an order to require the company to change its name.
    Under s.70 the Secretary of State is given the power to appoint company names adjudicators and their staff and to finance their activities, with one person being appointed Chief Adjudicator.
    Section 71 provides the Secretary of State with power to make rules for the proceedings before a company names adjudicator.
    Section 72 provides that the decision of an adjudicator and the reasons for it, are to be published within 90 days of the decision.
    Section 73 provides that if an objection is upheld, then the adjudicator is to direct the company with the offending name to change its name to one that does not similarly offend. A deadline must be set for the change. If the offending name is not changed, then the adjudicator will decide a new name for the company.
    Under s.74 either party may appeal to a court against the decision of the company names adjudicator. The court can either uphold or reverse the adjudicator’s decision, and may make any order that the adjudicator might have made.

  • 第3题:

    Examine the description of the MARKS table:STD_ID NUMBER(4)STUDENT_NAME VARCHAR2(30)SUBJ1 NUMBER(3)SUBJ2 NUMBER(3)SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:SELECT subj1+subj2 total_marks, std_idFROM marksWHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks;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

  • 第4题:

    (iv) The stamp duty and/or stamp duty land tax payable by the Saturn Ltd group; (2 marks)

    Additional marks will be awarded for the appropriateness of the format and presentation of the memorandum

    and the effectiveness with which the information is communicated. (2 marks)


    正确答案:
    (iv) Stamp duty and stamp duty land tax
    – The purchase of Tethys Ltd will give rise to a liability to ad valorem stamp duty of £1,175 (£235,000 x 0·5%).
    The stamp duty must be paid by Saturn Ltd within 30 days of the share transfer in order to avoid interest being
    charged. It is not an allowable expense for the purposes of corporation tax.

  • 第5题:

    What was the price of US dollar against mark on Monday?

    A.1.53 marks.

    B.1.57 marks.

    C.1.55 marks.

    D.122.75 yen.


    正确答案:B
    解析:文章第二段最后一句提到On Monday trading, technical factor...as low as 1.57 marks。在星期一的交易中,由于技术的原因导致美元进一步下跌,只得以低于1.57marks的价格上市。

  • 第6题:

    (a) List and explain FOUR methods of selecting a sample of items to test from a population in accordance with ISA 530 (Redrafted) Audit Sampling and Other Means of Testing. (4 marks)

    (b) List and explain FOUR assertions from ISA 500 Audit Evidence that relate to the recording of classes of

    transactions. (4 marks)

    (c) In terms of audit reports, explain the term ‘modified’. (2 marks)


    正确答案:
    (a)SamplingmethodsMethodsofsamplinginaccordancewithISA530AuditSamplingandOtherMeansofTesting:Randomselection.Ensureseachiteminapopulationhasanequalchanceofselection,forexamplebyusingrandomnumbertables.Systematicselection.Inwhichanumberofsamplingunitsinthepopulationisdividedbythesamplesizetogiveasamplinginterval.Haphazardselection.Theauditorselectsthesamplewithoutfollowingastructuredtechnique–theauditorwouldavoidanyconsciousbiasorpredictability.Sequenceorblock.Involvesselectingablock(s)ofcontinguousitemsfromwithinapopulation.Tutorialnote:Othermethodsofsamplingareasfollows:MonetaryUnitSampling.Thisselectionmethodensuresthateachindividual$1inthepopulationhasanequalchanceofbeingselected.Judgementalsampling.Selectingitemsbasedontheskillandjudgementoftheauditor.(b)Assertions–classesoftransactionsOccurrence.Thetransactionsandeventsthathavebeenrecordedhaveactuallyoccurredandpertaintotheentity.Completeness.Alltransactionsandeventsthatshouldhavebeenrecordedhavebeenrecorded.Accuracy.Theamountsandotherdatarelatingtorecordedtransactionsandeventshavebeenrecordedappropriately.Cut-off.Transactionsandeventshavebeenrecordedinthecorrectaccountingperiod.Classification.Transactionsandeventshavebeenrecordedintheproperaccounts.(c)AuditreporttermModified.Anauditormodifiesanauditreportinanysituationwhereitisinappropriatetoprovideanunmodifiedreport.Forexample,theauditormayprovideadditionalinformationinanemphasisofmatter(whichdoesnotaffecttheauditor’sopinion)orqualifytheauditreportforlimitationofscopeordisagreement.