A2090-611 무료 덤프문제 온라인 액세스

Which is the suggested way to restore a database with a subset of its original table spaces?

• A.Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
• B.Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
• C.Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.
• D.Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

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_DB database manager configuration parameter for the DEV instance to DISABLE.
• B.Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
• C.Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.
• D.Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.

If the following command is executed:
CREATE DATABASE sample RESTRICTIVE
Which statement is true?

• A.Only the creator is allowed to access the SAMPLE database.
• B.PUBLIC will hold only SELECT privilege on the system catalog views.
• C.No authorities or privileges will be granted to PUBLIC.
• D.The RESTRICT_ACCESS database configuration parameter must be set to YES by the creator.

Which statement is true about Insert Time Clustering (ITC) tables?

• A.ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.
• B.The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.
• C.ITC tables have similar characteristics to MDC tables, except they don't use block indexes.
• D.An existing MDC table can be converted to an ITC table.

Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

• A.DB2AUTH
• B.CLNT_PW_PLUGIN
• C.SRVCON_PW_PLUGIN
• D.DB2LDAP