Ensurepass

QUESTION 81

Which two commands can be used to shut the database system down? (Choose two.)

 

A.

nzstop

B.

nzdown

C.

nzhw stop

D.

nzsystem stop

E.

service halt nps

 

Correct Answer: AD

 

 

QUESTION 82

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.

 

Correct Answer: A

 

 

QUESTION 83

A table, TableA has one column, ColumnA. Thefollowing query can be used to determine the skew of Table A.

 

A.

Select distinct (ColumnA) from TableA;

B.

Select distinct(datasliceid) from TableA;

C.

Select datasliceid, count(*) from TableA group by 1 order by 2;

D.

Select ColumnA, count(*) from TableA group by ColumnA order by 2;

 

Correct Answer: C

 

 

QUESTION 84

Which will result in support for zonemaps on the LastName column?

 

A.

CREATE TABLE TableA (LastName VARCHAR(20));

B.

CREATE TABLE TableA (LastName VARCHAR(20));

ALTER TABLE TableA ZONEMAP ON (LastName);

C.

CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

D.

CREATE TABLE TableA (LastName VARCHAR(20));

CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;

 

Correct Answer: D

 

QUESTION 85

Which statement about theGROOM TABLE feature is true?

 

A.

GROOM TABLE requires space to make a complete copy of the table.

B.

GROOM TABLE only operates on tables that include an ORGANIZE ON clause.

C.

GROOM TABLE prevents nzload from adding data while groom is in progress.

D.

GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.

 

Correct Answer: D

 

 

QUESTION 86

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

 

Correct Answer: C

 

 

QUESTION 87

What are two considerations for usage of materialized views? (Choose two)

 

A.

Materialized views are not supported.

B.

Materialized views are logical entities.

C.

Materialized views may improve query performance.

D.

Materialized views are the same as database views.

E.

Materialized views are considered for usage by the Optimizer.

 

Correct Answer: CE

 

 

QUESTION 88

What is nzconvert usedfor?

 

A.

To convert compressed external tables into ASCII text.

B.

To convert between character encodings before loading data.

C.

To translate stored procedures into NZPLSQL compatible syntax.

D.

To upgrade/downgrade the database to a different software version.

 

Correct Answer: B

 

 

QUESTION 89

What must the Linux administrator ensure when creating a Linux user on the host?

 

A.

The user account is provided super-user privileges.

B.

The user account exists in the LDAP authentication server.

C.

The user account password is at least 8 characters in length.

D.

The user account iscreated on the active and standby server.

 

Correct Answer: D

 

 

QUESTION 90

What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

 

A.

Both tables have primarykeys defined.

B.

Both join columns have the same name.

C.

Both tables must be distributed on random.

D.

Both join columns have identical data types.

E.

Both tables must be distributed on their join column.

 

Correct Answer: DE

 

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.