Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 220

Which four statements are true about constraints on Oracle tables? (Choose four.)

    Correct Answer: A, B, E, F

    A PRIMARY KEY constraint can be added after a table has been created and populated because Oracle allows adding constraints to existing tables. A FOREIGN KEY column can contain NULLs because NULL values do not violate referential integrity. A UNIQUE constraint can use a pre-existing index on the constrained column or columns to enforce uniqueness without creating a new index. A UNIQUE constraint permits NULLs because NULLs are not considered equal to other NULLs, thus they do not violate the uniqueness constraint. A CHECK constraint cannot refer to values in other rows; it only applies to the values in the columns of the row where it is defined. A NOT NULL constraint is defined at the column level, not the table level. A column can have multiple CHECK constraints, not just one.

Discussion
CMjerOptions: ABEF

A, B, E, F are true. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/constraint.html#GUID-1055EA97-BA6F-4764-A15F-1024FD5B6DFE

fasolazgrochemOptions: ABEF

ABEF are corecct

yaya32Options: ABEF

ABEF seems correct

lucemqyOptions: ABEF

ABEF is correct

Orxan_HOptions: BCEF

For my opinion correct answers BCEF

lucemqy

Check constraint can't refer to other columns

mrcsp

If it's a table constraint it can. create table constr ( total_lectures number(10), total_absences number(10), check (total_lectures >= total_absences) );

zouve

maybe it's ABDEF ?