Ensurepass

QUESTION 21

Which of the following is a valid datatype definition?

 

A.

TEXT

B.

CLOB

C.

CHAR(64000)

D.

NUMERIC(1,38)

 

Correct Answer: C

 

 

QUESTION 22

Which statement is true about the groom feature?

 

A.

Groom allows the user to add row level security.

B.

Groom validates primary key constraints on the table.

C.

Groom reorders rows based on the DISTRIBUTE ON clause.

D.

Groom allows the user to reorganizetables based on the ORGANIZE ON clause.

 

Correct Answer: D

 

 

QUESTION 23

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 pg.log file was configured for two minutes.

C.

The runaway query event was configured for two minutes.

D.

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

E.

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

 

Correct Answer: AE

 

 

QUESTION 24

Why is table skew important to manage?

 

A.

Low table skew negatively impacts performance.

B.

High table skew negatively impacts performance.

C.

Low table skew negatively impacts data compression.

D.

Deleted rows consume disk space until they are freed.

 

Correct Answer: B

 

 

QUESTION 25

The PureData System for Analytics implements which level of transaction isolation?

 

A.

Serializable

B.

Committed read

C.

Repeatable read

D.

Uncommitted read

 

Correct Answer: A

 

 

QUESTION 26

Which is a function of the Linux-HA heartbeat?

 

A.

Performsregeneration of failed disks on the hosts.

B.

Manages communication and processes on the S-Blades.

C.

Performs disk partitioning and status of jobs on the S-Blades.

D.

Manages communication and status of services on the hosts.

 

Correct Answer: D

 

 

QUESTION 27

Which statement is true?

 

A.

MATERIALIZED VIEWS can be run against EXTERNAL tables.

B.

GENERATE STATISTICS can be run against EXTERNAL tables.

C.

EXTERNAL table data is deleted using the SQL DELETE command.

D.

EXTERNAL tables can be used to unload data to a Microsoft Windows directory.

 

Correct Answer: D

 

 

 

 

QUESTION 28

Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?

 

A.

sar

B.

nzhw

C.

nzsystem

D.

nzinventory

 

Correct Answer: B

 

 

QUESTION 29

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

 

A.

DROP TABLE TableA

B.

ALTER TABLE TableA

C.

TRUNCATE TABLE TableA

D.

GRANT SELECT ON TableA TO UserA

 

Correct Answer: D

 

 

QUESTION 30

Which is NOT a function that can be performed bynzbackup?

 

A.

Backup data

B.

Backup schemas

C.

Backup users/groups

D.

Backup the /nz/data directory

 

Correct Answer: D

 

Free VCE & PDF File for IBM P2090-050 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.