최신 IBM Information Management C2090-548 무료샘플문제:
1. What is a table space in DB2?
A) A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data asit is read from the physical media.
B) A table space is a logical storage grouping that can be composed of one or more containers.
C) A table space is a space reserved for catalog tables and base table data.
D) A table space is a DB2 component that manages access to databases.
2. A client wants to Decommission an Oracle 9i application and an IMS application. They need to store the data in a central location. They will be accessing the data from various applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success?
A) an AIX Server, Windows Desktop, and Optim DRA
B) Optim TDM, DP, and Archive with ODM/Optim Connect
C) a Sun Solaris Server and Multiple Windows Desktops with Rhumba
D) Optim Data Growth with ODM/Optim Connect
3. What information is NOT included as part of a DB PCB returned to an application program?
A) Segment Length
B) Database Name
C) Status Code
D) Segment Name
4. What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A) STMM allows DBAs to inspect the current memory allocation by buffer pools.
B) This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
C) This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
D) The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
5. What are DB2 constraints?
A) A DB2 constraint restricts the tables that can be related together due to database size issues.
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) DB2 constraints are the limits of the database installation when you install and set up your DB2database.
질문과 대답:
질문 # 1 정답: B | 질문 # 2 정답: D | 질문 # 3 정답: A | 질문 # 4 정답: B | 질문 # 5 정답: B |