The following are true about the Configuration Advisor, EXCEPT:
A. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
B. It creates database objects such as indexes and MQTs to improve performance.
C. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
D. By default, the Configuration Advisor is automatically executed when you create a new database.
正解:B
質問 2:
What is a DB2 instance?
A. A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.
B. A DB2 instance is just another name for DB2 Database.
C. DB2 does not use instances. It requires only databases to operate.
D. A DB2 instance is a copy of a database that can be accessed standalone from the database server.
正解:A
質問 3:
Which of the following is TRUE about PL/SQL support in DB2?
A. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.
B. PL/SQL support is only enabled when using federation to access other vendor databases.
C. You can only execute PL/SQL statements using the CLPPIus interface.
D. DB2 requires third party software to execute PL/SQL statements.
正解:A
質問 4:
Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A. Temporal tables provide a quick and easy way to track and record data changes in the table.
B. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
C. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
D. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
正解:B
野口** -
有難いP2090-018問題集です。P2090-018試験合格に向けて使っていきたいです