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 6 )

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

User A creates Database X.
Which three rights are automatically granted to User A on Database X? (Choose three.)

  1. CREATE USER
  2. CREATE TABLE
  3. CREATE INDE X
  4. CREATE DATABASE
  5. CREATE REFERENCES

Answer(s): A,B,D



Which clause in a CREATE VIEW statement restricts the rows in a table that can be inserted by users?

  1. USING
  2. WHERE
  3. SELECT
  4. WITH CHECK OPTION

Answer(s): D



What is the maximum number of levels a role can be nested?

  1. one
  2. two
  3. There is no limit on the number of nested levels.
  4. The limit is determined by the default system setting.

Answer(s): A



Which two clauses in a CREATE VIEW statement restrict the rows in a table that can be updated by users? (Choose two.)

  1. USING
  2. WHERE
  3. SELECT
  4. WITH CHECK OPTION

Answer(s): B,D



A DROP USER command is issued on a user who is assigned to a role. From which two system tables are rows deleted? (Choose two.)

  1. DBC.AMPUsage
  2. DBC.RoleGrants
  3. DBSessionInfo
  4. DBC.AccessRights

Answer(s): B,D






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

Join the NR0-014 Discussion