Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)
A. The number of unique values in each column.
B. The column histogram statistics.
C. The number of NULLs in each column.
D. The number of rows in the table.
E. The minimum and maximum column value information (excluding text columns).
正解:D,E
質問 2:
nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, such as categories, cohorts, and levels to be backed up/restored?
A. -all
B. -globals
C. -mls
D. -users
正解:B
質問 3:
What is a benefit of Clustered Base Tables?
A. Materializes on disk joins between tables.
B. An alternate way to order a table's data.
C. Increases the performance of load operations.
D. Replicates base table data.
正解:B
質問 4:
Which statement is true regarding the compress engine?
A. Compression is performed by the host.
B. Compression degrades data scan speeds.
C. Compression ratio is data dependent.
D. Compression is performed by the SAS switches.
正解:C
質問 5:
What is required to troubleshoot a query?
A. nzdumpschema and the execution plan.
B. nzinventory and the dbos.log.
C. nzevents and the pg.log.
D. nzsql and the ODBC config.
正解:A
質問 6:
Which statement is true about the groom feature?
A. Groom validates primary key constraints on the table.
B. Groom allows the user to add row level security.
C. Groom reorders rows based on the DISTRIBUTE ON clause.
D. Groom allows the user to reorganize tables based on the ORGANIZE ON clause.
正解:D
質問 7:
All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
A. GLOBAL
B. GUEST
C. PUBLIC
D. USERS
正解:C
Saitou -
素晴らしい問題集に出会いさせてもらったIBMに感謝しかないです。P2090-047にやっと再受験して合格だよ!!早速次に受験したい000-M45の問題集を購入させていただきました。今回もいい結果が出そう。