Create Next App

Exam contains 131 questions

Page 14 of 22

Question 79 🔥

A user is running Netezza Performance Server Release 7.0.3 on an environment where cross- database access has been enabled. The user sees the following prompt:DEV(ADMIN)=>Which two sets of statements will execute successfully? (Choose two.)

Which database solution meets these requirements?

A. CREATE SEQUENCE prod..seq1;

Highly voted

B. SET CATALOG prod; INSERT INTO emp SELECT * FROM dev..emp;

Highly voted

C. INSERT INTO prod..emp SELECT * FROM emp;

Highly voted

D. INSERT INTO emp SELECT * FROM prod..emp;

Highly voted

E. CREATE MATERIALIZED VIEW emp AS SELECT * FROM prod..emp;

Highly voted

Discussion of the question

Question 80 🔥

What two types of actions can be configured using the NZ Event Manager? (Choose two)

Which database solution meets these requirements?

A. Inserting a row into a table

Highly voted

B. Running a stored procedure

Highly voted

C. Sending an email to a list of addresses

Highly voted

D. Running a command on the active host

Highly voted

E. Sending a Simple Network Message Protocol (SNMP) event

Highly voted

Discussion of the question

Question 81 🔥

What is the maximum supported size of a BLOB in NPS?

Which database solution meets these requirements?

A. 32k bytes

Highly voted

B. 64k bytes

Highly voted

C. 128k bytes

Highly voted

D. BLOBs are not supported. A data warehouse is no place to store such large files

Highly voted

Discussion of the question

Question 82 🔥

Here's an excerpt from a successful query execution plan:Which of the following statements is TRUE?

Which database solution meets these requirements?

A. 3 columns from FREQ_SHOPPER table were broadcast as a temporary table to all SPUs

Highly voted

B. 3 columns from FREQ_SHOPPER table were redistributed in a temporary table named "LINK"

Highly voted

C. 3 columns from FREQ_SHOPPER table were redistributed in a system-managed temporary table

Highly voted

D. 3 columns from FREQ_SHOPPER table were redistributed in a permanent table named "2147517585"

Highly voted

Discussion of the question

Question 83 🔥

In NZPLSQL which of the following statements is TRUE?

Which database solution meets these requirements?

A. If you specify the BEGIN AUTOCOMMIT ON syntax, the procedure executes each statement in the block as a singleton statement with an implied COMMIT after each statement

Highly voted

B. If you specify the BEGIN AUTOCOMMIT OFF syntax, the procedure executes each statement in the block as a singleton statement with an implied COMMIT after each statement

Highly voted

C. If you specify the BEGIN AUTOCOMMIT OFF syntax, the procedure executes each statement in the block as a singleton statement with an implied ROLLBACK after each statement

Highly voted

D. If you specify the BEGIN AUTOCOMMIT ON syntax, the procedure executes each statements the block as a singleton statement with an implied ROLLBACK

Highly voted

Discussion of the question

Question 84 🔥

External tables that only exist for the duration of a single query are known as

Which database solution meets these requirements?

A. Hosted Tables

Highly voted

B. Session Tables

Highly voted

C. Transient External Tables

Highly voted

D. Temp or Temporary External Tables

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_560

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us