What are Clustered Base Tables (CBT)?

What are Clustered Base Tables (CBT)?A . Tables that decrease allocated storageB . Tables that contain sorted data using one to four columns.C . Tables that increase pre-sorting of new table records before a loading operation.D . Tables that replicate the base table.View AnswerAnswer: B

January 18, 2022No CommentsREAD MORE +

Which date time format is used to capture history activities?

Which date time format is used to capture history activities?A . system timeB . local timeC . ESTD . GMTView AnswerAnswer: A

January 18, 2022No CommentsREAD MORE +

What ap cli command is used to disable a node?

What ap cli command is used to disable a node?A . ap node power offB . ap node set__personality failC . ap stopnodeD . ap node disableView AnswerAnswer: D

January 18, 2022No CommentsREAD MORE +

What is the correct way to optimize this query without modifying the column?

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char (5| They frequently restrict on this column, but the query is very inefficient. What is the correct way to optimize this query without modifying the column?A . Create a copy of FACT_SALES...

January 18, 2022No CommentsREAD MORE +

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?A . onlineB . runningC . stoppedD . pausedView AnswerAnswer: C

January 17, 2022No CommentsREAD MORE +

Which two commands can be used to get a plan file for a query?

Which two commands can be used to get a plan file for a query?A . nzsql -c "show planfile <planid>"B . nzsql -c "select plan_text from _v_plan"C . nzsql -c "get planfile <planid>"D . nz_get <planid>E . nz_plan <planid>View AnswerAnswer: A,D

January 17, 2022No CommentsREAD MORE +

When computing the row size for a table row, what overhead should be accounted for?

When computing the row size for a table row, what overhead should be accounted for?A . 48 bytes for ROWID, CREATEXID and DELETEXID onlyB . 32 bytes for ROWIC . CREATEXID, DELETEXID and the null vectorD . 32 bytes for ROWIE . CREATEXID and DELETEXID and a variable number of...

January 16, 2022No CommentsREAD MORE +

Which log file provides a DBA with an actual SQL statement that was executed?

Which log file provides a DBA with an actual SQL statement that was executed?A . clientmgr.logB . pg.logC . sysmgr.logD . dbos.logView AnswerAnswer: C

January 15, 2022No CommentsREAD MORE +

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?A . _v_sched_graB . _v_system_utilC . _v_qryhistD . _v_plan_resourceView AnswerAnswer: D

January 15, 2022No CommentsREAD MORE +

What access is required to create a new user in IBM Netezza Performance Server?

What access is required to create a new user in IBM Netezza Performance Server?A . An account with NEW USER administrative privilegeB . An account with CREATE USER administrative privilege.C . An account with CREATE GROUP access on the host OE . An account with CREATE ID access on the...

January 14, 2022No CommentsREAD MORE +