Ensurepass

QUESTION 51

Which statement is true for database users and groups?

 

A.

All users must belong to admin group.

B.

Creation of users and groupsis not allowed.

C.

Users and groups are local and tied to a particular database.

D.

Users and groups are global and not tied to a particular database.

 

Correct Answer: D

 

 

QUESTION 52

Which High-Avail
ability (HA) mechanism is used by the PureData System for Analytics Appliance?

 

A.

AIX-HA

B.

Linux-HA

C.

SuSE-HA

D.

Solaris-HA

 

Correct Answer: B

 

 

 

 

QUESTION 53

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

 

A.

From a User Defined Function.

B.

From a JDBC application networked to the system.

C.

From nzsql on an AIX machine networked to the system.

D.

From nzsql on Microsoft Windows networked to the system.

 

Correct Answer: B

 

 

QUESTION 54

The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?

 

A.

The typical or most common types of queries.

B.

The longest and shortest running queries on the system.

C.

The queries submitted by specific users or groups of users.

D.

The rotational speed of the disk drives during query execution.

 

Correct Answer: D

 

 

QUESTION 55

Which statement is true?

 

A.

All user space is available for database expansion.

B.

Each database is assigned it’s own section of disk space.

C.

When creating the database you can specify which disks to use.

D.

When you create a database you can set the maximum space it is allowed to use.

 

Correct Answer: A

 

 

QUESTION 56

When creating a table, you can specify a column constraint for each individual column of either “NULL” or “NOT NULL”. When column values are later evaluated within a query statement, which of these is true?

 

A.

0 is equal to null, the empty string ( ” ) is equal to null.

B.

0 is equal to null, the empty string ( ” ) is not equal to null.

C.

0 is not equal to null, the empty string ( ” ) is equal to null.

D.

0 is not equal to null, the empty string ( ” ) is not equal to null.

 

Correct Answer: D

 

 

QUESTION 57

What will occur when two tables are joinedtogether and the data is NOT collocated?

 

A.

No data movement is required.

B.

A merge join operation will be performed.

C.

A cluster based join method is performed.

D.

Data is dynamically redistributed or broadcasted.

 

Correct Answer: D

 

 

QUESTION 58

When a CREATE TABLE AS (CTAS) is performed on a table creating morethan 1,000,000,000 rows, which statement is true?

 

A.

Groom will be automatically invoked.

B.

Primary key constraints will be checked.

C.

Statistics will automatically be generated.

D.

Materialized views will be automatically generated.

 

Correct Answer: C

 

 

QUESTION 59

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

 

A.

The views on TableA.

B.

The privileges on TableA.

C.

The distribution key of TableB.

D.

The materialized views on TableB.

E.

The order of the data stored in TableB.

 

Correct Answer: CE

 

 

QUESTION 60

When is the ToplogyImbalance event triggered?

 

A.

When a SAS switch has failed.

B.

When the path the path between an S-Blade and its disks has failed.

C.

When a disk enclosure’s voltage sensor is reading outside the nominal range.

D.

When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

 

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.