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-016

TeraData NR0-016 Exam
NR0-016 Teradata Application Development V2R5 (Page 8 )

Updated On: 1-Feb-2026
Page 4 of 23
PDF with 108 Questions

A foreign key constraint is added to a column of a table. However, there are foreign key values in the child table that reference values that are not in the parent table. What are three possible corrective actions for each row in the error table? (Choose three.)

  1. Delete the row from the child table
  2. Add a row with a null value to the parent table
  3. Change the referencing value in the child table to null
  4. Add a row with the referenced value to the child table
  5. Add a row with the referenced value to the parent table

Answer(s): A,C,E



Which two statements are true about the following ALTER TABLE statement. (Choose two.) ALTER TABLE Table_1 ADD CHECK (Col_a > 0 OR Col_b > 0);

  1. The table must be empty.
  2. The constraint is unnamed.
  3. A table level check constraint is place on Table_1.
  4. Only one of the two columns may be greater than zero.
  5. The constraint may be changed with the MODIFY CONSTRAINT syntax.

Answer(s): B,C



Which three SQL statements are allowed in a triggered statement? (Choose three.)

  1. EXEC
  2. DELETE
  3. CREATE
  4. COMMIT
  5. INSERT SELECT

Answer(s): A,B,E



What happens when you create a foreign key constraint on a populated table?

  1. Existing rows are not checked for violations.
  2. Any foreign key violations are copied to an error table.
  3. Any foreign key violations are deleted from the table.
  4. An error is returned when creating a foreign key constraint on a populated table.

Answer(s): B



When can a user access a table via the primary index while it is being loaded with the TPump utility?

  1. When the user is DBC
  2. Only after the data has been loaded
  3. When the user is the owner of the table
  4. When the user issues a LOCKING FOR ACCESS

Answer(s): D



Viewing page 8 of 23
Viewing questions 36 - 40 out of 108 questions



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

Join the NR0-016 Discussion