最新的IBM Information Management認證 P2090-050考試題庫

問題1

What is the naming convention for system views?

A. sys_v_...

B. _$v_...

C. nz_v_...

D. _v_...

正確答案: D

問題2

In order to set a runaway query event totrigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

A. The runaway query event was enabled.

B. The runaway query event was configured for two minutes.

C. The pg.log file was configured for two minutes.

D. The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.

E. The nzsystem command was used to set the QUERYTIMEOUT to two minutes.

正確答案: A,D

問題3

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

A. system

B. public

C. admin

D. root

正確答案: C

問題4

Which statement describesadministrative privileges?

A. Gives additional storage to select members of the administrator group.

B. Provides audit functionality for the database.

C. Manages resource allocations for concurrent processing.

D. Gives permission to execute global operations and to create objects.

正確答案: D

問題5

Which CREATE DATABASE attributes are required?

A. Thedatabase name and the table space name.

B. The database name and the temporary table space name.

C. The database name and the redo log file name.

D. The database name.

正確答案: D

問題6

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

A. A maximum of 80% of resources when no other users are on the system.

B. A maximum of 100% of resources when no other users are on thesystem.

C. A maximum of 20%of resources when other users are on the system.

D. A maximum of 50% of resources when other users are on the system.

正確答案: A

問題7

Which statement is NOT true regarding the nzload utility?

A. nzload runs on SuSE Linux.

B. nzload runs on the PureData System for Analytics host.

C. nzload blocks update/delete against the target table.

D. nzload runs on windows.

正確答案: C

問題8

When doing a CREATE SEQUENCE, the largest "maximum value" is based onwhat?

A. NUMERIC(38,0)

B. FLOAT8

C. VARCHAR(256)

D. BIGINT

正確答案: D

問題9

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource groupeach execute 1 job at the same time, which statement is correct?

A. Each job gets 25% and both run at the same time.

B. Each job gets 50% and both run at the same time.

C. Each job gets 50% but only one job runs at a time.

D. You cannot set the job maximum per resource group.

正確答案: C

最新的IBM PureData System for Analytics Technical Mastery Test v1 - P2090-050免費考試真題

最新更新

站內鏈接

聯系我們