Teradata Administration V2R5

The user receives an error message and is logged on to the next host group ✘ The users connection is refused and the user receives an error message (Correct) ✘ The user does not receive an error message and is logged on to the next hostgroup. ✘ The users connection is refused and the user does not receive an error message ✔

DBC.DiskSpace ✘ DBC.Tables ✘ DBC.SysInfo ✘ DBC.TableSize ✔

A change to MAXSESS only takes effect at TDP startup ✘ The number of sessions is constrained for the TDP ✘ The allowable values must equal a multiple of the PE session limit. ✘ It changes the maximum number of sessions supported by the Teradata server. ✔

on PEs in the same cluster as AMP 0 ✘ on other AMPs in the same cluster as AMP 0 ✘ on other AMPs in the same clique as AMP 0 ✘ on PEs in the same clique as AMP 0 ✔ on all other AMPs in the system ✔

with pairs of drives containing mirrored data ✘ It uses parity to reconstruct the data on a failed drive. ✘ with pairs of AMPs containing mirrored data ✘ It uses parity to reconstruct the data on a failed AMP. ✔

SELECT ✘ WHERE ✘ WITH CHECK OPTION ✘ USING ✔

The users session will have access to 60% of available system resources. ✘ The users session will have access to its owners partition weight %. ✘ The users session will have access to all available system resources. ✘ The users session will have access to 40% of available system resources. ✔ The users session will have access to 40% of all system resources ✔

all-AMP archive ✘ single cluster archive ✘ single-AMP archive ✘ index archive ✔

AMPUsage ✘ ResNode ✘ ResIOView ✘ ResCPUUsageByAMPView ✔

PACK REPEAT SERIALIZE ROBUST