TeraData NR0-014 Exam
NR0-014 Teradata Administration v2r5 Exam (Page 2 )

Updated On: 12-Feb-2026

Which statement is true about the TDP command SET MAXSESS?

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

Answer(s): A



What enables logons to the RDBMS via the gateway?

  1. RUN GTW
  2. ENABLE GTW
  3. ENABLE LOGONS
  4. START SESSIONS

Answer(s): C



What are two benefits of session pools? (Choose two.)

  1. Logon times are typically 2-3 seconds faster.
  2. The number of sessions a user can log on is controlled.
  3. They allow better tracking of when applications log on and log off.
  4. If all sessions are active, the next pool is used regardless of the logon string.

Answer(s): A,B



What happens when a host group's session limit is exceeded and another user tries to log on?

  1. The user's connection is refused and the user receives an error message.
  2. The user's connection is refused and the user does not receive an error message.
  3. The user receives an error message and is logged on to the next host group.
  4. The user does not receive an error message and is logged on to the next host group.

Answer(s): A



What are two effective ways of limiting the growth of the AccessRights table? (Choose two.)

  1. assign users to one or more roles
  2. grant all privileges at the database level
  3. grant all necessary privileges to each user on individual database objects
  4. ensure that all users belong to a profile and inherit the profile's access rights

Answer(s): A,B






Post your Comments and Discuss TeraData NR0-014 exam prep with other Community members:

Join the NR0-014 Discussion