- All Exams Instant Download
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
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
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
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...
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
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
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...
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
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
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...