QUESTION: 13

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

It verifies if a row exists in the referenced table that is NOT NULL.
It verifies if a row exists in the reference index subtable with a zero count.
It verifies if a row exists in the referenced table with the same value(s) as that in theforeign key column(s).
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

Reveal Solution Next Question

QUESTION: 14

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

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

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 15

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

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

Answer(s): A,B,D

Reveal Solution Next Question

QUESTION: 16

What are two reasons for choosing a NUPI? (Choose two.)

It allows clustering of data rows.
It allows duplicate rows in a set table.
It is a closer match for the primary key.
It allows the user to generate a much larger table.
It facilitates AMP-local joins of matching sets.

Answer(s): A,E

Reveal Solution Next Question

Free NR0-015 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16

NR0-015 Discussions & Posts