IBM A2090-611 시험 개요:

IBM A2090-611 시험 요강 주제:

최신 IBM Certified Database Administrator A2090-611 무료샘플문제

문제 #1
Table TAB_A resides within table space TBSP_1.

Which statement is correct?

A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.
B. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
C. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
D. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.

문제 #2
You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

A. Alter the view and add the WITH CHECK OPTION clause to the view definition.
B. Alter the view and add the ENFORCE SELECT clause to the view definition.
C. Drop and recreate the view with the WITH CHECK OPTION clause specified.
D. Create a new view with the same name and the ENFORCE SELECT clause specified.

문제 #3
A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

A. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.
B. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
C. Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.
D. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.

문제 #4
Which statement about primary keys is true?

A. A primary key accepts one, and only one, NULL value.
B. A table can have multiple primary keys.
C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.
D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

문제 #5
What is an informational constraint?

A. A constraint that defines a relationship to a federated object.
B. A constraint that provides Information to the RUNSTATS utility.
C. A constraint that is created from information supplied to the design advisor.
D. A constraint that is used by the optimizer but is not enforced.

질문과 대답: