IT업계의 치열한 경쟁속에 살아 남으려면 자신의 능력을 증명하여야 합니다. 국제승인을 받는 IT인증자격증을 많이 취득하시면 취직이든 승진이든 이직이든 모든 면에서 이득을 볼수 있습니다. 최근 IBM Information Management C2090-548시험에 도전하는 분이 많은데 Pass4Test에서 IBM Information Management C2090-548시험에 대비한 가장 최신버전 덤프공부가이드를 제공해드립니다.
NO.1 Each database has its own system catalog tables and views. These store metadata about the
database objects. You can query them just like any other tables or views. Which of the following are
some of the system catalog tables?
A. SYSLOAD, SYSALL, and SYSPASS
B. SYSSTART, SYSBACKUP, and SYSOPEN
C. SYSMANAGEMENT, SYSCREATE, and SYSSTORE
D. SYSIBM, SYSCAT, and SYSSTAT
Answer: D
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 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.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 CORRECT about DB2 pureScale feature?
A. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.
B. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary
database to a standby database.
C. DB2 pureScale persists data in the cluster caching facilities (CFs).
D. DB2 pureScale reduces the risk and cost associated with growing your distributed database
solution by providing extreme capacity and application transparency.
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 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
NO.8 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