CMS专题
名词解释题英译中：Inventory
题目
参考答案和解析
相似问题和答案
第1题：
(b) Show how the adjustments affect:
(i) Closing inventory;
第2题：
A.net income is understated
B.net income is overstated
C.merchandise inventory reported on the balance sheet is overstated
D.cost of merchandise sold is understated
第3题：
A、average method
B、LIFO method
C、FIFO method
D、can not tell without more information
第4题：
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
- A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
- B、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
- C、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
- D、Set binlog_format=MIXED with the – replicate-ignore-temp-table option
- E、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
正确答案:B,E
第5题：
If ending inventory for the year is understated, net income for the year is overstated.()
第6题：
(ii) consignment inventory; and (3 marks)
(ii) Consignment inventory
■ Agree terms of sale to dealers to confirm the ‘principal – agent’ relationship between Pavia and dealers.
■ Inspect proforma invoices for vehicles sent on consignment to dealers to confirm number of vehicles with dealers
at the year end.
■ Obtain direct confirmation from dealers of vehicles unsold at the year end.
■ Physically inspect vehicles sold on consignment before the year end that are returned unsold by dealers after the
year end (if any) for evidence of impairment.
■ Perform. cutoff tests on sales to dealers/trade receivables/vehicle inventory.
■ If goods on consignment are treated as inventory agree their unit costs to be the same as for other vehicles in
inventory.
第7题：
A.can not tell without more ination
B.average
C.LIFO
D.FIFO
第8题：
2 Which of the following are correct?
1. The balance sheet value of inventory should be as close as possible to net realisable value.
2. The valuation of finished goods inventory must include production overheads.
3. Production overheads included in valuing inventory should be calculated by reference to the company’s normal
level of production during the period.
4. In assessing net realisable value, inventory items must be considered separately, or in groups of similar items,
not by taking the inventory value as a whole.
A 1 and 2 only
B 3 and 4 only
C 1 and 3 only
D 2, 3 and 4
第9题：
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.
Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)
A. Configure the hard disks as two mirrored NTFS volumes.
B. Configure the hard disks as one mirrored NTFS volumes.
C. Configure the hard disks as two independent NTFS volumes.
D. Configure the hard disks as one extended NTFS volume.
E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.
F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.
G. Place inventory_data.mdf and inventory_log.ldf on the same volume.
C,E 解析：Explanation: Placing log files and the data files on different physical disks or independent volumes, and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads and thus less seek time.
Note: A Windows 2000 supports basic disks, in which physical disks are divided into partitions, and dynamic disks, in which disks are divided into volumes that can comprise an entire disk, two or more entire disks, portions of a disk, or portions of up to 32 physical disks.
A NTFS volume is volume that is formatted with the NTFS file system. Physical database design involves mapping the logical design onto physical media to allow for the data to be physically accessed and maintained as quickly as possible by taking advantage of the available hardware and software features. It is important to correctly design the database and to take advantage of hardware and software features early in the development cycle of a database application, because making changes to these components at a later stage it is difficult.
Incorrect Answers:
A: For redundancy and fault protection the log file can be placed on a mirrored volume. It would not be a good idea to put data files on a mirrored volume though. Performance when accessing the data would suffer.
Note: A mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. It provides data redundancy as it copies the data on one volume to another volume on a different disk. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk. In such a set up, the data file and the log file will reside on the same drive. This will not improve database performance.
B: A mirrored volume cannot comprise of one volume only. It must comprise of two volumes on separate physical disks as a mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk.
D: Data is written and read sequentially on extended volumes. As a result the data file and the log file will be placed on the same physical disk.
F: In this scenario the data file is separated into a primary data file, that uses the .mdf extension, and a secondary data file, that uses the .ndf extension. However, the secondary data file is placed on the same volume as the log file. This will lead to performance improvements only in cases where data is not read from the secondary data file.
G: Placing the data file and the log file on the same volume will not improve database performance as it will not allow parallel processing.
第10题：
Which statement is true about item records and inventory management？ （）
- A、 With IBM Maximo Asset Management V6.2 （IMAM）， item records are created in the Item Master application， and storeroom records are created in the Storerooms application， but inventory is managed in the Inventory application.
- B、 With IMAM， item records are created in the Storerooms application， and storeroom records are created in the Inventory application， but inventory is managed in the Inventory application.
- C、 With IMAM， item records are created in the Inventory application， and storeroom records are created in the Item Master application， and inventory is managed in the Item Master application.
- D、 With IMAM， item records are created in the Inventory application， and storeroom records are created in the Storerooms application， but inventory is managed in the Item Master application.
正确答案:A