displaying the minimum list price for each product status
displaying all supplier IDs whose average list price is more than 500
displaying the number of products whose list prices are more than the average list price
displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
第1题:
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
第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)
第3题:
A、trade barrier
B、dumping
C、tariff
D、open border
第4题:
When rejecting applied an dependent updates on an AIX 5L system, which of the following procedures is most appropriate to follow?()
第5题:
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
第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
第7题:
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
第8题:
A、to
B、of
C、in
D、on
第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元素。
第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?()