违法和不良信息举报 联系客服
免费注册 登录

多选题View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries？ （）Adisplaying the minimum list price for each product statusBdisplaying all supplier IDs whose average list price is more than 500Cdisplay

题目
多选题
View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries？ （）
A

displaying the minimum list price for each product status

B

displaying all supplier IDs whose average list price is more than 500

C

displaying the number of products whose list prices are more than the average list price

D

displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable

E

displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

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

第1题：

Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()

A.to find the tax percentage for each of the employees

B.to list the name, job_id, and manager name for all the employees

C.to find the name, salary, and the department name of employees who are not working with Smith

D.to find the number of employees working for the Administrative department and earning less than 4000

E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned


参考答案：A

第2题：

A manufacturing company, Man Co, has two divisions: Division L and Division M. Both divisions make a single standardised product. Division L makes component L, which is supplied to both Division M and external customers.

Division M makes product M using one unit of component L and other materials. It then sells the completed

product M to external customers. To date, Division M has always bought component L from Division L.

The following information is available:

Division L charges the same price for component L to both Division M and external customers. However, it does not incur the selling and distribution costs when transferring internally.

Division M has just been approached by a new supplier who has offered to supply it with component L for $37 per unit. Prior to this offer, the cheapest price which Division M could have bought component L for from outside the group was $42 per unit.

It is head office policy to let the divisions operate autonomously without interference at all.

Required:

(a) Calculate the incremental profit/(loss) per component for the group if Division M accepts the new supplier’s

offer and recommend how many components Division L should sell to Division M if group profits are to be

maximised. (3 marks)

(b) Using the quantities calculated in (a) and the current transfer price, calculate the total annual profits of each division and the group as a whole. (6 marks)

(c) Discuss the problems which will arise if the transfer price remains unchanged and advise the divisions on a suitable alternative transfer price for component L. (6 marks)


正确答案：
(a)MaximisinggroupprofitDivisionLhasenoughcapacitytosupplybothDivisionManditsexternalcustomerswithcomponentL.Therefore,incrementalcostofDivisionMbuyingexternallyisasfollows:CostperunitofcomponentLwhenboughtfromexternalsupplier:$37CostperunitforDivisionLofmakingcomponentL:$20.ThereforeincrementalcosttogroupofeachunitofcomponentLbeingboughtinbyDivisionMratherthantransferredinternally:$17($37–20).Fromthegroup’spointofview,themostprofitablecourseofactionisthereforethatall120,000unitsofcomponentLshouldbetransferredinternally.(b)CalculatingtotalgroupprofitTotalgroupprofitswillbeasfollows:DivisionL:Contributionearnedpertransferredcomponent=$40–$20=$20Profitearnedpercomponentsoldexternally=$40–$24=$16(c)ProblemswithcurrenttransferpriceandsuggestedalternativeTheproblemisthatthecurrenttransferpriceof$40perunitisnowtoohigh.Whilstthishasnotbeenaproblembeforesinceexternalsupplierswerecharging$42perunit,itisaproblemnowthatDivisionMhasbeenofferedcomponentLfor$37perunit.IfDivisionMnowactsinitsowninterestsratherthantheinterestsofthegroupasawhole,itwillbuycomponentLfromtheexternalsupplierratherthanfromDivisionL.ThiswillmeanthattheprofitsofthegroupwillfallsubstantiallyandDivisionLwillhavesignificantunusedcapacity.Consequently,DivisionLneedstoreduceitsprice.Thecurrentpricedoesnotreflectthefactthattherearenosellinganddistributioncostsassociatedwithtransferringinternally,i.e.thecostofsellinginternallyis$4lessforDivisionLthansellingexternally.So,itcouldreducethepriceto$36andstillmakethesameprofitonthesesalesasonitsexternalsales.ThiswouldthereforebethesuggestedtransferpricesothatDivisionMisstillsaving$1perunitcomparedtotheexternalprice.Atransferpriceof$37wouldalsopresumablybeacceptabletoDivisionMsincethisisthesameastheexternalsupplierisoffering.

第3题：

_______________ is when a country or company exports a product at a price that is lower in the foreign importing market than the price in the exporter's domestic market.

A、trade barrier

B、dumping

C、tariff

D、open border


参考答案：C

第4题：

When rejecting applied an dependent updates on an AIX 5L system, which of the following procedures is most appropriate to follow?（）

  • A、Use the install PREVIEW option to view a list of all updates that will be rejected
  • B、Use the lslpp -d command to view the dependent filesets that will be rejected
  • C、Select the SMIT option to Verify Software Requisites and Installations first to generate a list of all applied updates.
  • D、Select the SMIT option to List the Maintenance Level of a Software Product to double check the update level that should be removed

正确答案:A

第5题：

When rejecting applied an dependent updates on an AIX 5L system, which of the following procedures is most appropriate to follow?()

A.Use the install PREVIEW option to view a list of all updates that will be rejected

B.Use the lslpp -d command to view the dependent filesets that will be rejected

C.Select the SMIT option to Verify Software Requisites and Installations first to generate a list of all applied updates.

D.Select the SMIT option to List the Maintenance Level of a Software Product to double check the update level that should be removed


参考答案：A

第6题：

Click the Exhibit button and examine the data from the EMP table.The COMMISSION column shows the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step? （）

A.listing the employees who earn the same amount of commission as employee 3

B.finding the total commission earned by the employees in department 10

C.finding the number of employees who earn a commission that is higher than the average commission of the company

D.listing the departments whose average commission is more than 600

E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID

F.listing the employees whose annual commission is more than 6000


参考答案：A, C

第7题：

Which of the following procedures correctly lists the prerequisite software that requires installation with an AIX licensed program product?()

A.Use the lppdiff command to list the contents

B.Use the installp -Q command to list the contents

C.Choose the SMIT option to Preview Install Only

D.Choose the SMIT option to list dependents of a software product


参考答案：C

第8题：

WE price this new product economically with a view()promoting the transaction.

A、to

B、of

C、in

D、on


参考答案：A

第9题：

已知xml文档包含如下内容（list为根元素）： ＜list＞ ＜item id="0001"＞ ＜price＞18＜/price＞ ＜/item＞ ＜item id="0002"＞ ＜price＞15＜/price＞ ＜/item＞ ＜item/＞ ＜product＞ ＜item id="01"＞＜/item＞ ＜/product＞ ＜/list＞ 使用xslt进行转换时，语句＜xsl:template match=”/list/item[@id]”＞能够匹配到（）个item元素。

  • A、3
  • B、2
  • C、1
  • D、0

正确答案:B

第10题：

 You are developing a report to allow customers in a department store to view product information. You added a button to the layout to allow customers to view the picture of the product. Which button property would you alter to specify the source of the .BMP file?（）

  • A、Type 
  • B、Multimedia file 
  • C、Multi media file type 
  • D、Label type

正确答案:B

更多相关问题
相关内容