|
Question 1.
Physical files contain two components, one of which is data.
Which of the following is the other?
A. Journal
B. Catalog
C. Primary key
D. File description
Answer: D
Question 2.
The development staff has asked the system administrator to create an Encoded Vector Index (EVI) over several database tables.
Which of the following will create the EVI?
A. CREATE INDEX index_name ENCODED VECTOR ON TABLE_NAME
B. CRTLF FILE(index_name) SRCFILE(SRCLIB/SRCFILE) OPTION(*EVI)
C. CRTEVI FILE(index_name) SRCFILE(SRCLIB/SRCFILE) OPTION(*ASC)
D. In Operations Navigator, Database, Index, use the create index wizard.
Answer: A
Question 3.
Which of the following will ensure that parent/foreign key relationships are maintained?
A. Database view
B. Database index
C. Commitment control
D. Referential constraint
Answer: D
Question 4.
During a disaster test, the restore job log shows several logical files that did not restore. A display of the SAVE 21 tape shows the logical files are on the tape.
Why did the logical files not restore during the RESTORE 21?
A. The owner's user profile was not restored to the system first.
B. The option for restoring the files to a different system was not selected.
C. The operating system version is not the same as the version on the system from which they
were saved.
D. The logical files are in a library that was restored before the library containing the physical
files.
Answer: D
Question 5.
Which of the following is a characteristic of unique primary keys?
A. They will not allow null values.
B. They consist of only one column.
C. They are mandatory for all physical files.
D. They must consist of column(s) in the lowest ordinal position(s).
Answer: A
Question 6.
An application has been developed that will update several files during the completion of a single transaction. If the entire transaction does not complete successfully, all changes made during the transaction need to be removed.
Which of the following will automate the process?
A. SQL package
B. Commitment control
C. Database journaling
D. Referential constraint
Answer: B
Question 7.
Which of the following command lists provides the most complete backup of the system?
A. SAVSYS, SAVLIB(*NONSYS), SAVDLO, SAV
B. SAVLIB(*IBM), SAVLIB(*ALLUSR), SAVDLO, SAV
C. SAVLIB(*IBM), SAVLIB(*ALLUSR), SAVSECDTA, SAVCFG, SAVDLO
D. SAVSYS, SAVSECDTA, SAVCFG, SAVLIB(*IBM), SAVLIB(*ALLUSR)
Answer: A
Question 8.
What is the effect of specifying the MBROPT(*MATCH) parameter on the restore object command?
A. All members are restored if all of the member names match the saved member names.
B. Only the member names matching the pattern on the member parameter will be restored.
C. All members from the save media will be restored if one of the member names matches a
member in the file.
D. Members on the save media that match a member in the file will be restored. Members on the
save media that do not match a member in the file will not be restored.
Answer: A
Question 9.
When using either the Backup menu or iSeries Navigator, which of the following can be saved with a backup list?
A. User libraries, IBM product libraries, folders, and directories
B. IBM libraries, Operating system, security objects, and configuration objects
C. User libraries, directories, folders, security objects, and configuration objects
D. User libraries, IBM product libraries, Operating system, directories, and configuration objects
Answer: C
Question 10.
As part of an overall backup and recovery strategy, a system administrator is using journaling on the database.
Under these conditions, which of the following will be saved using the default parameters of the save changed objects (SAVCHGOBJ) command?
A. All objects changed since the last full save.
B. All objects changed since the last SAVCHGOBJ command.
C. All objects changed since the last full save, except for journaled objects.
D. All objects changed since the last SAVCHGOBJ command, except for journaled objects.
Answer: C
|
Question 1 Which of the following fields are required when creating an item? Mark all that apply. A. U of M Schedule B. Item Description C. Price Group D. Default Accounts Answer: A,B Question 2 In which of the following situations can a purchase order be created in the Sales Transaction Entry window? Mark all that apply. A. An item on an order has a quantity to back order B. An item is defined as a drop-ship item on an order C. An item hasn't been allocated yet on an order D. An item exists on a back order document Answer: A,B,D Question 3 When activating Purchase Order Commitments in the PO Enhancements window, how many budget IDs can be used for each year to verify that the purchase is not over budget? A. 4 B. 1 C. 3 D. 2 Answer: B Question 4 Which of the following is a characteristic of an expired quote? A. The system will issue a warning that the quote is expired, but can still be transferred to an order or invoice. B. The quote amount will be increased by a percentage defined in Sales Order Processing Setup. C. The quote is automatically removed from the Sales Transaction Entry window. D. The quote cannot be transferred to an order or invoice. Answer: D Question 5 What setups are required in other modules prior to using Sales Order Processing? Mark all that apply. A. Account Numbers in General Ledger B. Items in Inventory C. Setup in Purchase Order D. Customers in Receivables Management Answer: A,B,D Question 6 For this sale only, the customer would like the goods shipped to a "one time only" address. If the address hasn't been created what is the most efficient way to change the "Ship To" address for this document only? A. With the document open in Sales Transaction entry, change the default site ID. B. With the document open in Sales Transaction entry, open the customer expansion button, zoom back to the customer master "Ship To" address and change the address. C. With the document open in Sales Transaction entry, open the customer expansion button and select another existing address ID on the "Ship To" field. D. With the document open in Sales Transaction entry, open the customer expansion button and change the address under the "Ship To" address expansion button. Answer: D Question 7 Which of the following are valid transactions in the Item Transfer Entry window? Mark all that apply. A. Item transferred from Inventory to Bill of Material for manufacturing B. Item transferred from the NORTH site to the SOUTH site C. Item transferred from the NORTH site, with a quantity status of On-Hand, to the SOUTH site, with a quantity status of Damaged D. Item transferred from a quantity status of On-Hand to Damaged Answer: B,C,D Question 8 A item is entered on a quote with the following quantities: Qty Quoted: 10, Qty to Invoice: 0, Qty to Order: 10. What is the result when transferring the quote to an invoice? A. An order is created for 10 items. B. An invoice is created for 10 items. C. The quote remains with 0 items. D. The quote remains with 10 items. Answer: D Question 9 You can enter Purchase Order Processing returns against which of the following? A. Cancelled Purchase Orders B. On- Hold Purchase Orders C. Drop-ship Purchase Orders D. Inventory receipts Answer: D Question 10 Which of the following are item types? Mark all that apply. A. Sales Inventory B. Flat Fee C. Finished Good D. Kit Answer: A,B,D
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.