최신 IBM Information Management P2090-047 무료샘플문제:
1. Which statement is true about optimizer settings?
A) They can be set system wide and at the session level.
B) They can be set system wide only.
C) They can be set at the session and at the group level.
D) They can be set at the database level only.
2. When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)
A) NOT NULL
B) NULL
C) PRIMARY KEY
D) DEFAULT value
E) UNIQUE
3. Which is a function of the Linux-HA heartbeat?
A) Manages communication and processes on the S-Blades.
B) Performs regeneration of failed disks on the hosts.
C) Performs disk partitioning and status of jobs on the S-Blades.
D) Manages communication and status of services on the hosts.
4. When are zonemaps initially created for a table?
A) nzbackup
B) ALTER TABLE ADD ZONEMAPS
C) nzreclaim
D) CREATE TABLE
5. Which statement about the GROOM TABLE feature is true?
A) GROOM TABLE prevents nzload from adding data while groom is in progress.
B) GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.
C) GROOM TABLE requires space to make a complete copy of the table.
D) GROOM TABLE only operates on tables that include an ORGANIZE ON clause.
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: C,E | 질문 # 3 정답: D | 질문 # 4 정답: D | 질문 # 5 정답: B |