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

	Web www.certsbraindumps.com