IBM Information Management C2090-548시험패스는 IT업계종사자들이 승진 혹은 연봉협상 혹은 이직 등 보든 면에서 날개를 가해준것과 같습니다.IT업계는 IBM Information Management C2090-548시험을 패스한 전문가를 필요로 하고 있습니다. Pass4Test의 IBM Information Management C2090-548덤프로 시험을 패스하고 자격증을 취득하여 더욱더 큰 무대로 진출해보세요.
NO.1 What are private buffer pools are used for?
A. KSDSs
B. DEDBs
C. HALDBs
D. OSAM datasets
Answer: B
NO.2 Which of the following options best defines the Label-Based Access Control (LBAC) feature?
A. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the
full qualified name.
B. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by
comparing the security labels between database objects and users.
C. DB2 LBAC monitors table data access and tables modifications made by database users.
D. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.
Answer: B
NO.3 What are DB2 constraints?
A. DB2 constraints are the limits of the database installation when you install and set up your
DB2database.
B. DB2 constraints are rules that can be imposed on data values (in a table) so that they conformto a
certain property or business rule.
C. A DB2 constraint is a limitation in the DB2 Express product designed to make it less powerfulthan
the full DB2 product.
D. A DB2 constraint restricts the tables that can be related together due to database size issues.
Answer: B
NO.4 What is a DB2 transaction?
A. A DB2 transaction is the interface that is developed between tables, relating one table to theother.
B. A DB2 transaction is an action that is performed by the database to ensure that tables that
arereplicated are kept synchronized.
C. A DB2 transaction is a set of rules that can be imposed on data values in a table.
D. A DB2 transaction is a sequence of one or more statements that must complete in its entiretyor
not at all. It is also referred to as a unit of work.
Answer: D
NO.5 Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage
capability?
A. You can use storage groups to implement multi-temperature data management in DB2.
B. Multi-temperature data management reduces the total cost of ownership by allowing efficient
deployment of storage hardware with minimal administrative overhead.
C. Multi-temperature data management integrates with DB2's Workload Manager feature to let you
prioritize your workloads based on the data being accessed.
D. Multi-temperature data management best practices recommend that cold data should be stored
in faster devices in order to maximize overall system performance.
Answer: D
NO.6 What is the output of the Call Image Capture utility (DFSDLTR0)?
A. Trace of module entry/exit during call.
B. Database records retrieved by the program.
C. DFSDDLT0 control statements written to the log.
D. Call counts by type written in x'45' statistics log records.
Answer: C
NO.7 Your IMS System uses dual OLDS logging and the Archive job runs successfully and produces
one SLDS datasets and two RLDS dataset. Archiving will make which changes to RECON Log Records?
A. A PRISLD RECON record is created; the PRILOG record will be updated to include the primarySLDS
dataset name and the SECLOG record will be updated to include the secondary RLDSdataset name.
B. A PRISLD RECON record is created; the PRILOG record will be updated to include the primaryRLDS
dataset name and the SECLOG record will be updated to include the secondary RLDSdataset name.
C. A PRISLD and a SECSLD RECON record are created; the PRILOG record will be updated toinclude the
primary RLDS dataset name and the SECLOG recordwill be updated to include thesecondary RLDS
dataset name.
D. A PRISLD, a PRIRLDS and a SECRLDS RECON record are created; the PRILOG record willbe updated
to include the primary RLDS dataset name and the SECLOG record will beupdated to include the
Secondary RLDS dataset name.
Answer: B
NO.8 Which utility must be used to recreate the primary index for a PHIDAM database?
A. Recovery
B. HISAM Reload
C. Prefix Resolution
D. Index/ILDS Rebuild
Answer: D