READ Free Dumps For Oracle- 1z0-001
| Question ID 9062 | DRAG DROP
|
Explanation Explanation/Reference: Answer: Explanation : The NOT NULL constraint prevents the data value defined by any row for the column from being NULL. The UNIQUE constraint prevents the data value by any row for the column from being duplicated. The PRIMARY KEY constraint prevents duplications and NULL values for columns that are part of PRIMARY KEY. The CHECK constraints allow Oracle to verify the validity of data being entered on a table against a set of constants that acts as valid values. The FOREIGN KEY constraint creates referential integrity between two columns in the same table or two tables. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 100-105 Chapter 3: Creating Oracle Database Objects
| Question ID 9468 | DRAG DROP
|
| Option F | Explanation/Reference:
Answer: Explanation :
The NOT NULL constraint prevents the data value defined by any row for the column from being NULL.
The UNIQUE constraint prevents the data value by any row for the column from being duplicated.
The PRIMARY KEY constraint prevents duplications and NULL values for columns that are part of PRIMARY
KEY.
The CHECK constraints allow Oracle to verify the validity of data being entered on a table against a set of
constants that acts as valid values. The FOREIGN KEY constraint creates referential integrity between two
columns in the same table or two tables.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 100-105 Chapter 3: Creating Oracle
Database Objects
|
| Correct Answer | F |
Explanation