Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

P2090-050 Questions and Answers

Note! Following P2090-050 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

P2090-050 Questions and Answers

Question # 6

Which statement is true regarding any database user?

A.

The user has a table spacedefined.

B.

The user can be assigned to more than one group.

C.

The user must have a corresponding host account.

D.

The user can be removed from the default PUBLIC group.

Full Access
Question # 7

What is the maximum number of columns you can choose as organizing keys for clustered base table?

A.

1

B.

2

C.

4

D.

8

Full Access
Question # 8

Which clause CANNOT be used with a CREATE VIEW statement?

A.

SUM ()

B.

GROUP BY

C.

ORDER BY

D.

OUTER JOIN

Full Access
Question # 9

If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

A.

A DELETE from TableA

B.

A SELECT from TableA

C.

A TRUNCATE of TableA

D.

An nzbackup of the database in which TableA resides

Full Access
Question # 10

Which statement is NOT true?

A.

nzbackup backs up selected tables.

B.

nzbackup backs up to a file system destination.

C.

nzbackup backs up to a Veritas NetBackup destination.

D.

nzbackup backs up to a IBM Tivoli Storage Manager destination.

Full Access
Question # 11

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

A.

The number of rows in the table.

B.

The column histogramstatistics.

C.

The number of NULLs in each column.

D.

The number of unique values in each column.

E.

The minimum and maximum column value information (excluding text columns).

Full Access
Question # 12

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.

Full Access
Question # 13

Which condition will interrupt a query running on a fully operational PureDataSystem for Analytics?

A.

One fan fails.

B.

One disk fails.

C.

Active host fails.

D.

One power supply fails.

Full Access
Question # 14

When a temporary table is created, where will the data be stored?

A.

On the host under the /nz/tmp directory.

B.

On the S-Blades under the data partition.

C.

Held in physical memory on the S-Blades.

D.

On the S-Blades under the swap partition.

Full Access
Question # 15

Which of the following is a valid datatype definition?

A.

TEXT

B.

CLOB

C.

CHAR(64000)

D.

NUMERIC(1,38)

Full Access
Question # 16

Which command is used to abort a user's SQL transaction?

A.

kill

B.

abort

C.

nzstop

D.

nzsession

Full Access
Question # 17

Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?

A.

Disk resets or fails.

B.

Host resets or fails.

C.

S-Blade resets or fails.

D.

Snippet Processing Unit (SPU) resets or fails.

Full Access
Question # 18

What is required to troubleshoot a query?

A.

nzevents and the pg.log.

B.

nzsql and the ODBC config.

C.

nzinventory and the dbos.log.

D.

nzdumpschema and the execution plan.

Full Access
Question # 19

What operating system runs ona PureData System for Analytics host?

A.

AIX

B.

SUSE Linux

C.

Nucleus OS

D.

Redhat Linux

Full Access