You havecreated a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to GroupA.
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
When a CREATE TABLE AS (CTAS) is performed on a table creating morethan 1,000,000,000 rows, which statement is true?
A. Groom will be automatically invoked.
B. Primary key constraints will be checked.
C. Statistics will automatically be generated.
D. Materialized views will be automatically generated.
What is the host Linux file that must be modified to adjust optimizer settings permanently?
A. /nz/data/postgresql.conf
B. /nz/data/config/system.cfg
C. /nz/kit/sys/initTopology.cfg
D. /nz/kit/log/sysmgr/sysmgr.log
Which statement is true about the groom feature?
A. Groom allows the user to add row level security.
B. Groom validates primary key constraints on the table.
C. Groom reorders rows based on the DISTRIBUTE ON clause.
D. Groom allows the user to reorganizetables based on the ORGANIZE ON clause.
Why is generating statistics on a table important to query performance?
A. The table statistics are used to facilitate disk space reclamation of deleted rows.
B. The optimizer uses statistics to determine the optimal execution plan for queries.
C. The Zone Map information cross references the table statistics for each column to avoid scanning.
D. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.
What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table TableA.
B. If there are any active selects running against the table TableA.
C. If there are any active nzloads running againstthe table TableA.
D. If there are any active updates running against the table TableA.
What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)
A. The views on TableA.
B. The privileges on TableA.
C. The distribution key of TableB.
D. The materialized views on TableB.
E. The order of the data stored in TableB.
Which command is used to abort a user's SQL transaction?
A. kill
B. abort
C. nzstop
D. nzsession
Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?
A. sar
B. nzhw
C. nzsystem
D. nzinventory
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
A. root
B. public
C. admin
D. system
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.