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).
What is required to troubleshoot a query?
A. nzevents and the pg.log.
B. nzsql andthe ODBC config.
C. nzinventory and the dbos.log.
D. nzdumpschema and the execution plan.
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).
The primary copy of a dataslice is spread across how many disks?
A. 1.
B. 2.
C. 4.
D. 12.
Which is NOT a function of the FieldProgrammable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?
A. Projects
B. Restricts
C. Aggregates
D. Decompresses
Which is NOT a way to check if the database is online?
A. nzstate
B. cat /proc/database
C. nzsystem showState
D. nzsql -c "select * from _v_system_info;"
All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
A. GUEST
B. USERS
C. PUBLIC
D. GLOBAL
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
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.
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
A. Turn ODBC tracing ON.
B. Issue "SELECT * FROM _V_SESSION;"
C. Go to the query history within the Windows NzAdmin GUI tool.
D. Run EXECUTION PLAN before the query has been submitted.
E. Issue "SHOW PLANFILE
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-050 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.