Which four statements are true about constraints on Oracle tables? (Choose four.)
Which four statements are true about constraints on Oracle tables? (Choose four.)
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.
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
ABEF are corecct
ABEF seems correct
ABEF is correct
For my opinion correct answers BCEF
Check constraint can't refer to other columns
If it's a table constraint it can. create table constr ( total_lectures number(10), total_absences number(10), check (total_lectures >= total_absences) );
maybe it's ABDEF ?