Free IBM P2090-047 Exam Dumps Questions & Answers

What is the function of the Distributed Replicated Block Device (DRBD)?

• A.Work Load Management
• B.Load Balancing
• C.High Concurrency
• D.High Availability

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

• A.Set show_plan = true;
• B.Use pg.log file.
• C.Use explain.
• D.Use statistics.

What is nzconvert used for?

• A.To convert compressed external tables into ASCII text.
• B.To translate stored procedures into NZPLSQL compatible syntax.
• C.To upgrade/downgrade the database to a different software version.
• D.To convert between character encodings before loading data.

Which statement is true about optimizer settings?

• A.They can be set at the session and at the group level.
• B.They can be set system wide only.
• C.They can be set system wide and at the session level.
• D.They can be set at the database level only.

Which nzload operation statement is correct?

• A.nzload must be run from the PureData System for Analytics host.
• B.nzload performs singleton inserts.
• C.nzload must have a control file.
• D.nzload user must have CREATE EXTERNAL TABLE privilege.