০১। Which isolation level does a database without logging default to?
ক) committed read
খ) dirty read
গ) mode ANSI
ঘ) repeatable read
০২। Which of the following is required for the DB2 optimizer to consider a hash join strategy?
ক) Optimization level 1 or above
খ) Equijion predicates
গ) Registry variable DB_ANTIJOIN=YES
ঘ) SORTHEAP large enough to contain the tables being joined
০৩। A VM/VSE customer wants to implement a WAS on an existing zSeries server. On which of the following operating environments would WAS best be implemented?
ক) VSE
খ) z/VM
গ) z/OS
ঘ) Linux
০৪। Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?
ক) Create a read?only view using TAB1.
খ) Alter TAB1 to add a check constraint.
গ) Define a primary key or unique constraint on TAB1.
ঘ) Define a dependent table where TAB1 is the parent.
০৫। How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?
ক) on same disk in different modules
খ) on disks in other modules
গ) on different disks in the same module
ঘ) on same disk, in same module, and in different modules
০৬। If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?
ক) committed read
খ) repeatable read
গ) share read
ঘ) indexed read
০৭। Proxy servers have two main purposes : 1. Improve Performance (and) 2. is ______ ?
ক) Transmit Request
খ) Decrease Requests
গ) Increase Requests
ঘ) Filter Requests
০৮। Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition?
ক) /var/log/messages
খ) /proc/startup
গ) /usr/sbin/log
ঘ) /etc/boot
০৯। Suppose a customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?
ক) Use OS/400 VNC support.
খ) Telnet to the virtual console.
গ) Share the primary partitions console.
ঘ) Allocate a console IOA to the Linux partition.
১০। Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe.Which of the following addresses this issue?
ক) GDPS
খ) TAM
গ) DR
ঘ) WASS
১১। Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?
ক) AD Tools
খ) CP3000
গ) Estimate the AIX load and add to CP3000 results.
ঘ) Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ
১২। The DBA can set the registry variable DB2_HASH_JOIN on or off because:
ক) hash joins may require more resources to run.
খ) hash joins are not used unless outer joins are requested.
গ) If hash joins are enabled, no other join method can be used.
ঘ) Hash joins are only needed when the tables are portioned using hash keys.
১৩। What help ensure that the XIV Systems cache does not become a bottleneck?
ক) central cache locking mechanism
খ) use of industry standard chip technology
গ) each module is responsible for caching the data in that module
ঘ) having all modules understand what is held cache at all times
১৪। What is a chunk when using raw devices?
ক) a dynamic unit of disk space
খ) a location in shared memory
গ) a contiguous unit of disk space
ঘ) a data table
১৫। What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?
ক) XIV firmware V10.0.8
খ) Host Attachment Kit V1.0.1
গ) SAN Volume Controller (SVC)V4.2
ঘ) Virtual I/O Server (VIOS) V2.1.1
১৬। Where is fragment information stored?
ক) in the physical logs
খ) in the reserved pages
গ) in the system catalog tables
ঘ) in the first page of the database tblspace
১৭। Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?
ক) SQLDAS after their cursor is closed.
খ) Referential integrity maps after a join.
গ) Stored procedure processes after they are run.
ঘ) Tables after they have been read into the buffer pool.
১৮। Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
ক) The Linux command mt
খ) The Linux command cpio
গ) The OS/400 command RST option(*print)
ঘ) The OS/400 command DSPTAP option(*savrst)
১৯। Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?