Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. NR0-014

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

Updated On: 12-Feb-2026
Page 3 of 21
PDF with 100 Questions

What default value is assigned as the user's default database if no value is specified in the user's profile parameter or the CREATE USER statement?

  1. a NULL value
  2. database DBC
  3. the user's username
  4. the default database of the user's parent

Answer(s): C



Which two statements are true about ownership privileges? (Choose two.)

  1. They must be explicitly granted.
  2. They cannot be explicitly revoked.
  3. They cannot be taken away unless ownership is transferred.
  4. They can be explicitly revoked by the Database Administrator.

Answer(s): B,C



Which statement removes the profile Acct_User from UserA?

  1. DROP USER UserA;
  2. MODIFY USER UserA AS PROFILE=NULL;
  3. REMOVE USER UserA FROM PROFILE Acct_User;
  4. MODIFY PROFILE Acct_User AS ACCOUNT=NULL;

Answer(s): B



The database administrator created User A and assigned that user 90 MB of spool. A month later, the database administrator creates Profile B with 50 MB of spool. User A is then assigned to Profile B. Which system view would you use to determine how much spool User A now has access to?

  1. DBC.Users
  2. DBC.ProfileInfo
  3. DBSessionInfo
  4. DBC.Accountinfo

Answer(s): B



Which is updated when you change password features such as expiration, reuse, minimum and maximum length?

  1. DBC.Users
  2. DBC.LogOnOff
  3. DBLogonRules
  4. DBC.SysSecDefaults

Answer(s): D






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

Join the NR0-014 Discussion