| State whether the following statement is true or false?
|
| |
| | Choice 1 | True |
| | Choice 2 | False |
| 2 | How are different versions of GDG named ? | |
| | Choice 1 | base-file-name.GnnnnnV00 |
| | Choice 2 | GnnnnnV00.ase-file-name |
| | Choice 3 | base-file-name(nnn) |
| | Choice 4 | None of the options listed for this question |
| 3 | During processing of a VSAM file, some system error occurs and it is subsequently unusable.
| |
| | Choice 1 | Run VERIFY |
| | Choice 2 | Restart |
| | Choice 3 | Run REPAIR |
| | Choice 4 | None of the options listed for this question |
| 4 | Choose the correct one. | |
| | Choice 1 | Record in a KSDS file cant be deleted. |
| | Choice 2 | Record in a ESDS file can’t be deleted. |
| | Choice 3 | Record in a ESDS file can’t be rewritten. |
| | Choice 4 | None of the other options listed for this question. |
| 5 | Recordsize (80,100) denotes | |
| | Choice 1 | Record of Fixed Record length |
| | Choice 2 | Record Variable Record length |
| | Choice 3 | Depends on the type of VSAM dataset viz. KSDS, RRDS, ESDS. |
| | Choice 4 | None of the other options listed for this question. |
| 6 | State whether the following statement is TRUE or FALSE
| |
| | Choice 1 | True |
| | Choice 2 | False |
| 7 | VSAM file-status 23 is | |
| | Choice 1 | Duplicate record condition |
| | Choice 2 | End of file condition reached |
| | Choice 3 | Record Not found condition |
| | Choice 4 | Out of Space condition reached |
| 8 | How does the current generation be referred ? | |
| | Choice 1 | Filename(1) |
| | Choice 2 | Filename(-) |
| | Choice 3 | Filename(0) |
| | Choice 4 | None of the options listed for this question |
| 9 | How do you load a VSAM data set with records ? | |
| | Choice 1 | Using the REUSE command. |
| | Choice 2 | Using the LOAD command. |
| | Choice 3 | Using the REPRO command. |
| | Choice 4 | None of the options listed for this question |
| 10 | Identify the point that is NOT true w.r.t. CI and CA splits in a VSAM file? | |
| | Choice 1 | A Control Interval (CI) split occurs if there is insufficient free space available in the CI for a new record (or to extend an existing record). A Control Area (CA) split occurs if there are no free CI's within a CA. |
| | Choice 2 | When a CI split occurs,one of the free CI's within the same CA will be used. |
| | Choice 3 | When a CA split occurs,the new CA is allocated at the end of the existing allocated space, otherwise secondary allocation takes place and the split CA is placed in the secondary extent. |
| | Choice 4 | None of the above |
| 11 | Identify the point that is NOT true w.r.t. FileMaxx VSAM Transparency Facility (VTF) | |
| | Choice 1 | Most reads and updates are performed randomly (as is typically the case in e-commerce and online transaction processing systems). |
| | Choice 2 | Batch programs that must read entire VSAM files sequentially are already, or can easily become, insensitive to the order in which records are returned. |
| | Choice 3 | Each VSAM file may consist of many different kinds (or types) of records, each having a different record length. However, all records of the same type have the same, or nearly the same, length. |
| | Choice 4 | None of the above |
| 12 | The following point(s) is/are true w.r.t. Record Level Sharing(RLS) in VSAM | |
| | Choice 1 | RLS addresses physical data integrity issues, such as read consistency, record locking and system logging. But it does not address logical issues, such as enforcement and protection of "business" or "integrity" rules. |
| | Choice 2 | Under RLS, VSAM retains most of its functional limitations. VSAM does not support multiple-field composite keys, multiple-valued keys, NULL-suppressed keys, and/or non-unique alternate indexes with unlimited occurrences of the same key value. Each VSAM index remains confined to a single base cluster, and cannot extend across cluster boundaries. |
| | Choice 3 | Under RLS, VSAM retains an underlying architecture that is not appropriate for relational/SQL processing. Although third party products allow SQL queries of VSAM files, VSAM itself is not well suited to such queries. |
| | Choice 4 | All the above |
| 13 | The following procedure can be used for renaming a VSAM file in z/OS | |
| | Choice 1 | RENAME - SYSED.MYNAME.DATA.CLUSTER -
|
| | Choice 2 | ALTER - SYSED.MYNAME.DATA.CLUSTER -
|
| | Choice 3 | ALTER - SYSED.MYNAME.DATA.CLUSTER -
|
| | Choice 4 | ALTER - SYSED.MYNAME.DATA.CLUSTER -
|
| 14 | The command that is used to keep the HURBA in sync between the catalog entry for the VSAM dataset and the VSAM cluster is:- | |
| | Choice 1 | VERIFY |
| | Choice 2 | CHECK DATA |
| | Choice 3 | Done automatically by the system |
| | Choice 4 | None of the other options listed for this question. |
| 15 | In which of the following scenarios "result-level" locking can be applied? | |
| | Choice 1 | A bank typically does not accept transactions that withdraw money from non-existent accounts. |
| | Choice 2 | A vendor typically does not honor orders placed by fictitious customers for merchandise the vendor does not provide. |
| | Choice 3 | A company may delete a customer only if it has no outstanding unpaid invoices. |
| | Choice 4 | All the above |
