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

TeraData NR0-015 Exam
NR0-015 Tedatata Design Architecture V2R5 (Page 5 )

Updated On: 7-Feb-2026
Page 4 of 23
PDF with 110 Questions

When analyzing volatility as a factor for choosing indexes, what are you measuring?

  1. how unique the column values are
  2. how frequently the column value changes
  3. how frequently the column is used for access
  4. the difference between the maximum and minimum values

Answer(s): B



Referential Integrity (RI) is defined on a table WITH CHECK option. An implicit transaction with multiple inserts is submitted against the table.
What happens when one insert violates the RI?

  1. All the rows inserted are rolled back and an abort message is issued.
  2. An error table is created with a copy of offending column(s) that violated RI.
  3. All rows are inserted. An error message informs the user of which row is the problem rowthat needs to be fixed.
  4. All rows except the one violator are inserted. An error message informs the user whichrow did not get inserted.

Answer(s): A



A row is inserted into a referencing table and foreign key columns are defined to be NOT NULL.
What does the system verify?

  1. It verifies if a row exists in the referenced table that is NOT NULL.
  2. It verifies if a row exists in the reference index subtable with a zero count.
  3. It verifies if a row exists in the referenced table with the same value(s) as that in theforeign key column(s).
  4. It verifies if a row exists in the referenced table with the same values as those in theprimary key of the referencing table.

Answer(s): C



Which two statements are true for "soft" Referential Integrity (RI)? (Choose two.)

  1. The RI is enforced by the database.
  2. The RI is presumed to be enforced outside of the database.
  3. Redundant joins between soft RI defined tables are eliminated.
  4. The PK columns can appear anywhere in the WHERE clause.

Answer(s): B,C



Which three rules apply to a column defined as a foreign key in the referencing table compared to the primary key in the referenced table? (Choose three.)

  1. The data type must be the same.
  2. The case sensitivity must be the same.
  3. The compression values must be the same.
  4. No column in the foreign key (referencing) can be an identity column.

Answer(s): A,B,D



Viewing page 5 of 23
Viewing questions 21 - 25 out of 110 questions



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

Join the NR0-015 Discussion